Re: SQL Pre-Compiler

["Alan E." <steelville@xxxxxxxxxxx>]

Sounds like maybe one of the compile-command parameters on
how to handle values, that differ between the interactive
job and the compile? Maybe the PDM submit option values, and
the two steps done individually and interactive.

The other thing that comes to mind is, maybe the precompiler
is still generating these errors anyway, but the RPG compile
doesn't recognize the problem within the SQL. In fact, this
sounds to me like it's the most likely case.

Maybe you still get the message in your SQL pre-compile, but
the source is converted anyway as best it can be, but then
you intervene "manually" and tell it to compile RPG anyway.
Then the RPG compiler per se can't see it because it's SQL.
Likely you'd get the same message when running that SQLRPG
program.

What I try to do if possible is to go to an interactive SQL
screen and put it in there. Sometimes that's when it pops
out at you.

Alan


----- Original Message -----
From: "Dave Boettcher" <DBoettch@xxxxxxxxxxxxxxxx>
To: "'RPGIV Discussion Group'" <RPGIV@xxxxxxxxxxxxxxx>;
<rpg400-l@xxxxxxxxxxxx>
Sent: Friday, October 10, 2003 5:50 PM
Subject: SQL Pre-Compiler


| I have resolved a lot of SQL errors today, but two of them
won't go away.
|
| The precompile listing says:
|    458        C/EXEC SQL
|
|    570        C/EXEC SQL
|
|
|                                               DIAGNOSTIC
MESSAGES
|
|  MSG ID  SEV  RECORD  TEXT
|
|  SQL0401  30     458  Position 17 Comparison operator =
operands not
|
|                       compatible.
|
|  SQL0401  30     570  Position 17 Comparison operator =
operands not
|
|                       compatible.
|
| I resolved and made two other errors go away, but these
two stay.  I cannot
| figure out what could be wrong with these statements. And
I have looked
| around them as well but no clues.
|
| The strange thing is that if I compile interactively and
then try to compile
| the source member from QTEMP/QSQLTEMP1, where the
pre-compiler puts the
| temporary source, there is no problem compiling -- I get a
program object
| and a good  RPG compile listing.
|
| I even tried signing off CODE and the AS/400 and signing
back on but no
| help.
|
| Maybe it will fix itself over the weekend.  Or one of the
smart people on
| one of the lists will have a suggestion.
|
| Thanks in advance,
|
| Dave  Boettcher
| David P. Boettcher CCP
| Senior Systems Analyst and Coordinator
| IBM Certified Specialist - RPG IV Developer
| Kenosha County Information Services
| Kenosha, WI   53140-3747
| * e-mail: dboettch@xxxxxxxxxxxxxxxx
|
| Anyone can make a mistake; only a fool insists on
repeating it.
|
|
| _______________________________________________
| This is the RPG programming on the AS400 / iSeries
(RPG400-L) mailing list
| To post a message email: RPG400-L@xxxxxxxxxxxx
| To subscribe, unsubscribe, or change list options,
| visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
| or email: RPG400-L-request@xxxxxxxxxxxx
| Before posting, please take a moment to review the
archives
| at http://archive.midrange.com/rpg400-l.
|