8 DFSORT translate Parameters Just at one place

DFSORT Translate Parameters
DFSORT Transalte Parameters

Many reformatting features are available with DFSORT’s 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)

Advertisements

Author: Srini

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