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".
|
|
SQL statement |
Required |
Available |
Enter the SQL statements to issue to the database. |
|
Sort encoding |
Required |
Not available |
Select the sorting order of data when output by specifying ORDER BY.
- [UTF-8]:(default)
Sorts in UTF-8.
- [Shift_JIS]:
Sorts in Shift_JIS.
|
- Select [Shift_JIS] when sorting with 2.x compatible.
|
Schema definition |
Required |
- |
Shows the schema definition of the SQL statement specified in [SQL statement]. |
- Column name shown in [Schema definition] is displayed in schema of Mapper.
|
Schema Definition / Column name |
Required |
Not available |
Shows the column name of the SQL statement specified in [SQL statement]. |
|
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 .
|
Item name |
Description |
Remarks |
Refresh connection |
Refresh the connection to the newest status. |
|
SQL Wizard |
Start the SQL Wizard.
For instructions, refer to "SQL Wizard-Help ".
|
- SQL statements specified in [SQL statement] can not be edited with wizard.
- Distributor will not be displayed.
|
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.
- Distributor cannot be selected.
|
Execute SQL statement to set schema |
Get schema information from the SQL statements specified in [SQL statement] and set to [Schema definition]. |
- If [SQL statement] is not specified, it cannot be executed.
- If script variable is specified in [SQL statement], it would be possible to execute by input value in variable.
- If you do not input value, it will be executed in null character.
- input value will not effect an execution of script.
|
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.
|
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 |
[SQL statement] is not specified. |
Please specify [SQL statement]. |