× 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.



Thank you all for helping.  
Alan, I did try interactive and because of needing to substitute real values
never found it.  
Richard, thanks but don't spend any time on this tomorrow.

I have almost finished commenting out all SQL sections and putting them back
in one section at a time and then attempting a re-compile and have found my
problems.  
There was a DECLARE section and an UPDATE section where the field in the
file was alpha and the fields on the screen to update with were numeric.
The pre-compile error message only showed C/EXEC SQL, not the actual line
with the error.

Now to go and clean up my spool files.

Again, thank you all, even if you only thought about it and decided you
didn't know either.  :>)

Dave Boettcher

-----Original Message-----
From: Alan E. [mailto:steelville@xxxxxxxxxxx]
Sent: Saturday, October 11, 2003 6:30 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: SQL Pre-Compiler


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.
|

_______________________________________________
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.

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.