MVSFORUMS.com

[Anand_R]

Hi,

I have a requirment to edit 1 st file based on the 2nd file data. Conditions and data both are availble in the 2nd file. Here is my requirement

1st file data: LRECL = 80

[Frank Yaeger]

Here's a DFSORT job that will do what you asked for. SORTIN for S1 can have 2008 Scale Hold or 2007 Scale Change starting in position 3 (if they don't start in position 3, change the job appropriately).

[Anand_R]

Thank you Frank for your valuable time.

I have misstated my requirement and I apologize for that. The second file values are variables they are not always constant, except strings " scale hold" and "scale change". Here is the sample 2nd file structure

year1 scale hold
year2 scale change rate1

If it is Scale Hold,

The following logic to be applied in 2nd file

Replace field at postion 20 in 2nd file with the new value year1

If it is Scale Change

The following logic to be applied in 2nd file
Replace field at postion 20 in 2nd file with year2 and fields at 30 & 40 with new value .rate1.

From your solution, I think I need to make modifications to the flag record in the first step, to include the rate information and year information, which I should use in the second step. Please let me know if that works

Thanks
Anand

[Frank Yaeger]

Well, that does make a difference. Your posts are very confusing with respect to what positions the relevant fields are in and whether the values are lowercase or initial cap, but this revised DFSORT job should give you the idea. In this case, we create and use three symbols, Flag, Year and Rate. (Rate will be blank and unused in the hold case.)

[Anand_R]

Thank You Frank,

While I am trying to execute, I am getting the following error in first step i.e flag creation step S1.

WER268A OUTFIL STATEMENT : SYNTAX ERROR

I could not find out the syntax error. I have used the same job that you have in your note

Thanks
Anand

[kolusu]

[Anand_R]

Thank you Kolusu, You are right I am using syncsort. Is there any way I can use the same logic and use the appropriate keywords in syncsort to achieve the desired results

Thanks for your help
Anand

[Frank Yaeger]

[Anand_R]

Thank You Frank for all your help so far

Regards
Anand

[kolusu]

Anand,

Try this code.

[Anand_R]

Thank You kolsu, It's a perfect solution, it is working as expected

[Anand_R]

Hi Kolusu,

I have also another requirement to drop some records from a file using another control file, where it will have all the records that needs to be dropped. I searched through form with word 'drop' and could not find desired results.

For instance input file have the following data

001 2007L .0777 .0777
002 2007L .0777 .0777
003 2007L .0777 .0777
004 2007L .0777 .0777
005 2007L .0777 .0777
006 2007L .0777 .0777

2nd control file have the following date

001
002
005

Final output file should have only the following records
003 2007L .0777 .0777
004 2007L .0777 .0777
006 2007L .0777 .0777

Thanks
Anand

[kolusu]

Anand_R,


Does input file contain duplicates? if they are unique then you can use "nodups" parm. Check these links

http://www.mvsforums.com/helpboards/viewtopic.php?t=254&highlight=nodups

http://www.mvsforums.com/helpboards/viewtopic.php?t=8&highlight=nodups

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Anand_R]

Thank You Kolusu for your timely help always