DataFlux Data Management Studio 2.5: User Guide

Create Table (Select) Node

Use a Create Table (select) node in a process job to create a new table from the results of an SQL SELECT statement. When you open the node, you see an SQL query that you can use as a template for creating tables with a SELECT statement. For more information about the tabs at upper left of this dialog, click the following links:

• Query Flow tab
• Settings tab
• Code tab
• Inputs tab
• Outputs tab
• Node Connections tab
• Log tab

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

Data Sample Riser Bar - When displayed, shows sample data for a selected field from a table in theQuery Flow Editor or the Data Connections Riser Bar.

Parameters are not supported when creating either a table or view.

If the Create Table (select) node has an input from either DB2 using ODBC or the SAS Federation Server with no FedSQL, the query run in the process job will create only the definition of the table. It will not load the data into the table. If you want to have the results of the query loaded into the table, you must add a step to the job to collect the output and insert the query results.

Similarly, if you have an input from Informix that uses ODBC or the SAS Federation Server with no FedSQL, specify the keyword temp in the Type options field in the Target Table Options dialog. However, you will lose this temporary table when you close the connection. Fortunately, you can also create a table definition with the SQL Execute node. Then, you can use the data job Insert nodes to add data to the table. Finally, you can also use the Type options field to specify keywords that you want to use when you have a parallel server installed.