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

search for a key and move file b to output file


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
akshaiya

New User


Joined: 17 Sep 2005
Posts: 49

PostPosted: Mon Oct 09, 2006 2:01 pm
Reply with quote

My requirement is to search for a particular field in a FILE A.
If my search is successfull then I need to move FILEB to the output file else FILEC to the output file.

1.Search 3 character field('LEA or FBA or VAB) from postion 50 to 52 in FILEA
2.If present move entire file B to output file
3.Search ('EDA' or DEA') in FILE A.
4.If present move file c to the output file.

How do i do this with sort.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon Oct 09, 2006 9:03 pm
Reply with quote

Your description is somewhat confusing.

You mention FILEA, FILEB and FILEC - are those three different input data sets?

Do you want to copy FILEB to to the output file if LEA or FBA or VAB is present anywhere in any record of FILEA?
Do you want to copy FILEC to the output file if EDA' or DEA is present anywhere in any record of FILEB? If LEA or FBA or VAB is also present, do you want FILEB and FILEC copied to the output file? In that order?

What is the RECFM and LRECL of FILEA, FILEB and FILEC?

It would really help if you would show some examples of the input records in each file and what you want for output for different cases.
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Search two or more word with FILEAID Compuware & Other Tools 15
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top