IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

change '123' to 'A01' from 5th column using syncsort


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mflax

New User


Joined: 01 Sep 2006
Posts: 17
Location: Delhi

PostPosted: Mon Sep 11, 2006 8:59 pm
Reply with quote

I want to change '123' to 'A01' from 5th column in all my records using syncsort where first 2 characters of the records are "NY".

Pls help me provide appropriate sort card.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Tue Sep 12, 2006 7:07 am
Reply with quote

Well, MFLAX... I am not a Syncsort player... but am learning too now a days; due to changed weather...

I could only reach up to changing all "123" to "A01" but not for specific records... Will update this thread once I reach the final destination...Try the code below...

Code:
SORT FIELDS = COPY
OUTREC = (1:1,4,
5:5,3,CHANGE=(3,C'123',C'A01'),NOMATCH=(5,3)
8:8,L-7)


Here L = LRCEL of your I/p file...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts How to load to DB2 with column level ... DB2 6
No new posts RC query -Time column CA Products 3
No new posts 3270 personal communications. Can't c... TSO/ISPF 2
No new posts first column truncated in search result IBM Tools 13
Search our Forums:

Back to Top