× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.