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.
To add a SQL step:
1. Drag and drop a 
SQL step from the Palette to the canvas.
SQL step from the Palette to the canvas.2. Double-click the step on the canvas to open the Step Properties tab.
3. Type a unique name for the step.
4. Specify the step properties.
For more information, see Adding Steps.
SQL Step Properties
Name | Description |
|---|---|
Name | Unique name for the step. You can use alphabets, numbers, and special characters such as -, _. . , and #. |
Description | (Optional) Description for the step. |
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: • Stop Process - (Default) All the steps after the current step are skipped or the entire process is stopped (depending on how you have the error logging options set) if this step stops due to an error. • Ignore Error - The remaining steps in this process are executed even if this step stops due to an error. This is useful when you want to write a Decision step that can test for the error state of a previous step. Note: The Break after first error Logging Option on the Configuration tab overrides the Ignore Error option in the step level, hence when you set the Ignore Error option at step level, you should uncheck (disable) the Break after first error Logging option for the Ignore Error to be effective. |
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: 07/26/2024