Accessing and Maintaining Relational Databases (SQL Tables)

Tivoli® NetView® for z/OS® SQL stages can use DB2® if the Tivoli NetView for z/OS task DSIDB2MT is started and is connected to a DB2 subsystem. Records are passed between DB2 and the Tivoli NetView for z/OS SQL stage without changing the format of fields, for example, integers are not printable in a query. This gives you control over the format of data moving to and from the database. However, the following sample program SQSELECT, which is supplied with Tivoli NetView for z/OS SQL stages, formats a query and converts data from internal representation to character strings:

SQSELECT * from inventory where substr(description,1,4)='S390'

  SUBAREA_NO DESCRIPTION------------- JOBS_ACTIVE
        +221 S390 Raleigh NC                +2000
        +222 S390 Austin TX                 +1250