Sorting variable block file

ppandey07 · Posted: Wed Sep 29, 2010 2:52 pm

I have a variable block file where a “$” marks the beginning of a new record and records are split over multiple rows. This is how couple of records in the file look like:

${1:F01NWBKUSUSDXXX2580037162}
0}}{5:{CHK:D015C98706D7}.
${1:F01NWBKUSUSDXXX2580037162}
05:E}{332:0
0}}{5:{CHK:{SYS:}}.

Now I want to write a job so that these 2 records are written on 2 rows instead of splitting over multiple rows. This is how the output will look like:

${1:F01NWBKUSUSDXXX2580037162}0}}{5:{CHK:D015C98706D7}.
${1:F01NWBKUSUSDXXX2580037162}05:E}{332:00}}{5:{CHK:{SYS:}}.

enrico-sorichetti · Posted: Wed Sep 29, 2010 3:18 pm

odd but the topic looks a lot like
ibmmainframes.com/viewtopic.php?t=51459

it would be nice if people working in the same organization would coordinate their forum posting
in order to avoid duplicate posts on the same issue and wasting people time in replying to many posts when the issue is really ONE

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

ppandey07,
Refer to ibmmainframes.com/viewtopic.php?t=51459 for solution.

Thanks,

dbzTHEdinosauer · Posted: Wed Sep 29, 2010 11:19 pm

and both of you learn that:

ROWS is a DB2 term
RECORDS is a file term.

good chance that there was no coordination because each speaks in his own
technical dialect, so no one understands what the other is doing.