Joined: 18 Jun 2009 Posts: 407 Location: Nashville, TN
Hi All,
Have mentioned my requirement below. Its not really necessary to do this using DFSORT but I am thinking this could be done using JOINKEY. Please correct me if my understanding is wrong and if possible then how to get this done using JOINKEY.
File1 (Variable file) has some detailed information which needs to be put into the extract.
A field in the record to be set as 'Y' if
1. If the KEY in File1 is available in File2 (Variable file)
2. If value in 55 pos is 'XX'
The output extract (Variable file) hence would have the same no. of records as in File1 and some of records would have to be edited if the above conditions are satisfied.
I am facing multiple issues ..
1. First I am not able to get the REFORMAT card correctly because of the variable length. Gives me a SYNTAX error with the current one as mentioned above. I am able to get an output file if I make the output file a FB
2. Not sure how to give the condition. I want all the records from File1.
Please do let me know if I have missed to give or if I need to give more information...