Item name | Required/Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Name | Required | Not available | Enter the name on the script canvas. | |
Input data | Optional | Not available | Select the component on the script canvas. |
|
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 .
|
|
SQL statement | Required | Available | Enter the SQL statements to issue to the database. |
|
Schema definition | Optional | - | Sets SQL parameters specified in [SQL statement]. |
|
Schema Definition / Column name | Required | Not available | Set the SQL parameter name. |
|
Schema definition / Type | Required | Not available | Select the SQL parameter type. |
|
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 ". |
|
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 . |
|
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. |
Component variable name | Description | Remarks |
---|---|---|
count | Returns the total number of written data. |
|
error_code | When an error occurs, Dr.SumEA returns the error status in decimal value. If no error occurred, returns null. |
|
message_category | Stroes the category to which corresponding message code belongs to, when an error occurs. |
|
message_code | Stores its corresponding message code of occured error. |
|
message_level | Stores the severity of the corresponding message code of the occured error. |
|
error_type | Stores the type of the occured error. |
|
error_message | Stores the error message for the occured error. |
|
error_trace | Stores stack trace of the occurred error. |
|
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]. |