DataFlux Data Management Studio 2.7: User Guide

Create Table (Query Reference) Node

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

• Settings tab
• SQL Code tab
• Inputs tab
• Outputs tab
• Node Connections tab
• Log tab

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

If the Create Table(query reference) node has an input from either DB2 using ODBC or the SAS Federation Server with no FedSQL, then 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.