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: 4648
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: 2033
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 Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Customizing the ISPF HILITE Command Pedro TSO/ISPF 3 Fri Mar 03, 2017 11:49 pm
No new posts To know activities on db2 tables ashek15 DB2 4 Fri Mar 03, 2017 11:23 pm


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