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


  1.  Home
  2. RPG400-L
  3. November 2006

Re: SQL0314 error with compile using CRTSQLRPGI

Hi,
it's not because the precompiler checks the SQL-statements, but because it checks all the host variables used in any SQL-statement. If you create a separate field in the D-Specs and move itmnbr into it and use this field in the SQL statement, the precomiler will not complain about duplicate fields. 

Mit freunlichen Grüßen / Best regards

Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown) 
"If you think education is expensive, try ignorance." (Derek Bok)
----- Original Message ----- From: "Glenn Gundermann" <ggundermann@xxxxxx> 
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, November 29, 2006 16:34
Subject: Re: SQL0314 error with compile using CRTSQLRPGI



Rob,

You're right again.  I removed the reference to itmnbr in the select and
into and it still fails the compile, complaining about the line
"where itmnbr = :itmnbr".

Interesting isn't it.

You'd think that if IBM changed how it works for V5R4 that they could PTF
the change back to V5R3.

I'll compile with GENLVL = 11 for now and maybe do the D-spec method
Birgitta suggested later.

Glenn
I wonder if you remove it, if the message will go away? Isn't it pointing 
to itemnbr?

Rob Berendt

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