DataFlux Data Management Studio 2.7: User Guide

Insert Rows (Select) Node

Use an Insert Rows (select) node in a process job to insert rows into a table. When you open the node, you see an SQL query that you can use as a template for inserting rows into a table 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.