sql-text
This command provides the literal string statement for the SQL statement action.
Syntax
sql-text statement
Availability
SQL-ODBC feature.
Parameters
- statement
- Specifies the SQL statement.
Guidelines
The sql-text command is required when the action type, as set by the
type command, is sql and the sql-source-type
is static.
Example
Define the SQL statement action to run the
SELECT SSN, BaseSalary FROM Senior
Management statement against the db2Source data
source.# type sql
# sql-source db2Source
# sql-source-type static
# sql-text "SELECT SSN, BaseSalary FROM SeniorManagement"