Using Secondary Output Streams with SQL

SQL EXECUTE processes multiple I/O requests from the primary input stream that has multiple insert, or query statements, or a mixture of these.

The results of the queries are written to the primary output stream, and have the color attribute green (CG). Output data is written using Tivoli® NetView® for z/OS® message type double quotation mark (HDRTYPEK).

If the secondary output stream is defined and connected, any error messages are written to it. If a secondary stream is not defined, error output is not sent to the primary stream, but escapes to the parent pipe or is displayed. Error messages also have the color attribute red (CR). Error messages are written with the Tivoli NetView for z/OS message type apostrophe (HDRTYPEJ).

Diagnostic messages (from the SQL TEST or DIAGNOSE options) are color-coded yellow (CY) and are written to the secondary stream. Diagnostic messages are written with the Tivoli NetView for z/OS message type apostrophe (HDRTYPEJ).