Page 1 of 1

How to Describe a Table in SPUFI or QMF

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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  ;