z/OS Communications Server: IP User's Guide and Commands
Previous topic | Next topic | Contents | Contact z/OS | Library | PDF


With NOSPRead and SQLCol=Labels

z/OS Communications Server: IP User's Guide and Commands
SC27-3662-00

The following output is from a query using NOSPRead and SQLCol=Labels.
s--------+---------+---------+---------+---------+---------+---------+---------+
SELECT DISTINCT ABC.STAFF.TLA, ABC.STAFF.SALARY
FROM   ABC.STAFF, ABC.HOURS
WHERE  (ABC.STAFF.TLA = ABC.HOURS.TLA) AND
       (ABC.HOURS.TOTAL > 40)
h--------+---------+---------+---------+---------+---------+---------+---------+
EMPLOYEE'S INITIALS    SALARY
d--------+---------+---------+---------+---------+---------+---------+---------+
ACO                  20050.00
SJJ                  19040.00

Go to the previous page Go to the next page




Copyright IBM Corporation 1990, 2013
This information center is Built on Eclipse™ ( www.eclipse.org ).