Re: Convert a substring to a decimal

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.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com