MVSFORUMS.com

tcurrier · Intermediate Joined: 10 Feb 2006 Posts: 188 Topics: 68

Is there a utility that will insert a blank line in a file whenever there is a break on a 'key field? Thanks for any help.

Example:

Frank Yaeger · Posted: Fri Dec 18, 2009 10:36 am Post subject:

Here's a DFSORT job that will do what you asked for. I assumed the key is in positions 1-15 and the records are already in sorted order by the key as shown in your example.

tcurrier · Intermediate Joined: 10 Feb 2006 Posts: 188 Topics: 68

Thanks, Frank...

We have SYNCSORT FOR Z/OS 1.3.2.1N

It didn't work, but that's apparently why ....

Brian Wood · Posted: Fri Dec 18, 2009 1:56 pm Post subject:

tcurrrier:

Starting with the very helpful coding example offered by Frank, I was able to get the expected results using SyncSort for z/OS 1.3.2.1 by removing the 'REMOVECC' parameter from the OUTFIL statement.

Please post if you still require further assistance with this. Please feel free to email me a copy of your latest coding attempt if you are still having difficulties.
_________________
Brian Wood
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com

tcurrier · Intermediate Joined: 10 Feb 2006 Posts: 188 Topics: 68

Brian,

Yes, that worked... Only problem is that I had 'FB' for my RECFM, but
it apparently is looking for 'FBA'

tcurrier · Intermediate Joined: 10 Feb 2006 Posts: 188 Topics: 68

The only problem with using FBA is that I am getting a carriage control byte at the beginning:

Brian Wood · Posted: Fri Dec 18, 2009 5:06 pm Post subject:

tcurrier:

Thanks for the update. I try not to hard-code the DCB in my JCL so I automatically got FBA. The 'A' refers to ANSI control character, which controls things like printer line feeds. By removing REMOVECC, you got FBA instead instead of FB.
'SECTIONS=(1,10' identifies the control field that determines what is called a "section break". Every time a change occurs in the data in that field, a new "break" occurs (see page 2.104 through 2.110 in the SyncSort 1.3 Programmer's Guide).

Please let me know if I may be of any further assistance.
_________________
Brian Wood
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com

tcurrier · Intermediate Joined: 10 Feb 2006 Posts: 188 Topics: 68

OK, thanks... I'll try to find a hard or soft copy of the Syncsort programmer's guide.....

In the meantime, just one more hint, please.... If I want to comment
out a control card in Syncsort, how do I do that ?

Frank Yaeger · Posted: Sat Dec 19, 2009 8:41 pm Post subject:

Note: I used REMOVECC specifically to avoid getting FBA or the carriage control character which I assumed (from long experience) wasn't wanted in this case.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

Brian Wood · Posted: Mon Dec 21, 2009 1:39 pm Post subject:

tcurrier:

To comment out a control statement using SyncSort, place an asterisk (*) in column 1.
_________________
Brian Wood
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com