DataFlux Data Management Studio 2.6: User Guide

Inputs Tab

You can use the Inputs tab to add data inputs to a process flow node in a process job. The tab includes a list of inputs to the process flow. The inputs will vary according to the node. Each row in the list specifies the name, description, default value, source binding, and run time value for an input.

The toolbar includes the following elements:

New - Create inputs or input tables, with a name and an optional description.

Edit Default Value - Edit the default value for a selected input. The inputs with the ABC icon are SQL options. Put your cursor over such options to see a description of some valid values for that option.

Note that you can submit only one SQL statement in each SQL Execute node with the SQL_STMT value by itself. However, you can use the Pre_SQL and Post_SQL values to submit additional SQL statements. You can also add multiple SQL nodes to a process job. The following input values have been added to enable you to submit multiple statements using the SQL Execute node:

• DELIMITER - Specifies a character to use as a delimiter. If specified, the SQL_STMT input will be separated into SQL statements using this delimiter, and each will be run in turn. You can use this input to run multiple SQL statements. Do not specify delimiters if you need to use parameters, which are limited to the main SQL statement.
• TRANSACTION - If specified, it must be true or false. If true, the entire operation including the pre and post SQL statements will be wrapped in a transaction that is rolled back if any statement fails.

Specify Source Binding - Specifies the source binding for a selected input.

Show Run Time Values - Displays the run time value for a selected input.

Clear/Delete - Enables you to clear a default value or source binding for a selected input. Also enables you to delete a selected input.

Refresh - Refreshes the list of inputs.

Note: The SQL_Parameters input value is not included on the Input tabs for the Create Table(select) and the Create Table(query reference) nodes. Some databases that are supported in DataFlux Data Management Studio do not provide support for these SQL parameters.

The Inputs table lists the inputs available for the selected node. The table contains the following columns:

• Name
• Description
• Default Value
• On Macro Fail
• Source Binding
• Run Time Value

Note that you can use the drop-down menu in the On Macro column to specify the behavior that occurs when a macro value fails. The setting determines whether the node will fail or the macro will use a null value. This option is enabled only when the default value is not null.