Read Table/View

Operation Name

Read Table/View

Function overview

Dr.Sum EA reads the data that is stored in a table.

Data Model

Data model of this type of component is table model type.

Properties

For information about using variables, refer to "variables".
Basic settings
Item name Required/Optional Use of Variables Description Remarks
Name Required Not available Enter the name on the script canvas.  
Required settings
Item name Required/Optional Use of Variables Description Remarks
Destination Required Not available Select Global Resources.
Refer to "Global Resource Properties" for global resource settings .
  • [Add]:
    Adds new global resource.
  • [Edit list]:
    Global resource settings can be managed from "Edit Resource list".
  
Table name Required Available Select or enter the name of the table to read.
  • Distributor will not be displayed.
Schema definition Required - Shows the schema definition specified in [Table name].
  • Of all the columns shown in [Schema definition], the column name with [Target] checked is displayed in the Mapper schema.
  • Schema definition cannot be viewed in the following cases.
    • If do not have read permissions to the specified table
    • If the specified table does not exist
    • If [Table name] is specified by variable
    • If [Table name] is not entered
    • If error occurs in [Table name]
Schema definition / Target Optional Not available Select whether the table column specified in [Table name] is included in Target.
  • [Checked]: (default)
    Included in Target.
  • [Not Checked]:
    Not included in Target.
  • The checked column name is displayed in the Mapper schema.
  • Checking a checkbox in the header enables bulk operation.
  • There needs to be at least one checked column.
Schema definition / Column name Required Not available Shows the column name of the table name specified in [Table name].  
Schema definition / Type Required Not available Select [Column name] type.
  • Displayed in the format of "Native type (Internal data type)" .
    • Native type:
      Dr.Sum EA specific data type.
    • Internal data type
      Data type used internally in DataSpider.
      Refer to "here" for details .
Property Action
Item name Description Remarks
Show table information Displays the structure, content and related information of tables of the database specified in [Destination].
Refer to "Table Information"for table information .
  • Enabled when [Destination] is selected.
  • A distributor cannot be selected.
  • Distributors are not shown in [Table name].
Update schema definition Updates the schema definition specified in [Table name].
  • In the following cases it can not be executed.
    • If the specified table does not exist
    • If [Table name] is specified by variable
    • If [Table name] is not entered
    • If error occurs in [Table name]
Data processing method
Item name Required/Optional Use of Variables Description Remarks
Mass data processing Required Not available Select a data processing method.
  • [Use script settings]: (default)
    Apply mass data processing settings of script property to adapter.
  • [Disable]:
    Mass data processing is not performed.
  • [Enable]:
    Mass data processing is performed.
  
Comment
Item name Required/Optional Use of Variables Description Remarks
Comment Optional Not available You can write a short description of this adapter.
The description will be reflected in the specifications.		  

Schema

Input Schema

None.

Output Schema

Depending on the settings for the [Schema definition] the number of columns may vary.
See "Schema of Table Model" for details regarding schema structure .

Loading schema in Mapper

Schema is loaded automatically.
See "Edit Schema"for any details .

Mass data processing

Mass data processing is supported.

PSP Usage

PSP is supported.
For details on PSP, refer to "Parallel Stream Processing".

Available Component variables

Component variable name Description Remarks
count Returns the number of record read.
  • The value defaults to null.
  • Null when using Parallel Stream Processing.
error_code When an error occurs, Dr.SumEA returns the error status in decimal value. If no error occurred, returns null.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version.
message_category Stroes the category to which corresponding message code belongs to, when an error occurs.
  • The value defaults to null.
message_code Stores its corresponding message code of occured error.
  • The value defaults to null.
message_level Stores the severity of the corresponding message code of the occured error.
  • The value defaults to null.
error_type Stores the type of the occured error.
  • The value defaults to null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The message may vary depending on DataSpider Servista version.
error_message Stores the error message for the occured error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version.
error_trace Stores stack trace of the occurred error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version or the client application used.

Specification Limits

About specifications, please refer to the following page.

Main exceptions

Exception name Cause Solution
ResourceNotFoundException
Resource definition could not be found.Name: []		 [Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition could not be found.Name: [<name of Global Resources>]		 Resource definition selected in [Destination] is not found. Check the global resource specified in [Destination].
InvalidPropertyConfigurationException [Table name] is not set. Specify the [Table name].
InvalidPropertyConfigurationException
Target is not selected.		 [Target] in [Schema definition] is not selected. Select one or more [Target] in [Schema definition].

Notes

About specifications, please refer to the following page.