Re: SQL update a numeric by replacing 2 digits with a constant

[Alan Campin <alan0307d@xxxxxxxxx>]

I don't see how this would work at all if CMCUST is a packed 9,0. I would
have converted CMCUST to a string, then done the substr and then cast the
result back to a dec 9,0. Based on substringing a packed 9,0 I would guess
the results could be anything.

On Tue, Dec 21, 2010 at 10:18 AM, Dan <dan27649@xxxxxxxxx> wrote:

> The messed-up data I mentioned in my previous thread several minutes ago
> was
> caused by:
>
> Update Lib1/Customer  Set cmcust  = '50' || substr( cmcust    , 3, 7 )
>
> cmcust is a 9.0 packed decimal.  The goal is to REPLACE the first two
> digits
> of cmcust with 50.
>
> In another library I used this in, the update worked as expected.  However,
> for reasons unknown to me, the update in this library replaced the 3rd &
> 4th
> digits of cmcust with 50.  Any ideas?
>
> FWIW, we just upgraded to V6R1 with cum PTF TL60215 applied.  I've been out
> of the OS admin side of things for too long to know whether that is a
> recent
> cum PTF.
>
> TIA,
> - Dan
> --
> 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.