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 database table.
|
- View, multi-table, link table are not shown.
|
Schema definition |
Required |
- |
Specify the schema definition of database. |
- Column name shown in [Schema definition] is displayed in schema of Mapper.
- 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 / 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 .
|
Component variable name |
Description |
Remarks |
count |
The number of records written input. |
- The value defaults to null.
|
insert_count |
Returns the number of rows of data inserted. |
- The value defaults to null.
|
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 |
InputDataNotFoundException |
[Input data] is not specified. |
Specify the [Input data], or draw the data flow. |
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]. |