DataFlux Data Management Studio 2.6: 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 field in the Target Table Options dialog and 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:

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.

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfU_SQL_QryFlow_Insert.html