Submitting DDL through the SQL Batch utility

You can use the SQL Batch utility in IMS to submit DDL and other specific SQL statements to IMS. The IBM® Java™ for z/OS® (JZOS) Batch Launcher is used to invoke the statements from a standardized z/OS job.

Prerequisites: Before you can run the SQL Batch utility, the following prerequisites must be met:
  • The IBM Java for z/OS (JZOS) Batch Launcher is installed.
  • The IMS Open Database solution is installed.
  • The IMS catalog is installed and configured.

To submit SQL statements with the SQL batch utility, complete the following steps:

Procedure

  1. Create the SQL statements to be run.
    You can specify all of the SQL statements and syntax that the IMS Universal JDBC driver supports and the CONNECT, COMMIT, ROLLBACK, and DISCONNECT statements. Each SQL statement must be delimited with a semicolon.

    The SQL statements can be submitted inline with the JCL, from a data set on z/OS, or from a file on UNIX System Services (USS).

  2. Set up the JCL to run the SQL Batch utility.
  3. Submit the JCL.