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
 

 

Changed column in PDS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Thu Oct 15, 2009 12:21 pm    Post subject: Changed column in PDS
Reply with quote

Hi all,

I have a requirement like open a particular PDS and check the changed column
for current date and list out the elements of current date.

With this element list I have to compare a list of elements available in
spreadsheet and find out the matched elements of both.

I am doing it manually and is there any way to do this using rex or Sort logic.
Atleast taking the elements of current date from a particular PDS.

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

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Thu Oct 15, 2009 12:27 pm    Post subject:
Reply with quote

Hello Karthik,

Requirement is not clear.Would you please provide sample i/p , o/p & record length etc to provide solution?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Oct 15, 2009 12:39 pm    Post subject:
Reply with quote

Quote:
particular PDS and check the changed column


are you referring to the ISPF Statistics?
Back to top
View user's profile Send private message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Thu Oct 15, 2009 12:39 pm    Post subject: Reply to: Changed column in PDS
Reply with quote

the requirment is as below

if you goto PDS using 3.4 you can see many columns like

name created changed ID

and this changed column will have date. So I need the elements which has been changed recently (i.e. current date).
After taking the list of elements from this PDS which has current date I
have to compare this list with another list of elements which is available in
spreadsheet. This comparision has to find out the matched elements and
finally it should list out the matched list of elements which has been changed on current date.

If comparision with spreadsheet is not possible atleast I need some sort logic or Rexx program which will take the elements from the PDS of current date. Pls help me on this.

Thanks
Karthik

Hope the requirement is clear now....
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Oct 15, 2009 12:56 pm    Post subject:
Reply with quote

There are many examples in the REXX forum showing how to extract ISPF PDS statistics (if they exist).

But, based on the level of your knowledge
(displayed by your questions and responses)
I suggest that you continue the manual operation.

If you have a deadline (of say less than 6 months),
The manual operation will be much quicker
than the time required for you learn enough to automate this process.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Thu Oct 15, 2009 1:03 pm    Post subject: Reply to: Changed column in PDS
Reply with quote

furthermore if in the member list You issue the command "SAVE "
the member list will be saved in a dataset that You can unload to the WS
and process as You like
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Oct 15, 2009 1:21 pm    Post subject:
Reply with quote

Quote:
if you goto PDS using 3.4 you can see many columns like

equals
Quote:
in the member list
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu Oct 15, 2009 3:35 pm    Post subject:
Reply with quote

Hi Dick,

Quote:
If you have a deadline (of say less than 6 months),
The manual operation will be much quicker
than the time required for you learn enough to automate this process.


where have you been ? I genuinely miss your sense of humour. icon_lol.gif


Gerry
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 2 Sun Nov 06, 2016 8:11 pm
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am
No new posts Add system date inside of a PS file a... pramitdas DFSORT/ICETOOL 5 Sun Aug 28, 2016 12:06 am
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm


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