Re: Convert a substring to a decimal

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

Possibly bad data?

I'd suggest trying select cast(substr(1,6) as dec(6,2)
 from qtemp.file and see if that work and looks sensible.
The repeat for cast(substr(7,6) as dec(6,0) and see if that works.
If all looks good, then try insert replacing substr(13,100) with 'abc'.

Sam

On 3/9/2022 1:39 PM, a4g atl wrote:
I have tried to use a SQL IMPORT as follows.
> 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.