Issuing Data Adapter Commands

The Direct SQL Passthru facility provides support for issuing data 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.

Syntax: How to Issue Data Adapter Commands

SQL [sqlengine] SET command value

where:

sqlengine

Indicates the target RDBMS. Valid values are DB2, SQLDS, 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.