RE: SQL0420 error

Going to ask the stupid question here, but, since iACS works and EXEC SQL doesn't, do you *know* that the statement in your EXEC SQL resolves to what you posted? Are your single quotes actually single quotes in the resolved statement being executed? Also, I agree with Rob; what appears after the end of your post?

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art Tostaine, Jr.
Sent: Thursday, January 23, 2025 10:23 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: SQL0420 error

How do I handle this error? This only happens when using EXEC SQL in RPG but not in iACS Sql.

PID is define as char(30)

CODE:
select ln.lv1, ifnull(sl.pid,' ') from e832 ln left join e832sln sl on ln.mid = sl.mid and ln.seq = sl.seq where ln.shp = :shp and ln.LV4 = 'PPK'
order by ln.lv1

Message . . . . : Value for cast argument not valid.

Cause . . . . . : A character in the argument for a casting function was
not
correct or the argument could not be converted to a numeric value.

For the INTERPRET function, the length of the first argument must exactly
match the length required for the result data type. For example, an integer
result data type requires the first argument to have a length of four.

The following information can be used to help identify the source of the
error: .
*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***