SORT – OUTREC – TRAN
In SORT, you can make use of TRAN=keyword to do the following functions.
- TRAN=UTOL translates uppercase letter (A-Z) in the field to the equivalent lowercase letter (a-z).
Input file:
RAJESH
SURESH
RAMS
SUNIL
CHIRU
Output File:
Rajesh
Suresh
Rams
Sunil
Chiru
OUTREC in the sort would look as below so that your first char remains as upper case and the others are converted to lower case
OUTREC FIELDS=(1,1,2,5,TRAN=UTOL)
Here 2,5,TRAN=UTOL is of the format p,m,TRAN=UTOL.
- TRAN=LTOU translates lowercase letters (a-z) in a field to the equivalent uppercase letters (A-Z)
- TRAN=ETOA translates EBCDIC characters in a field to the equivalent ASCII characters.
- TRAN=ATOE translates ASCII characters in a field to the equivalent EBCDIC characters.
- TRAN=ALTSEQ translates characters in a field to other characters as specified by an ALTSEQ statement. For example, “null” characters (hex 00) can be changed to blank characters (hex 40)
- TRAN=HEX translates binary values in a field to their equivalent EBCDIC hexadecimal values (‘0’-‘F’). 2 output characters are produced for each input byte.
- TRAN=BIT translates binary values in a field to their equivalent EBCDIC bit values (‘0’ or ‘1’). 8 output characters are produced for each input byte.
- TRAN=UNHEX translates EBCDIC hexadecimal values (‘0’-‘F’) in a field to their equivalent binary values. An output byte is produced for each 2 input characters.
- TRAN=UNBIT translates EBCDIC bit values (‘0’ or ‘1’) in a field to their equivalent binary values. An output byte is produced for each 8 input characters.
——————————————————————————————————–
In United States, If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog
——————————————————————————————————–
You may also like to look at:
Working on Mainframes – Is Change to a different technology necessary |
Pingback: SORT – PARSE – READ EXCEL (CSV) FILE IN MAINFRAMES | F1 for Mainframe