Page 1 of 1
How to Describe a Table in SPUFI or QMF
Posted:
Tue Aug 18, 2009 8:55 pm
by prasadnaidu
Hai I want to see the Table Structure in SPUFI
Any One May Help You
Re: How to Describe a Table in SPUFI or QMF
Posted:
Wed Aug 19, 2009 1:02 am
by dick scherrer
Hello,
As far as i know, this is not a feature of spufi. . .
Suggest you look in the dclgen library - ask your dba if you are not familiar with the dclgen library.
Re: How to Describe a Table in SPUFI or QMF
Posted:
Wed Aug 19, 2009 10:01 am
by prasadnaidu
Thank u Dick.
I know about the DCLGEN. if i want to use the Structure of Table in Application Program.
What i have to do.
Re: How to Describe a Table in SPUFI or QMF
Posted:
Wed Aug 19, 2009 11:40 pm
by dick scherrer
Hello,
If you describe what you actually want to do, someone may have a suggestion. . .
How might your application program use the table structure information?
If you have read permission on your system, you can get all of the info from the db2 catalog tables. . . That info will probably be more useful than the SQL Create Table source.
Re: How to Describe a Table in SPUFI or QMF
Posted:
Fri Nov 06, 2009 5:05 pm
by manojlives
In QMF , you can describe a table by
Pressing F6 and then
1) Enter the table name
2) Select any one option SELECT /INSERT/UPDATE
3) Press Enter .
You would have drawn the table for that.
Re: How to Describe a Table in SPUFI or QMF
Posted:
Fri Nov 06, 2009 7:28 pm
by swd
Well, SPUFI and QMF are different. If you want to look at the structure of a table in SPUFI then query the DB2 catalog table, for example
SELECT *
FROM SYSIBM.SYSCOLUMNS
WHERE TBCREATOR = 'CREATOR'
AND TBNAME = 'TABLE'
ORDER BY TBNAME, COLNO ;