DFSORT OUTREC Data Conversion

DFSORT OUTREC: Data Translation DFSORT OUTREC: Editing numeric fields

Advertisements


OUTREC used to convert the numeric fields from one type to another type.


Syntax:

OUTREC FIELDS=(starting position of field1, length of field1,
		field1 source format, TO=field1 target format,LENGTH=n,….. )

Let’s discuss in detail.

nameDescription
Starting position of field1Specifies field1starting position in the input file after sorting.
Length of feild1 Field1 physical length in input file.
Field1 Source format Specifies the field1 source format
TO=field1 target formatSpecifies the field1 target format
n Specifies the field1 target format length

The below are the list of numeric formats

BI format for the field if want to test for binary format(‘0’, ‘1’ every bit).

FS format for the field if want to test for character numeric ('0'-'9' inevery byte).

ZD format for the field if want to test for zoned decimal numeric ('0'-'9'in all non-sign bytes; X'F0'-X'F9', X'D0'-X'D9' or X'C0'-X'C9' in the sign byte).

PD format for the field if want to test for packed decimal numeric (0-9for all digits; F, D or C for the sign).


Example: - Will update soon


DFSORT OUTREC: Data Translation DFSORT OUTREC: Editing numeric fields

Advertisements