About SQL JCL

AE provides specific script elements for SQL jobs. Results are written to a report and can be read using PREP_PROCESS_REPORT.

Script element	Description
SQL_EXECUTE_JOB	Executes a job on the MS SQL Server.
SQL_GET_COLUMNS	Supplies information about a table's columns.
SQL_GET_JOBS	Supplies a list of all defined jobs of an MS SQL Server.
SQL_GET_TABLES	Lists all databaseA database is an organized collection of data including relevant data structures. 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.