RE: SQL Pre-compiler Fields Names Undefined

[Jerry Adams <Jerry@xxxxxxxxxxxxxxx>]

Well, I've used it before (took it from an example somewhere, but forget where) without incident, but just to be sure I change it to jcastring.  Same errors.

Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email:  jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Monday, September 21, 2009 1:59 PM
To: RPG programming on the IBM i / System i
Subject: Re: SQL Pre-compiler Fields Names Undefined

Note: variable names beginning with SQL (ie. SQLString) are reserved
for IBM's use.

Perhaps you are confusing the pre-compiler?

try changing any SQLxxxx variables to something else (perhaps wSQLxxxx
or mySQLxxxxx)

Charles


On Mon, Sep 21, 2009 at 2:49 PM, Jerry Adams <Jerry@xxxxxxxxxxxxxxx> wrote:
> Sorry about that; don't know what happened.  I confirmed this time (http://code.midrange.com/2007d2aa1e.html) that the end of compile message got posted to the code site member.
>
> SQLString is used in the $BuildList subprocedure.  And, indeed, it (sqlstring) is simply used to retrieve records from a sequential file and to order them based upon a panel option.  The cursor, too, is declared in the $BuildList procedure.
>
> Jerry C. Adams
> IBM System i Programmer/Analyst
> --
> B&W Wholesale
> office: 615-995-7024
> email:  jerry@xxxxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
> Sent: Monday, September 21, 2009 1:28 PM
> To: RPG programming on the IBM i / System i
> Subject: RE: SQL Pre-compiler Fields Names Undefined
>
> 1 - It's missing data at the bottom, which is often useful on a compile
> listing.   ;-)
> 2 - The source file rather confirms that it was sql
> #   Source File  . . . . . . . . . . :  QSQLTEMP1
> #     Library  . . . . . . . . . . . :    QTEMP
>
> I don't see where sqlString is used.  I can see where it is built.  I
> don't see it put into a cursor.  And since it doesn't use a SELECT INTO
> but just a plain SELECT it has to go into a cursor, right?
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:
> Jerry Adams <Jerry@xxxxxxxxxxxxxxx>
> To:
> RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
> Date:
> 09/21/2009 02:04 PM
> Subject:
> RE: SQL Pre-compiler Fields Names Undefined
> Sent by:
> rpg400-l-bounces@xxxxxxxxxxxx
>
>
>
> http://code.midrange.com/b8df851c47.html has the compiler listing.
>
> Jerry C. Adams
> IBM System i Programmer/Analyst
> --
> B&W Wholesale
> office: 615-995-7024
> email:  jerry@xxxxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of rob@xxxxxxxxx
> Sent: Monday, September 21, 2009 12:07 PM
> To: RPG programming on the IBM i / System i
> Subject: Re: SQL Pre-compiler Fields Names Undefined
>
> Can you post the compiler listing there also?
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:
> Jerry Adams <Jerry@xxxxxxxxxxxxxxx>
> To:
> "Midrange-RPG (rpg400-l@xxxxxxxxxxxx)" <rpg400-l@xxxxxxxxxxxx>
> Date:
> 09/21/2009 12:51 PM
> Subject:
> SQL Pre-compiler Fields Names Undefined
> Sent by:
> rpg400-l-bounces@xxxxxxxxxxxx
>
>
>
>  I am having a problem getting an SQLRPGLE program to compile.  The code
> is at http://code.midrange.com/606a197b81.html .
>
> After clearing up some fat finger errors, the only errors that I am
> getting now are RNF7030 The name or indicator is not defined.  And all of
> the undefined field names are those created by the pre-compiler, including
>
> basic thing, like sqlstate and sqlcode.  I've double- (and triple-)
> checked that the source member type is SQLRPGLE (even copied and pasted it
>
> here in case dyslexia was setting in).
>
> I have compared it to a similar program that I wrote last year.  Even
> re-compiled that one to be sure that, perhaps, a recent PTF changed
> something, but that program compiled fine.
>
> I know this is going to turn out to be a 'Duh' moment, but my one good eye
>
> is getting blurred looking at the code for the last five hours.  Your
> assistance is appreciated.
>
> Thanks.
>
> Jerry C. Adams
> IBM System i Programmer/Analyst
> --
> B&W Wholesale
> office: 615-995-7024
> email:  jerry@xxxxxxxxxxxxxxx
>
> --
> This is the RPG programming on the IBM i / System i (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 IBM i / System i (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 IBM i / System i (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 IBM i / System i (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 IBM i / System i (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.