Re: Embedded SQL with Coalesce

On 29 May 2012 14:03, Dave Boettcher wrote:

I have an embedded SQL statement which runs fine in the Navigator Run
SQL scripts window and gives me a SQLState of 22018 when I run the
RPGIV program that it's embedded in SQL0420 Message Text: Character
in CAST argument not valid. State 22018 <<SNIP>>

Perhaps FETCHing data into a numeric :HV where the result of the SELECTed column\expression result is character, but that character string value can not be cast to a numeric value? The iNav would process the expression according to its data type\length, whereas the embedded would FETCH into whatever are the data type\length of the host variables. Change the statement in iNav to INSERT INTO ... SELECT ... FROM ... such that the target of the insert matches the declarations of the host variables, and that statement should exhibit a similar failure as the failing FETCH.

Regards, Chuck