Re: SQL0206 error

[CRPence <crpbottle@xxxxxxxxx>]

On 31-May-2017 11:32 -0600, Glenn Gundermann wrote:
> On 31 May 2017 at 13:23, Bill Howie wrote:
> > I’m getting an error that I can’t seem to diagnose. I’m using
> > iSeries Navigator to call a procedure and it’s throwing an SQL0206
> > error identifying a field as not being found. I know for sure the
> > field is in the table I’m accessing so I’m not sure why the error
> > is occurring.
> > Here’s my CALL statement:
> >
> > call library1.program1
> > (123456,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ')
> >
> > And here’s the procedure code:
> >
> > CREATE OR REPLACE PROCEDURE library1/program1(
> >    IN      SRVCTRNUM      NUMERIC(6),
> > [...]
> >    INOUT   CHANGE_STATUS  CHAR(1)
> > [...]
> >     SET CHANGE_STATUS = 0;
> > [...]
> >
> > SET CHANGE_STATUS = 1;
> > RETURN;
> >
> > END
> >
> > Any suggestions the group might have on where I’m going wrong with this
> > would be appreciated.  Thanks in advance!
> I'm not sure if this is the cause.
> You've defined CHANGE_STATUS as CHAR and yet you are setting the
> value  to a numeric.

  Implicit cast of the SQL, between numeric and character, would handle 
that; though, probably better to code explicitly than to depend on 
implicit effects.