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

JCl to search for different strings in different GDG's


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
pmn2cdac

New User


Joined: 23 Dec 2007
Posts: 27
Location: Bangalore

PostPosted: Sat Aug 02, 2008 12:01 am
Reply with quote

Hi,
I will be getting different GDG generations on a daily basis ( A max of 20 to 25 generations). My objective is to search for 10 different strings ( even more as per the requiement) across all the GDG generations and to find out the GDG generation that is having any/all of the search strings.

My output should typically contain the search string Vs the GDG generation mapping.

Can any one help me with this JCL? Please let me if you need any related details.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Sat Aug 02, 2008 12:30 pm
Reply with quote

pmn2cdac wrote:
Can any one help me with this JCL? Please let me if you need any related details.
JCL is very general term from this query's point of view, using File-Aid...or SORT, what product solution you are searchig for...?

With File-Aid, try this-

Code:
//FILEAID  EXEC PGM=FILEAID                                       
//SYSPRINT DD SYSOUT=*                                             
//SYSLIST  DD SYSOUT=*                                             
//DD01     DD DSN=I.am.gdg.base,
//            DISP=SHR                                             
//SYSIN    DD *                                                   
$$DD01 LIST OUT=0,                                                 
            IF=(001,EQ,C'string to search')                 
/*                                                 


If you are looking for SORT solution then please search the forum for Skolusu's solutions, he has put the reply on board for this type of request some days back, good luck.. icon_smile.gif
Back to top
View user's profile Send private message
pmn2cdac

New User


Joined: 23 Dec 2007
Posts: 27
Location: Bangalore

PostPosted: Mon Aug 04, 2008 11:49 pm
Reply with quote

Hi , Thanks for your quick reply. But I can not use this as I don't have FILEAID .Could any one help me with any alternate solution.

Here is what I can further give details about..

sample data:

Input files: ( GDG generations):

I.AM.A.GDG.XXXXXV00
I.AM.A.GDG.XXXXXV01
I.AM.A.GDG.XXXXXV02
I.AM.A.GDG.XXXXXV03....so on till 25 generations.

I have to search for different strings among all the above mentioned generations just like below.

'GHJdasdasdasdsad23242'
'ASadfghfghfasdsad23242'
'ljljkdsdfsfs23242'

The search string can also be of different length.

Expected OUTPUT:

'GHJdasdasdasdsad23242' is present on I.AM.A.GDG.XXXXXV02

'ASadfghfghfasdsad23242' is present on I.AM.A.GDG.XXXXXV04

'ljljkdsdfsfs23242' is present on I.AM.A.GDG.XXXXXV20.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Tue Aug 05, 2008 4:24 am
Reply with quote

Hi,

as Anuj mentioned earlier see http://ibmmainframes.com/viewtopic.php?t=32464




Gerry
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Tue Aug 05, 2008 10:22 am
Reply with quote

Hi,

Thanks Gerry, somtimes I think who is rather in need..who should search first, even after getting a hint...
Quote:
If you are looking for SORT solution then please search the forum for Skolusu's solutions, he has put the reply on board for this type of request some days back


Amen.. icon_neutral.gif
Back to top
View user's profile Send private message
pmn2cdac

New User


Joined: 23 Dec 2007
Posts: 27
Location: Bangalore

PostPosted: Thu Aug 07, 2008 7:31 pm
Reply with quote

Thanks a lot guys!!!. The solution worked for me!!!.
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 Search two or more word with FILEAID Compuware & Other Tools 15
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts first column truncated in search result IBM Tools 13
No new posts ISRSUPC search utility - using high l... TSO/ISPF 2
No new posts To search DB2 table based on Conditio... DB2 1
Search our Forums:

Back to Top