Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 195
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 column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us