copying after the matched record is found

deepak.kec · New User Joined: 26 Feb 2007 Posts: 71 Location: bangalore

Hi,

I have input dataset as mentioned below:

1
2
3
4
TRAILER
5
6
7

I want output dataset should contain:
TRAILER
5
6
7

Could anyone of you suggest.

THINKSRINIII · New User Joined: 09 Jan 2009 Posts: 88 Location: India

Let us know the Lrecl,recfm of the file.

nelson.pandian · Posted: Tue Sep 20, 2011 3:03 pm

Hi Deepak,

Your example is not very clear and you have not provided any rules to achieve your output. Please answer the below question.

1, Will the input file have only one 'TRAILER' record?
2, IF Multiple record found, what needs to done?
3, In subject you have mentioned 'Matching record'. How to identify Matching records?
4, What is the RECFM and LRECL of your IN/OUT files.

deepak.kec · New User Joined: 26 Feb 2007 Posts: 71 Location: bangalore

1, Will the input file have only one 'TRAILER' record?
Yes it will have only one 'TRAILER' record

2, IF Multiple record found, what needs to done?
N/A

3, In subject you have mentioned 'Matching record'. How to identify Matching records?
Matching record is the 'TRAILER' record. Once the control reaches there all the records after that should be written to output file including TRAILER records.

4, What is the RECFM and LRECL of your IN/OUT files.
RECFM is Fixed block and LRECL is 80 of IN/OUT files.

Please let me know in case you need any additional information.

THINKSRINIII · New User Joined: 09 Jan 2009 Posts: 88 Location: India

Assuming that it is FB and record length 80.

deepak.kec · New User Joined: 26 Feb 2007 Posts: 71 Location: bangalore

Thanks a ton!!!it worked

Frank Yaeger · Posted: Tue Sep 20, 2011 10:33 pm

Deepak,

Note that this solution (and many others) are covered by my "Smart DFSORT Tricks" paper at:

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094