Re: Convert a substring to a decimal

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

There's a basic problem here - SRCSEQ and SRCDAT are ZONED, not PACKED - 
so DEC(6,2) will fail - you need the NUM(6,2) function - or even at more 
recent versions of the OS, you might be able to just use the SUBSTR - 
there are times when SQL on IBM i now just converts behind the scenes.

HTH
Vern

On 3/9/2022 12:39 PM, a4g atl wrote:
> I am battling to get this to work.
>
> I have a PC file with source from another system. The file is a basic text
> file with no delimiters.
>
> I need to import it into a source file and preserve the SRCSEQ, SRCDAT and
> SRCDTA.
>
> 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.
>
> How could I achieve this?
>
> TIA, DArryl Freinkel.