The SQL Transaction activity node
Use the SQL Update activity node for any SQL action, which does not return a result, set with one or more records. You can insert, update, or delete records into a database table using this activity node.
The SQL Update activity node provides a JDBC driver to access any database that is JDBC compliant. The node enables speedy updates and changes to the database. This node bypasses the Services Automation and/or T&E applications' business logic.
The SQL Transaction node can make use of the error connector. See Configuring error handling and the error connector in Infor Process Designer.
This node cannot be used in processes that are executed in a multi-tenant environment.
Properties
| Field | Description |
|---|---|
| Caption | The caption for the node in the diagram on the Designer window. |
| Name | The internal name for the node. |
| General tab | |
| Override JDBC | If this check box is selected, the SQL Query node will use the driver, URL, user, and password information specified in the node instead of values specified in the Designer Login/JDBC tab or the server setup information. |
| Driver | The name of the JDBC driver. |
| URL | The URL for JDBC. |
| User | The JDBC user name. |
| Password | The JDBC user password. |
| SQL Select | Specify/Define the SQL Query. |
| Import button | Select this button to open the File Selection dialog box. Use the File Selection dialog box to import the SQL query saved in a file. Then, paste it to the SQL query string. |
| Build button | Select this button to open the SQL Update String Builder. |
| Stop process on SQL error | Select this check box to stop the processif any error on the SQL query execution. |
| Variables | Displays all of the variables available for use in this node. |
|
Description tab The description of the activity. |
|
SQL Update String Builder
You can use the manual process (described above), or you can use the SQL Update String Builder Wizard to help you create the following SQL functions:
-
Add – To add a record into a table
-
Delete – To delete a record from a table
-
Change – To update a record in a table
Output variables
| Field | Description |
|---|---|
|
NODENAME_RETURN_ CODE (Integer) |
The return code (where 0=Success and 1=Failure) returned by a Query. |
|
NODENAME_RETURN_ MSG (String) |
The message returned by a query. |
| NODENAME_RECORD_COUNT (Integer) | The number of records that were counted in a query. |