RE: SQL Compiler Error - Don't know what is wrong

["Wills, Mike N. (TC)" <MNWills@xxxxxxxxxxxxxx>]

Thanks Rick, that got my program to pre-process. Thanks.

-----Original Message-----
From: Chevalier, Rick [mailto:Rick.Chevalier@xxxxxxxxxxxxxxx]
Sent: Tuesday, August 12, 2003 12:12 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: SQL Compiler Error - Don't know what is wrong


Mike,

Define the length for your DS.  The pre-compiler can't (or won't) compute
the length like the RPG compiler does.

Rick

-----Original Message-----
From: Wills, Mike N. (TC) [mailto:MNWills@xxxxxxxxxxxxxx]
Sent: Tuesday, August 12, 2003 11:17 AM
To: Midrange - RPG (E-mail)
Subject: SQL Compiler Error - Don't know what is wrong

I am getting a pre-processor compile error that I can't figure out.
Everything looks to be correct. I am on V5R2. Here is the error I am
getting.

  101        C+ FETCH INVCOUNT INTO :InvCountDS

SQL0312  30     101  Position 30 Variable INVCOUNTDS not defined or not
                     usable.


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