8 DFSORT Translate Parameters at one place

In DFSORT you can find many reformatting features with INREC, OUTREC and OUTFIL statements, making each useful by itself or in conjunction with the other statements.

INREC, OUTREC and OUTFIL can translate data in several new ways as follows:

– TRAN=ATOE

translates ASCII characters anywhere in a specified field to their equivalent EBCDIC characters.

As a simple example, if you specify:

INREC OVERLAY=(11:11,3,TRAN=ATOE)

DFSORT will translate ASCII to EBCDIC in positions 11-13 of each output record. So ASCII aB2
(X’614232′) would be translated to EBCDIC aB2 (X’81C2F2′).

– TRAN=ETOA

translates EBCDIC characters anywhere in a specified field to their equivalent ASCII characters.

As a simple example, if you specify:

INREC OVERLAY=(21:21,3,TRAN=ETOA)

DFSORT will translate EBCDIC to ASCII in positions 21-23 of each output record. So EBCDIC aB2
(X’81C2F2′) would be translated to ASCII aB2 (X’614232′).

– TRAN=HEX

translates binary values anywhere in a specified field to their equivalent EBCDIC
hexadecimal characters. As a simple example, if you specify:

INREC OVERLAY=(5:51,2,TRAN=HEX)

DFSORT will translate binary to hex in positions 51-52 of each output record. So X’C1F1′ (C’A1′) would be translated to C’C1F1′.

– TRAN=UNHEX

translates EBCDIC hexadecimal characters anywhere in a specified field to their equivalent
binary values. As a simple example, if you specify:

INREC BUILD=(1,4,TRAN=UNHEX)

DFSORT will translate hex to binary in positions 1-4 of each output record. So C’C1F1 would be translated to X’C1F1′ (C’A1′).

What’s New in DFSORT 13.

– TRAN=BIT

translates binary values anywhere in a specified field to their equivalent EBCDIC bit values.
As a simple example, if you specify:

INREC OVERLAY=(16:16,2,TRAN=BIT)
DFSORT will translate binary to bits in positions 16-17 of each output record. So X’C1F1′ (C’A1′) would be translated to C’1100000111110001′.

– TRAN=UNBIT

Translates EBCDIC bit values anywhere in a specified field to their equivalent binary
values. As a simple example, if you specify:

INREC BUILD=(31:31,16,TRAN=UNBIT)
DFSORT will translate bit to binary in positions 31-46 of each output record. So C’1100000111110001′ would be translated to X’C1F1′ (C’A1′).

– TRAN=LTOU

translates lowercase EBCDIC letters anywhere in a specified field to uppercase EBCDIC
letters. As a simple example, if you specify:

INREC OVERLAY=(31:31,11,TRAN=LTOU)

DFSORT will translate lowercase to uppercase in positions 31-41 of each output record. So ‘Vicky-123,x’ would be translated to ‘VICKY-123,X’. letters.

As a simple example, if you specify:
OUTFIL BUILD=(1,4,5,TRAN=UTOL)

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.