DFSORT OUTREC squeezing Data

DFSORT OUTREC: Justifying Data DFSORT OUTREC: Reformatting with OVERLAY

Advertisements


OUTREC statement can be used to squeeze the content in the file while sorting.

Syntax:
OPTION COPY
OUTREC FIELDS=(Starting position of field1, Length of field1,
		SQZ=(SHIFT=LEFT/RIGHT,LEAD=charset, TRAIL=charset),…)

Name Description
Starting position of field1Specifies field1 starting position in the input file after sorting.
Length of feild1Field1 physical length in input file.
SHIFTSpecifies the justification
SHIFT=LEFT indicates the left-squeeze by removing all of the blanks, 
shifting the remaining characters to the left and padding on the right with blanks if needed.
SHIFT=RIGHT indicates the right-squeeze by removing all of the blanks, 
shifting the remaining characters to the right and padding on the left with blanks if needed.
LEAD=charset Specifies the leading characters/string adding to data
TRAIL=CharsetSpecifies the trailing characters/strings adding to data

PREBLANK=


Syntax:
OPTION COPY
OUTREC FIELDS=(Starting position of field1, Length of field1,SQZ=(SHIFT=LEFT/RIGHT, PREBLANK=charset),…)

Name Description
Starting position of field1Specifies field1 starting position in the input file after sorting.
Length of feild1Field1 physical length in input file.
SHIFTSpecifies the justification
SHIFT=LEFT indicates that you want to left-justify
SHIFT=RIGHT indicates that you want to right-justify
PREBLANK=charsetSpecifies the characters that replaced or blank out as leading and trailing to data
PREBLANK=list specifies a list of characters to replace with blanks before DFSORT starts to squeeze the data.

Note: The each character in the list isindependent of the other characters.


MID=


MID=string specifies the string to replace removed blanks or PREBLANK characters as a character or hexadecimal constant (1 to 10 bytes).


Syntax:

OPTION COPY
OUTREC FIELDS=(Starting position of field1, Length of field1,SQZ=(SHIFT=LEFT/RIGHT,MID=String),…)

PAIR=


If DFSORT to "ignore" blanks and PREBLANK characters between pairs of quotes, PAIR=QUOTE with SQZ can be used.


Syntax:

OPTION COPY
OUTREC FIELDS=(Starting position of field1, Length of field1, SQZ=(SHIFT=LEFT/RIGHT, PAIR=QUOTE),…)

All Parameters


Syntax:

OPTION COPY
OUTREC FIELDS=(Starting position of field1, Length of field1, 
		SQZ=(SHIFT=LEFT/RIGHT, PAIR=QUOTE, PREBLANK=charset, MID=String),…)

Example: - Will update soon


DFSORT OUTREC: Justifying Data DFSORT OUTREC: Reformatting with OVERLAY

Advertisements