Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

capturing data from ispf tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
preddy
Warnings : 1

New User


Joined: 21 Apr 2009
Posts: 5
Location: bangalore

PostPosted: Tue Apr 21, 2009 3:17 pm    Post subject: capturing data from ispf tables
Reply with quote

I got a request for capturing the data from ispf tables.
I need to capture the jcl name, pgm name, file name, other info from the 4 different tables and need to generate the report.

Please give me the start up in this request.

Thanks
preddy
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4649
Location: Raleigh, NC, USA

PostPosted: Tue Apr 21, 2009 3:48 pm    Post subject: Reply to: capturing data from ispf tables
Reply with quote

Where are you stuck? Can we presume that these four tables already exist and that you know how their variables are defined?
Back to top
View user's profile Send private message
preddy
Warnings : 1

New User


Joined: 21 Apr 2009
Posts: 5
Location: bangalore

PostPosted: Tue Apr 21, 2009 4:00 pm    Post subject: capturing data from ispf tables
Reply with quote

Hi,
Thanks for response..

Data in all the four tables are available.
first iam calling the tables with : top_jcltab, top_cobtab etc and iam trying to relate all the 4 tables with a common key.., the relation will be in the following way..

JCL PGM File Other info
jcl1 pgm1 infile
pgm2 outfile
jcl2 pgm3 rptfile

JCL name and the programs reffered by jcl, files.

does this information fine or can i provide some more

Pradeep
Back to top
View user's profile Send private message
Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2051
Location: Silicon Valley

PostPosted: Tue Apr 21, 2009 9:20 pm    Post subject: Reply to: capturing data from ispf tables
Reply with quote

Quote:
capturing the data

Can you elaborate on what it means to 'capture' the data?

Your example is not very clear. I cannot discern the relationship. Please organize by table name and key names (plus a few examples of key values).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us