How to Describe a Table in SPUFI or QMF



IBM's flagship relational database management system

How to Describe a Table in SPUFI or QMF

Postby prasadnaidu » Tue Aug 18, 2009 8:55 pm

Hai I want to see the Table Structure in SPUFI

Any One May Help You
prasadnaidu
 
Posts: 14
Joined: Fri Aug 14, 2009 10:25 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to Describe a Table in SPUFI or QMF

Postby dick scherrer » Wed Aug 19, 2009 1:02 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to Describe a Table in SPUFI or QMF

Postby prasadnaidu » Wed Aug 19, 2009 10:01 am

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.
prasadnaidu
 
Posts: 14
Joined: Fri Aug 14, 2009 10:25 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to Describe a Table in SPUFI or QMF

Postby dick scherrer » Wed Aug 19, 2009 11:40 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to Describe a Table in SPUFI or QMF

Postby manojlives » Fri Nov 06, 2009 5:05 pm

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.
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to Describe a Table in SPUFI or QMF

Postby swd » Fri Nov 06, 2009 7:28 pm

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  ;     
User avatar
swd
 
Posts: 109
Joined: Wed Feb 18, 2009 9:18 pm
Location: UK
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post