DFSORT OUTREC Data Translation

DFSORT OUTREC: Inserting data DFSORT OUTREC: Data Conversion

Advertisements


OUTREC statement used to translate from one type to another type like uppercase to lowercase, EBCDIC to ASCII, and more.


Syntax:

OUTREC FIELDS=(starting position of field1, length of field1,TRAN=Option….. )

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.
TRAN=OptionSpecifies the translation type.

TRAN=UTOL translates uppercase letter (A-Z) in the field to the equivalentlowercase letter (a-z).

TRAN=LTOU translates lowercase letters (a-z) in a field to the equivalentuppercase letters (A-Z).

TRAN=ETOA translates EBCDIC characters in a field to the equivalent ASCIIcharacters.

TRAN=ATOE translates ASCII characters in a field to the equivalent EBCDICcharacters.

TRAN=ALTSEQ translates characters in a field to other characters as specifiedby an ALTSEQ statement.

TRAN=HEX translates binary values in a field to their equivalent EBCDIChexadecimal values ('0'-'F').

2 output characters are produced for each input byte.

TRAN=BIT translates binary values in a field to their equivalent EBCDIC bitvalues ('0' or '1').

8 output characters are produced for each input byte.

TRAN=UNHEX translates EBCDIC hexadecimal values ('0'-'F') in a field to theirequivalent binary values.

An output byte is produced for each 2 inputcharacters.

TRAN=UNBIT translates EBCDIC bit values ('0' or '1') in a field to theirequivalent binary values.

An output byte is produced for each 8 inputcharacters.


Example: - Will update soon


DFSORT OUTREC: Inserting data DFSORT OUTREC: Data Conversion

Advertisements