Re: Convert a substring to a decimal

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.

--
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