Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

syncsort blank(fill with ) out one column on a cond

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Mohit Verma

New User


Joined: 19 Mar 2008
Posts: 1
Location: Providence

PostPosted: Mon May 19, 2008 8:34 pm    Post subject: syncsort blank(fill with ) out one column on a cond
Reply with quote

I have a file containing 1.2 Million records. I need to space out (replace with blanks) i.e. x'40' on a set of columns if the value on that column is not a particular numeric value for ex 5.
Back to top
View user's profile Send private message

rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 193
Location: india

PostPosted: Mon May 19, 2008 11:21 pm    Post subject: Re: syncsort blank(fill with ) out one column on a cond
Reply with quote

Hi Mohit,

Mohit Verma wrote:
to space out (replace with blanks) i.e. x'40' on a set of columns


What are the those column positions?

Mohit Verma wrote:
if the value on that column is not a particular numeric value for ex 5.


How do you identify which numeric value should be present in that column?

Its better if you can show us with an example what exactly you need...

Regards,
Rajat
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue May 20, 2008 12:49 am    Post subject:
Reply with quote

Mohit Verma,

Without knowing your record layout or format, here is a basic example that you can modify for your needs:

Code:
//SORT1 EXEC PGM=SORT         
//SORTIN DD *                 
AAAAA                         
BBBB5                         
CCCC5                         
DDDD2                         
EEEEE                         
FFFF8                         
//SORTOUT DD SYSOUT=*         
//SYSOUT DD SYSOUT=*         
//SYSIN DD *                 
 INREC IFTHEN=(WHEN=(5,1,CH,NE,C'5'),OVERLAY=(5:X'40'))   
 SORT FIELDS=COPY                                         
/*     

This is the output produced:
Code:
AAAA   
BBBB5   
CCCC5   
DDDD   
EEEE   
FFFF   


If this does not meet your needs, then please be more specific and provide sample input and output.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
This topic is locked: you cannot edit posts or make replies. DB2 query Using Recursion, Converting... smilewithashu2 DB2 3 Tue Jan 03, 2017 12:50 pm
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 6 Sun Nov 06, 2016 8:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us