Re: Is hex 00000 in a string field equal to null?

Yep, the information I see is classic problem. Just have to figure out a
fix.
--
Mike Wills
http://mikewills.me


On Wed, Dec 21, 2011 at 3:28 PM, Joe Pluta<joepluta@xxxxxxxxxxxxxxxxx>wrote:

I think you mean 32-character, and the only problem there is that if you
call a program with parms longer than 32 characters from a command line
and don't pass all the data, the part after 32 characters gets random
garbage (not blanks). Typically this doesn't affect anyone, but it does
cause a problem when you try to format a string to call either from
QCMDEXC or from a SBMJOB.

Joe

Thanks! The bug showed up again today, so I tried the replace. It worked
perfectly! Now to figure out the damn bug. I am sure it has to do with

the

36 character limit on RPG parameters. I'll probably remove the RPG from

the

picture to see if that resolves it.



On Fri, Dec 9, 2011 at 10:32 AM, Mark Murphy/STAR BASE Consulting Inc.<
mmurphy@xxxxxxxxxxxxxxx> wrote:

no need to go through all those gyrations, a single built-in will do the
job

REPLACE(field, x'00', ' ')

will do the trick.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.