Was this helpful?
SQL Step
The SQL step provides the ability to execute SQL statements with a database.
The SQL step is primarily used to execute SQL statements that do not return data, for example, DDL statements. The syntax of the statements depends on the type of the database being used. To execute stored procedures that return values to the process, you must use a DJImport object in a script step. The SQL step does not return data to the process.
Note:  The Process editor allows you to access third-party executable applications using internal steps, such as an executable or SQL statement. However, technical support engineers do not help build or debug code written in other applications.
SQL Step Properties
After adding an /download/attachments/25952281/SQL_step.png?version=1&modificationDate=1491995674905&api=v2 SQL step from the Palette to the canvas, you can double-click the step on the canvas and specify the following step properties in the Properties tab displayed at the bottom.
Name
Description
Name
Unique name for the step. You can use alphabets, numbers, and special characters such as -, _. . , and #.
Description
Description for the step (optional).
Enabled
Select this option to enable the step for execution. If it is not enabled, then the step on the canvas is greyed-out.
This option is useful when troubleshooting a process, especially when there are numerous steps in the process.
Error Handling
Select either of the following:
Abort Process - All the steps after the current step are skipped or the entire process is stopped (depending on how you have set the error logging options) if this step stops due to an error.
Ignore Error - The remaining steps in the current process are executed even if this step stops due to an error. This is selected by default.
Choose a SQL Session
Select a SQL session. These sessions are displayed in the drop-down list when you add SQL sessions in the Configuration tab. For more information, see Configuring SQL Sessions in Configuring Processes.
Note:  Multiple SQL steps can use the same SQL session.
SQL Statement
SQL statement to use in the step.
SQL file
Click Browse and specify the SQL script to use in the step.
To escape from SQL into a script during a SQL statement to access and manipulate variables, use DJX. See Script Statements.
Note:  You can specify an SQL Statement or an SQL file but not both.
Last modified date: 08/02/2023