1. Application Runtime for Batch Reference Guide
  2. Oracle Tuxedo Application Runtime for Batch Functions
  3. Reference
  4. Overview
  5. m_ExecSQL
  6. Options

2.4.1.12.4 Options

-b RC0
With -b RC0, whether encountering errors or not, all SQL will be executed and then all successful SQL will be committed in the end; however, without -b RC0, if any error is encountered, SQL will rollback when terminating.
-f <inputfile>
The <inputfile> will contain the SQL directives (ddname of the file).

SYSIN is the default value.

-o <outputfile>
The <outputfile> will contain the results (ddname of the file).

SYSPRINT is the default value.

-s <DB_SYSTEM>
Specifies the DB SYSTEM. This "DB SYSTEM" value is used to get the "DB connection credential string" from file specified by global variable MT_DB2_SYSTEM_MAPPING. And then apply it to MT_DB_LOGIN. After this API is executed successfully, MT_DB_LOGIN is restored.

Parent topic: m_ExecSQL