Issuing Adapter Commands

How to:

The Direct SQL Passthru facility provides support for issuing adapter environmental commands.

Note: Commands that you issue from MODIFY procedures, like LOADONLY, ERRORRUN, and AUTOCOMMIT ON CRTFORM, use a slightly different form of syntax that is described in Parameters That Apply to MODIFY Only.
Top of page
x
Syntax: How to Issue Adapter Commands
{ENGINE|SQL} [sqlengine] SET command value 

where:

sqlengine

Indicates the target RDBMS. Valid values are DB2, SQLDBC, SQLIDMS, or SQLORA. Omit if you previously issued the SET SQLENGINE command.

command

Is an environmental command.

value

Is an acceptable value for the environmental command.

Information Builders