Using the Relational Data Framework › Invoking SQL Statements › Destinations of SQL-related Error Messages

Destinations of SQL-related Error Messages

When an SQL statement is processed, it produces a return code that becomes the value of a variable named SQLCODE. When the value of the SQLCODE variable is not equal to 0, CA OPS/MVS writes error messages to a particular destination. The destination is dependent upon the environment from which the SQL statement was invoked.

When you use the ADDRESS SQL host environment to invoke an SQL statement from an AOF rule or OPS/REXX program, error messages are sent to the external data queue.

When you use the OPSQL command processor to invoke an SQL statement from:

• A TSO terminal, error messages are PUTLINEd to the terminal.
• A TSO/E REXX program, error messages are either trapped in stem variables or PUTLINEd to the terminal, depending on the current setting of the OUTTRAP() function.
• A TSO CLIST, error messages are either trapped in &SYSOUTLINE variables or PUTLINEd to the terminal, depending on the value of &SYSOUTTRAP.