View previous topic :: View next topic
|
Author |
Message |
passion_sujesh
New User
Joined: 14 Mar 2008 Posts: 74 Location: India,Chennai
|
|
|
|
Hi,
How can i get the list of tables (with table definition) present in a tablebase library. Can any one please say which utility we have to use and also can any one please give me the syntax for this.
Thanks,
Sujesh. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
Are we talking ISPF tables, DB2 tables ...... blah blah .............. tables ??? |
|
Back to top |
|
|
passion_sujesh
New User
Joined: 14 Mar 2008 Posts: 74 Location: India,Chennai
|
|
|
|
No... It is different from DB2 table...tableBASE is a software tool for reducing the I/O and CPU overhead in mainframe (z/OS
and OS/390) applications. It is a product of data kinetics. |
|
Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
Quote: |
list of tables (with table definition) present in a tablebase library |
Do you have tablebase menu options? in that there is utility and under that PRINT option is available. Can you check that? |
|
Back to top |
|
|
passion_sujesh
New User
Joined: 14 Mar 2008 Posts: 74 Location: India,Chennai
|
|
|
|
Hi Devzee,
There is an option called tablebase online. But i need to run this daily after a particular job ends, so i felt that it will be better to write a batch job to get the details as soon as the job ends (and mail them to concerned person, with a mailing step in the job). I have asked for some documents from data kinetics, but i have not yet received any reply from them. Is there any batch utility which can get the details (table names and definition). If possible can you get the syntax?Thanks in advance.
Thanks,
Sujesh. |
|
Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
Do you want to run this table base listing daily? Why? Are there new tables created daily?
There are batch utilities but I dont remember if it can print all the table names and table definitions. |
|
Back to top |
|
|
passion_sujesh
New User
Joined: 14 Mar 2008 Posts: 74 Location: India,Chennai
|
|
|
|
Hi Devzee,
I need to run this weekly once (every saturday). This is because almost all the tables are geting deleted and recreated and also there are few new tables that are getting created, hence the users want to check if the table definition is fine (for old and the new once). The library will have around 300 tables. Can you please tell me the batch utility and their syntax? Thanks in advance.
Thanks,
Sujesh. |
|
Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
Let me check. |
|
Back to top |
|
|
passion_sujesh
New User
Joined: 14 Mar 2008 Posts: 74 Location: India,Chennai
|
|
|
|
Hi,
By using the utility 'TBDEFPRT' iam able to get the details of all the tables (along with definition) in the tablebase library.But this also displays the table view. Is there any way we can suppress the view details from being displayed.
Thanks,
Sujesh. |
|
Back to top |
|
|
JayC
New User
Joined: 27 Sep 2008 Posts: 70
|
|
|
|
Hi Sujesh,
Do you mind sharing this utility TBDEFPRT ? If its not too much of a trouble? The syntax and how it works ?
Thanks. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
Hi,
it's been a while when Sujesh last posted, I believe he will not be back soon. If you have tool available at your shop check with the documentation about the utility in question, I tried to search a lil but didn't find a good reference material. |
|
Back to top |
|
|
passion_sujesh
New User
Joined: 14 Mar 2008 Posts: 74 Location: India,Chennai
|
|
|
|
Hi,
Sorry for the very late reply, Guess this might help u in near future.
Code: |
//STEP00 EXEC PGM=TBDEFPRT
//SYSPRINT DD SYSOUT=*
//TBDUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//TBRPT DD SYSOUT=*
//SORTMSGS DD SYSOUT=*
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(5,1))
//SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(5,1))
//SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(5,1))
//SORTWK04 DD UNIT=SYSDA,SPACE=(CYL,(5,1))
//SORTWK05 DD UNIT=SYSDA,SPACE=(CYL,(5,1))
//LIB1 DD DISP=SHR,DSN=***.TBLBASE.LIBRARY
//COMMAND DD *
FROMDDN=LIB1;
/*
//* |
This will display the definition of all the table present in the tablebase library.
Thanks,
Sujesh.
Edited: Please use BBcode when You post some code/error, that's rather readable, Thanks... Anuj |
|
Back to top |
|
|
|