jcl sort to add leading zeroes

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
sasanka
Member
Posts: 19
Joined: Wed Dec 29, 2010 11:37 pm
Location: hyderabad

jcl sort to add leading zeroes

Post by sasanka » Sun Jan 16, 2011 12:29 am

Dear all,

i have the following input ps

76453627
0097865432
00065499234
00012342345
12301231233
.......
....
i want a jcl which adds leading zeroes to all the numbers in the ps where the number of digits are not equal to 11

i.e for the first number 76453627(8 digits) to be as 00076453627(11 digits)

if the numbers is of 11 digits 00065499234(11 digts)
it should not add leading zeroes

:?:

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Mon Jan 17, 2011 6:22 pm

For the given example, try this:

Code: Select all

//STEP001  EXEC PGM=SORT               
//SORTIN DD *                          
76453627                               
0097865432                             
00065499234                            
00012342345                            
12301231233                            
//SORTOUT DD SYSOUT=*                  
//SYSIN DD *                           
  OPTION COPY                          
  INREC BUILD=(1,11,UFF,M11,LENGTH=11) 
//SYSOUT DD SYSOUT=*                   
//*
Regards,
Anuj

sasanka
Member
Posts: 19
Joined: Wed Dec 29, 2010 11:37 pm
Location: hyderabad

Post by sasanka » Mon Jan 17, 2011 9:08 pm

Anuj Dhawan wrote:For the given example, try this:

Code: Select all

//STEP001  EXEC PGM=SORT               
//SORTIN DD *                          
76453627                               
0097865432                             
00065499234                            
00012342345                            
12301231233                            
//SORTOUT DD SYSOUT=*                  
//SYSIN DD *                           
  OPTION COPY                          
  INREC BUILD=(1,11,UFF,M11,LENGTH=11) 
//SYSOUT DD SYSOUT=*                   
//*

can u please explain the following
uff
m11 :?:

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Tue Jan 18, 2011 4:22 pm

UFF stands for unsigned free form and M11 would tell SORT to use leading zeros, e.g. 27 would be displayed as '0000000027'. DFSORT has 27 edit masks as well as an EDIT parameter that lets you design your own masks.
Regards,
Anuj

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Tue Jan 18, 2011 11:30 pm

sasanka,

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/support/docview.wss? ... g3T7000080
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

academyindia4

Topic deleted by Admin

Post by academyindia4 » Tue Jan 19, 2016 12:57 pm

<< Content deleted By Admin >>

academyindia4

Topic deleted by Admin

Post by academyindia4 » Mon Feb 01, 2016 10:04 pm

<< Content deleted By Admin >>

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others