Page 1 of 1

Replace the Null with Spaces

PostPosted: Fri Dec 08, 2017 1:08 am
by Hari027
I have VB file .. have a field VarChar(30)

example:
1111111111111111. (. is X'00')

I want to replace the . - X'00' to X'40' using ALTSEQ at position 17 in the VB file.

I tried the syntax -

OPTION COPY
ALTSEQ CODE=(0040)

Getting S806 error. Can you please suggest.

Re: Replace the Null with Spaces

PostPosted: Fri Dec 08, 2017 1:20 am
by Terry Heinze
An S806 has nothing to do with your desire to replace one character with another.
I don't think ALTSEQ is what you want.
Also, please learn to use code tags for readability.

Re: Replace the Null with Spaces

PostPosted: Fri Dec 08, 2017 4:20 pm
by NicC
An S806 is "program not found" so either you mis-spelled SORT/DFSORT or you pointed to the wrong library (no STEPLIB/JOBLIB should be required for system utilities) or you have not bothered to read your job output properly and diagnosed which is the failing step.

ALTSEQ provides an alternative sorting sequence, it does not replace characters. Look in the manual for how to replace characters - start at the Index.