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
 

 

What is wrong with this FINDREP ?

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

New User


Joined: 17 Feb 2007
Posts: 47
Location: USA

PostPosted: Wed Jan 26, 2011 12:49 am    Post subject: What is wrong with this FINDREP ?
Reply with quote

I am using below sort parameters in Syncsort to replace characters/spaces with Zeros anywhere from position 223 length 5 inside 404 FB file.

First I am trying to replace 'L' with Zeros but it is not working. JCL return code is zero, but the output file is having same value '00L00' as Input file.

//SYSIN DD *
SORT FIELDS=COPY
INREC FINDREP=(STARTPOS=223,ENDPOS=5,IN=C'L',OUT=C'0')
/*

If this works I am planning to put all the alphabets in IN parameter and try. If anyone has simplest way to do this please let me know.

Thanks
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jan 26, 2011 12:53 am    Post subject:
Reply with quote

Helllo,

Why is the ending position less than the starting position?
Back to top
View user's profile Send private message
AJAYREDDY

New User


Joined: 17 Feb 2007
Posts: 47
Location: USA

PostPosted: Wed Jan 26, 2011 1:16 am    Post subject:
Reply with quote

Sorry, I overlooked into it. I was assuming it is the length parameter from Starting Postion. I changed it to 227 and it worked.


//SYSIN DD *
SORT FIELDS=COPY
INREC FINDREP=(STARTPOS=223,ENDPOS=227,IN=C'L',OUT=C'0')
/*

I replaced entire Sort card with below and it worked for all other records.

SORT FIELDS=COPY
INREC FINDREP=(STARTPOS=223,ENDPOS=227,
IN=(C'A',C'B',C'C',C'D',C'E',C'F',C'G',C'H',C'I',
C'J',C'K',C'L',C'M',C'N',C'O',C'P',C'Q',C'R',
C'S',C'T',C'U',C'V',C'W',C'X',C'Y',C'Z',

C'a',C'b',C'c',C'd',C'e',C'f',C'g',C'h',C'i',
C'j',C'k',C'l',C'm',C'n',C'o',C'p',C'q',C'r',
C's',C't',C'u',C'v',C'w',C'x',C'y',C'z',

C'~',C'`',C'!',C'@',C'#',C'$',C'%',C'¢',C'&',
C'*',C'(',C')',C'_',C'-',C'+',C'=',C'{',C'}',
C'¬',C'¦',C'|',C'\',C':',C';',C'"',C'?',C'/',
C'>',C'<',C'.',C',',C'[',C']',C' ',C''''),
OUT=C'0')

Thanks
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jan 26, 2011 1:21 am    Post subject: Reply to: What is wrong with this FINDREP ?
Reply with quote

Good to hear it is working - thank you for posting your solution icon_smile.gif

d
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Jan 26, 2011 1:32 pm    Post subject:
Reply with quote

Please DO NOT post the exact same question twice on this forum.
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 version supporting FINDREP c... juares castro SYNCSORT 9 Tue Aug 09, 2016 6:54 pm
No new posts Yesterday's Date using SYMNAMES and F... SathishCS DFSORT/ICETOOL 2 Mon Jun 29, 2015 6:59 pm
No new posts FINDREP=(INOUT problem Gary McDowell SYNCSORT 7 Sat Mar 21, 2015 1:34 am
No new posts Problem with FINDREP on RRDS creator.abhishek JCL & VSAM 11 Wed Jul 31, 2013 8:19 pm
No new posts Multiple FINDREP jerryte DFSORT/ICETOOL 6 Tue Jun 12, 2012 10:18 pm


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