Replace the Null with Spaces



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Replace the Null with Spaces

Postby Hari027 » Fri Dec 08, 2017 1:08 am

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.
Hari027
 
Posts: 1
Joined: Fri Dec 08, 2017 12:46 am
Has thanked: 0 time
Been thanked: 0 time

Re: Replace the Null with Spaces

Postby Terry Heinze » Fri Dec 08, 2017 1:20 am

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.
.... Terry
Terry Heinze
 
Posts: 239
Joined: Wed Dec 04, 2013 11:08 pm
Location: Richfield, MN, USA
Has thanked: 12 times
Been thanked: 11 times

Re: Replace the Null with Spaces

Postby NicC » Fri Dec 08, 2017 4:20 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post