What I'm Thinking

Rearrage SDSF Columns
18 January 2012

If you want to rearrange the columns in SDSF. Go to SDSF;ST. In command line type “arr ?”. This will bring the complete list of SDSF column names. You can move the columns using “/” and “//”. One Column in the SDSF that we can bring to the front position is the MAX-RC (which usually is the last column in SDSF) which shows the completion code or the abend code of the job. ... Read More
Translation features of INREC, OUTREC and OUTFIL make it easy to change the case of characters in your fields. The TRAN=LTOU operand can be used to change lowercase EBCDIC letters (a-z) to uppercase EBCDIC letters (A-Z) anywhere in a field. The TRAN=UTOL operand can be used to change uppercase EBCDIC letters to lowercase EBCDIC letters anywhere in a field. You could change the case in the entire record as well or part of the record. ... Read More
Projects do testing of their code multiple times before they move their code to production. Once the test JCLs are created. From the second run, we need to just change few qualifiers of the DSN and dates in all the JCLs. The conventional method is enter each member of the JCL PDS and make the changes. If you are sure that you are gonna make common changes in all the members then go ahead and use the below technique. ... Read More
Lets assume that we have a sequential dataset with records as below: ONE TWO THREE FOUR FIVE I want to reformat the records for output as follows: NUMBER 'ONE' NUMBER 'TWO' NUMBER 'THREE' NUMBER 'FOUR' NUMBER 'FIVE' You can do this quite easily with DFSORT’s JFY function as follows: OPTION COPY INREC BUILD=(1,13,JFY=(SHIFT=LEFT,LEAD=C’NUMBER “‘, TRAIL=C”“) SHIFT=LEFT left-justifies the data. LEAD inserts the hard coded text NUMBER ‘ before the value with no intervening blanks. ... Read More