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: Starting with the 2024.10 release, the SQL Transaction activity node will be deprecated and removed from the Infor Process Designer (IPD) tool, Infor Process Designer for the Web (IPD Web), and runtime server. Additionally, this node is no longer supported in multi-tenant environments and will be removed on a later date. See KB3522595.

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.