Executes SQL code inside a database, using ODBC, OCI (Oracle), or CLI (Teradata) interfaces, optionally parameterizing the SQL with data from the input set.
This node runs the SQL query (or queries) that you specify in the Script property. The specified SQL query returns nothing, for example a DML statement such as INSERT, UPDATE, or DELETE, or a DDL statement. For further information, see the Database related section of the Script help.
If there is no input, it will run the query once. If there is an input, it will run the query once per input line.
Properties
Script
Specify the expression controlling how to output to data.
A value is required for this property.
DbUser
Specify the database username.
A value is required for this property.
DbPassword
Specify the database user's password.
A value is required for this property.
DbService
Specify the database instance name.
A value is required for this property.
DbInterface
Specify the type of database interface. Enter one of the following:
- oci
- cli
- odbc
A value is required for this property.
CommitFrequency
Optionally specify how many rows to process before committing changes to the database.
SqlDateType
Optionally specify the datatype in which to map a SQL DATE. Choose from:
- date
- datetime
Inputs and outputs
Inputs: 1 optional.
Outputs: Multiple optional.