MVSFORUMS.com

[Jai]

Hi Team,

Please let me know equivalent command of Describe in DB2 Mainframes.
In DB2 Web one, it is as follows:
For describe in db2 in db2cmd

C:\>db2 describe select * from <table name>

I get to know about the NOT NULL Fields through DCLGEN or through SYSIBM.SYSTABLES.

But I want to know the equivalent command in DB2 Mainframes which will be very useful.


And also if anybody has generated the Explain Report for SQL from BMC Products, please let me know how to save it into PDS so that I can ftp it and send the report. Otherwise it takes long time to copy and paste all the report to Word File.
And also about the Sort A Sort B Commands with F4 and F5 Function Keys.

Thanks in advance.
_________________
Have a Great Day.
Thanks & Regards,
Jai

[naren_ab]

Hi Jai
I think describe gives the details(like columns and there data type etc) of the table you want..
SYSTABLES will give the table description only.

If you can try a query on SYSIBM.SYSCOLUMNS with TBNAME = the name of the table you want, that might help you.
You can run this in either SPUFI or QMF or any otherway, and save the output in file, download to your computer and open it in the way you want.


Hope this helps.

[Jai]

Hi Naren,

Thanks for the information.
I know to do from sysibm.syscolumns. I want to know if any command is there called describe or so in db2 mainframes and if so what is that command which will be useful.
And also about the Explain report if anybody knows.


Thanks in advance.
_________________
Have a Great Day.
Thanks & Regards,
Jai

[kolusu]

Jai,

Please SEARCH before posting. Check this topic ( the last post by me) discusses about EXPLAIN

http://www.mvsforums.com/helpboards/viewtopic.php?t=215

Hope this helps...

cheers

kolusu