IBM Mainframe Forum

Hai I want to see the Table Structure in SPUFI

Any One May Help You

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.

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.

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.

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.

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