Syncsort Replacing Hex value in Variable block

subbuy2k · New User Joined: 17 Apr 2009 Posts: 8 Location: milford

I have a VARIABLE LENGTH file with a hex '0d' in the end of each record. Have to replace '0D' with '40'.

Regards
subs

dbzTHEdinosauer · Posted: Wed Jun 24, 2009 2:04 am

don't know how to remove the '0D'.
since it is somewhat obvious that this file originated on a PC
(the '0D' is line control character)
in the future, have the tranmit/transfer process drop the '0D'
and you won't have to deal with it on the mainframe.

subbuy2k · New User Joined: 17 Apr 2009 Posts: 8 Location: milford

That is the first thing i did. Unfortunately the tool they are using in windows dont have that facility, so i have to deal with this.

since its varible block file file, its throwing me error when i tried to replace using file aid utility.

Robert Sample · Posted: Wed Jun 24, 2009 3:07 am

Have you tried running the PC file into a Unix System Services file, then doing OGET to bring it into z/OS? I've had some success at getting rid of end of line characters in this way.

subbuy2k · New User Joined: 17 Apr 2009 Posts: 8 Location: milford

This is a existing system, i dont have any option in changing the design. my ONLY option is to replace the hex value in this variable length file.

Arun Raj · Posted: Wed Jun 24, 2009 8:35 am

subbuy2k,

This has already been discussed before. See this previous topic.

www.ibmmainframes.com/about34268.html

gcicchet · Posted: Wed Jun 24, 2009 8:41 am

Hi,

can you show what error FILEAID is throwing ?

and the syntax you are using ?

Gerry

Arun Raj · Posted: Wed Jun 24, 2009 8:47 am

gcicchet · Posted: Wed Jun 24, 2009 8:54 am

Hi,

I missed the subject heading

This is what I based my question on, my apologies

Arun Raj · Posted: Wed Jun 24, 2009 9:00 am

dick scherrer · Posted: Wed Jun 24, 2009 9:02 am

Hello,

Alissa Margulies · Posted: Thu Jun 25, 2009 9:27 pm

Subs,

Both solutions provided in the link posted by arcvns should provide the desired output if you are running SyncSort for z/OS 1.3.2.1. If you are running an earlier release of SyncSort, then use ALTSEQ, as suggested by Dick (support for FINDREP was included in release 1.3.2.1). If you still have any questions after trying these methods, please post back here and we can further assist you.