Path variables in task step parameters of type SQL Command

In task step parameters of type "SQL Command", path variables other than $$unpack and $$using are allowed in:

•INVOKE XML.EXPORT

•INVOKE XML.IMPORT

•INVOKE USXSL.APPLY2FILE

•INVOKE BATCHRUNNER.job

if the SELECT output list contains only one or more of the following:

•Constants,

•Simple column names,

•The '*' wildcard.

In other words, a SELECT output list using a path variable may NOT also contain any SQL functions. Non-quoted and double-quoted aliases are allowed. Constants may be single-quoted (string constants) or non-quoted (numeric constants).

Path variables in task step parameters of type "SQL Command" are resolved when you have the task checked (press the Check button in the Define Tasks window). You can inspect the result in the Value column of the Parameters box.

Examples

For examples, go to the "Run SQL command" help topic.