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)

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 -


Getting S806 error. Can you please suggest.
Posts: 1
Joined: Fri Dec 08, 2017 12:46 am
Has thanked: 0 time
Been thanked: 0 time

Re: Replace the Null with Spaces


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: 199
Joined: Wed Dec 04, 2013 11:08 pm
Location: Richfield, MN, USA
Has thanked: 10 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.
Global moderator
Posts: 2745
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 110 times



  • Related topics
    Last post