IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Tables in Tablebase library?


IBM Mainframe Forums -> IBM Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Fri Apr 04, 2008 11:16 am
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales

PostPosted: Fri Apr 04, 2008 1:13 pm
Reply with quote

Are we talking ISPF tables, DB2 tables ...... blah blah .............. tables ???
Back to top
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Fri Apr 04, 2008 1:42 pm
Reply with quote

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
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Fri Apr 04, 2008 8:31 pm
Reply with quote

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
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Sat Apr 05, 2008 12:11 pm
Reply with quote

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
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Sun Apr 06, 2008 1:42 am
Reply with quote

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
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Tue Apr 08, 2008 8:12 am
Reply with quote

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
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue Apr 08, 2008 11:48 am
Reply with quote

Let me check.
Back to top
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Thu Apr 10, 2008 2:19 pm
Reply with quote

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
View user's profile Send private message
JayC

New User


Joined: 27 Sep 2008
Posts: 70

PostPosted: Wed Nov 12, 2008 10:29 am
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Wed Nov 12, 2008 11:42 am
Reply with quote

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
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Fri Mar 20, 2009 8:47 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts Calling an Open C library function in... CICS 1
No new posts Submit multiple jobs from a library t... JCL & VSAM 14
No new posts Duplicate several members of/in one l... JCL & VSAM 7
No new posts Issue after ISPF copy to Linklist Lib... TSO/ISPF 1
No new posts Need to fetch data from so many DB2 t... DB2 9
Search our Forums:

Back to Top