• Rajesh A R

F1 for Mainframe

F1 for Mainframe

Tag Archives: binary

SORT – OUTREC – TRAN

27 Tuesday Mar 2012

Posted by rajeshar in SORT

≈ 1 Comment

Tags

binary, case, hex, lower, mainframe, SORT, tran, upper

SORT – OUTREC – TRAN

In SORT, you can make use of TRAN=keyword to do the following functions.

  1. 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.

  1. TRAN=LTOU translates lowercase letters (a-z) in a field to the equivalent uppercase letters (A-Z)
  1. TRAN=ETOA translates EBCDIC characters in a field to the equivalent ASCII characters.
  1. TRAN=ATOE translates ASCII characters in a field to the equivalent EBCDIC characters.
  1. 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)
  1. 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.
  1. 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.
  1. 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.
  1. 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
SORT – CONVERT PD to ZD and BI to ZD
SORT – EDIT FIRST AND LAST RECORD
SORT – EDIT MASK PATTERNS
SORT – EDIT NUMERIC FIELDS (I,T,S)
SORT – FINDREP, IFTHEN and INREC
SORT – How to use VB dataset (VLSHRT)
SORT – INCLUDE and OMIT
SORT – INREC, INCLUDE and OMIT
SORT – JUSTIFY, SQUEEZE and OVERLAY
SORT – LOOKUP AND CHANGE
SORT – OUTPUT DATASET DCB (LRECL,RECFM,BLKSIZE)
SORT – OUTREC – INSERT ZEROES, BLANKS, STRINGS
SORT – OUTREC – TRAN
SORT – PARSE – REFORMAT VARIABLE FIELDS
SORT – Process Order of CONTROL Statements
SORT – REMOVE DUPLICATES AND WRITE THEM TO XSUM
SORT – SET RETURN CODE ‘04’ IF OUTPUT FILE IS EMPTY
SORT – SKIPREC and STOPAFT
SORT – SUM FIELDS
SORT – TO REPLACE A CHAR WITH ANOTHER CHAR – ALTSEQ
SORT – INREC
SORT – SYMBOLS
SORT JOB – SIMPLE COPY
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
SORT JOIN – UNPAIRED RECORDS INDICATOR

 

Rate this:

Subscribe

  • Entries (RSS)
  • Comments (RSS)

Archives

  • November 2020
  • July 2020
  • February 2020
  • January 2020
  • September 2019
  • August 2019
  • October 2018
  • April 2018
  • March 2018
  • December 2017
  • October 2017
  • August 2017
  • July 2017
  • June 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • May 2016
  • March 2016
  • February 2016
  • January 2016
  • May 2015
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • January 2013
  • December 2012
  • November 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • April 2011
  • March 2011
  • August 2009
  • June 2009
  • April 2009

Categories

  • Azure
  • CA7
  • CICS
  • COBOL
    • Keywords
  • DB2
  • EASYTRIEVE
  • FILEAID
  • FILEMAXX
  • IMS
  • ISPF
  • JCL
  • KNOW YOUR MAINFRAME
  • Mainframe Migration
  • MAINFRAMES
  • Others
  • REXX
  • SDSF
  • SORT
  • Training
  • TSQL
  • VSAM

Meta

  • Register
  • Log in

Create a free website or blog at WordPress.com.

  • Follow Following
    • F1 for Mainframe
    • Join 88 other followers
    • Already have a WordPress.com account? Log in now.
    • F1 for Mainframe
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar