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


With NOSPRead and SQLCol=Names

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

The following output is from queries using NOSPRead and SQLCol=Names.
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--------+---------+---------+---------+---------+---------+---------+---------+
TLA    SALARY
d--------+---------+---------+---------+---------+---------+---------+---------+
ACO  20050.00
SJJ  19040.00
and
s--------+---------+---------+---------+---------+---------+---------+---------+
SELECT * FROM ABC.STAFF
h--------+---------+---------+---------+---------+---------+---------+---------+
EMPLOYEE              TLA      AGE    SALARY
d--------+---------+---------+---------+---------+---------+---------+---------+
Steve Jasinski        SJJ       23  28040.00
Alison Cook           ACO       22  28040.00
Mark Ballam           MFB       63  87420.55

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 ).