JCL for SQL

The Automation Engine scripting language provides script elements for SQL jobs. Results are written to a report. Use PREP_PROCESS_REPORT to read the results.

Script Elements for SQL

• SQL_EXECUTE_JOB
  Executes a job on an MS SQL Server

• SQL_GET_COLUMNS
  Supplies information about the columns of a table

• SQL_GET_JOBS
  Supplies a list of all defined jobs of an MS SQL Server

• SQL_GET_TABLES
  Lists all database tables

• SQL_ON_ERROR
  Determines the reaction to SQL errors

• SQL_ON_ROWCOUNT_ZERO
  Determines the return code if an SQL statement does not supply a hit

• SQL_SET_STATEMENT_TERMINATOR
  Determines the character that terminates SQL statements