DataFlux Data Management Studio 2.5: User Guide

Query Flow Tab

You can use the Query Flow tab to retrieve rows from one or more tables and inserts them into an existing table. This operation uses an SQL query that is contained in a process job. The Query Flow tab contains the following elements:

Target table - Specifies the target table for the inserted rows.

Type - Determines whether the target is a table or a view.

Delete table if it exists - Specifies that the existing table is removed before the new rows are inserted.

Options - Displays the Target Table Options dialog. You can use this dialog to set type and target table options for the new table. You can also specify that space is included before the options and add storage options to the end of the statement.

For example, you could set the following options when you create a table:

Create <Type options> table|view <tablename> <Target table options>As Select... <Storage options>

Using this syntax, you could create the following SQL code:

Create global temporary table Customers as select * from

where global temporary is the string entered in the Type options fieldin the Target Table Options dialogand Customers is the table name. You can use the Type options field to access the options available for the DBMS type of your source data.

Nodes Riser Bar - Displays the nodes that you can add to the Query Flow Editor. The nodes are divided into Clauses and Joins categories. The toolbar above the Nodes Riser Bar enables you to insert a selected node and insert selected nodes before or after nodes that you select in the Query Flow Editor.

Data Connections Riser Bar - Displays the available data connections. You can add the tables listed here to the Query Flow Editor. The toolbar above the Data Connections Riser Bar enables you to insert a selected item and insert tables before a selected node.

Query Flow Editor - Hosts the query flow. You can drop nodes and tables into the Query Flow Editor and manipulate them as needed. The toolbar above the editor provides the following controls:

• Action Menu - Enables you to access utility functions that affect process flows and process flow nodes.
• Open - Enables you to access the Table Information display for a selected table, which includes the Fields, Data Model, DataViewer, and Graph tabs.
• Edit - Enables you to edit a selected object in the Query Flow Editor.
• New Note - Adds a note to the Process Flow Editor.
• Run Process Job - Submits the job contained in the Process Flow Editor for processing.
• Run SQL Query - Submits the query contained in the Process Flow Editor for processing.
• Resume SQL Query - Resumes a paused query.
• Pause SQL Query - Pauses running query.
• Stop SQL Query - Stops a running query.
• Preview - Runs a preview of the query. You can also click the Preview tab in the Details pane. If you select a table, it will show you a preview of the table. If you select any clause node, it will preview the entire query.
• Layout - Toggles between Left To Right and Top To Bottom layouts
• Zoom - Zooms into and out of the Process Flow Editor.
• Reset Zoom - Resets the Process Flow Editor to the default level.

SQL Navigation Tree Riser Bar - Displays the SQL components of the current query. You can click the name of a component to open it in a tab.

Data Sample Riser Bar - Displays sample data for a selected field from a table in the Query Flow Editor or the Data Connections Riser Bar. The data displayed does not include null or empty values. It does include duplicate values.

Overview Window - Displays an overview window of the full query flow. You can grab and drag the window to focus on particular segments of the flow.