IBM Mainframe Forum

I am using SPUFI and would like to see the Column Definitions of a table.
I have been searching the net, but for some reason cannot find the statement.
Could someone plz help me?
I just want to see the datatype of each of the columns. Thanx in advance.

Jerry

Hello,

Try this:

Maybe I asked the question incorrectly. I did try the code
and did nto get the results I am trying to find.

SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = 'ZOS111.DSN8910.EMPQA' 001535
AND TBCREATOR = 'QA1' ORDER BY COLNO; 001536
---------+---------+---------+---------+---------+---------+---------+--------
NAME
---------+---------+---------+---------+---------+---------+---------+--------
DSNE610I NUMBER OF ROWS DISPLAYED IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+---------+--------
-- 001537
SELECT * FROM ZOS111.DSN8910.EMPQA; 001538
---------+---------+---------+---------+---------+---------+---------+--------
EMPNO FIRSTNME MIDINIT LASTNAME WORKDEPT PHONENO HIREDATE
---------+---------+---------+---------+---------+---------+---------+--------
444420 TEST 11... K JOHN......... D11 0672 1968-08-29
000010 CHRISTINE I HAAS A00 3978 1965-01-01
000020 MICHAEL L THOMPSON B01 3476 1973-10-10

I am trying to get the datatype definitions for EMPNO, FIRSTNME, MIDINIT,
LASTNAME, etc from the ZOS111.DSN8910.EMPQA table. Again, I apologize
for not stating my question correctly.

Problem resolved by testing using SPUFI. This post can be closed! Thanx for
the help in this matter.

Jerry

I hope that isn't real data. From the hire-dates, maybe not, but maybe ballj35 can confirm it is test data only (and not data in any way from production).

Nope just test data I am playing with. Thanx.

Good to hear it is working - thank you for letting us know

d