Code Editor Tab

You can use the Code Editor tab to explicitly define, import, or export user-written SQL code. The tab contains the following elements:

Connection - Enables you to specify a data connection.

Data Connections Riser Bar - Displays the Data Connections tree. You can open a connection in a tree and access the tables that it contains.

Toolbar - Contains following functions for working with SQL code:

• Run process job
• Run node
• Pause, stop, and resume query
• Arithmetic functions: addition, subtraction, multiplication, and division
• Comment line
• Logical functions: And, Or,and Not
• Operators: equal, not equal, less than, less than or equal, greater than, and greater than or equal
• Concatenate strings
• Enclose in quotation marks
• Enclose in parentheses
• Import SQL code from a file
• Export SQL code to a file

Code Pane - Contains the code that you want to execute. You can add tables and functions. You can also import existing code.

Data Sample - Displays sample data from a table that you select in the Data Connections tree.

Functions Riser Bar - Displays the Functions tree, which contains the available functions for each type of data connection.

Log - Displays the log for the code that you run in Code Editor tab. Click Show Details to display or hide the log.