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

Changed column in PDS


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 1208
Location: Bangalore,India

PostPosted: Thu Oct 15, 2009 12:27 pm
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
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
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Oct 15, 2009 1:03 pm
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
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: 1702
Location: Australia

PostPosted: Thu Oct 15, 2009 3:35 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts How to load to DB2 with column level ... DB2 6
No new posts RC query -Time column CA Products 3
No new posts first column truncated in search result IBM Tools 13
No new posts Split a record with data in a differe... DFSORT/ICETOOL 8
Search our Forums:

Back to Top