Re: Convert a substring to a decimal

[John Yeung <gallium.arsenide@xxxxxxxxx>]

On Wed, Mar 9, 2022 at 1:38 PM a4g atl <a4ginatl2@xxxxxxxxx> wrote:
> I have tried
>
> INSERT into Lib/File
> (select
> cast(substr(1,6) as dec(6,2),
> cast(substr(7,6) as dec(6,0),
> substr(13,100)
> from QTEMP.File);
>
> I keep getting CAST errors SQL0420.

Well, if that is the exact SQL you entered, verbatim, then you've got
missing parens.

If you have the syntax correct, I am not sure why CAST doesn't work,
but in any case you could try the DEC function instead.

John Y.