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

JCL includes the following 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.