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.

Note: 

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.