DataFlux Data Management Studio 2.7: 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 the Query 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.

Another problem occurs when you use a Create Table(select) node in a process job. A process job can contain federation server custom connections in which a SAS table is followed by any other database management system such as Oracle or DB2. If you select the second, non-SAS table, the job fails in the Create Table(select) node. This problem occurs because the current catalog is not being set before running the query.