The SQL Stage

The SQL stage connects the Tivoli® NetView® for z/OS® program to the relational database product IBM® DATABASE 2 (DB2®) for MVS™. Potential users of SQL include the following:

• Novice users of DB2 and Tivoli NetView for z/OS pipelines:
  • SQSELECT is a Tivoli NetView for z/OS REXX procedure to format a query for display.
  • Input lines read by a Tivoli NetView for z/OS SQL stage are issued as DB2 statements such as INSERT or SELECT statements. The format of data is the internal DB2 format; use the EDIT stage to convert between external and internal formats.
• Tivoli NetView for z/OS SQL stage users who are new to DB2. Advanced DB2 education is outside the scope of this book. See the examples provided and DB2 publications to learn about DB2.

  The REXX samples provide program templates, illustrating the major steps to be performed. Writing SQL applications using Tivoli NetView for z/OS pipelines eliminates many of the programming details, such as DB2 precompilation, reentrant considerations, and the details of memory management.