Re: RE: SQL Error Help

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

Actually, I just got this error myself a few days ago. In my case, I was
fetching the fields into a data structure, and the data structure didn't
have the same number of fields as my SQL statement was returning (IIRC,
the data structure was missing a field).

Also, here's a little amplification on "dspmsgd sql0326 qsqlmsg":

Here's the secret to using DSPMSGD, as explained in the V4R5 "SQL
Programming Concepts" manual's "SQLCODEs and SQLSTATEs" appendix:

"Every SQLCODE has a corresponding message in message file QSQLMSG in
library QSYS. The message ID for any SQLCODE is constructed by appending
the absolute value (5 digits) of the SQLCODE to SQ and changing the third
character to 'L' if the third character is a 0. For example, if the
SQLCODE is -30070, the message ID is SQ30070."

(with thanks to someone on this list who posted this several months ago. .
. .)

hth,

rpg400-l@midrange.com writes:
>Message        ID   Severity  Message Text
> SQL0326        0     Too many host variables specified.
>
>I have not experienced this one myself so I can't say whether it means
>you've exceeded some limit or there is a mismatch between your host
>variables and SQL columns specified.


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com