Re: SQL0420 error

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

I didn't see any explicit CAST, so it must doing an implicit cast.  I'd
start by explicitly casting mismatched data types.



> date: Thu, 23 Jan 2025 10:22:47 -0500
> from: "Art Tostaine, Jr." <atostaine@xxxxxxxxx>
> 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: .