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

["Mackie, Roger L. (Precision Press)" <RLMackie@xxxxxxxxxxxxx>]

I should have spent more time thinking before sending. If I recall
correctly, You can use an externally described data structure on the file
you use in a "SELECT *", but not in the way you use it here. If you have 4
fields returned in SELECT statement, you need 4 host variables to receive
them. As far as I know there is no shorter way than:

  101        C+ FETCH INVCOUNT INTO :CompanyName, :CompanyNum, :POInvFlag,
:Count  

HTH,
Roger Mackie

-----Original Message-----
From: Wills, Mike N. (TC) [mailto:MNWills@xxxxxxxxxxxxxx]
Sent: Tuesday, August 12, 2003 11:17
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.

Here is my code:
     D InvCountDS      DS
     D  CompanyName                  30
     D  CompanyNum                    4  0
     D  POInvFlag                     1
     D  Count                         9  0

     C/Exec SQL
     C+ Declare INVCOUNT Cursor for
     C+   SELECT DBCPY_NAME, DBAPI_COMPANY, DBAPI_PO_INVOICE_FL, COUNT(*)
     C+     FROM LAWDBF7/DBAPAPI, LAWDBF7/DBAPCPY
     C+       WHERE DBAPI_COMPANY = DBCPY_COMPANY AND
     C+             ( DBAPI_PO_INVOICE_FL <> 'Y' AND
     C+             DBAPI_BATCH_DATE >= :FromDate AND
     C+             DBAPI_BATCH_DATE <= :ToDate )
     C+         GROUP BY DBCPY_NAME, DBAPI_COMPANY, DBAPI_PO_INVOICE_FL
     C+   UNION
     C+   SELECT DBCPY_NAME, DBAPI_COMPANY, DBAPI_PO_INVOICE_FL, COUNT(*)
     C+     FROM LAWDBF7/DBAPAPI, LAWDBF7/DBAPCPY
     C+       WHERE DBAPI_COMPANY = DBCPY_COMPANY AND
     C+             ( DBAPI_PO_INVOICE_FL = 'Y' AND
     C+             DBAPI_BATCH_DATE >= :FromDate AND
     C+             DBAPI_BATCH_DATE <= :ToDate )
     C+         GROUP BY DBCPY_NAME, DBAPI_COMPANY, DBAPI_PO_INVOICE_FL
     C/End-Exec

     C/Exec SQL
     C+ FETCH INVCOUNT INTO :InvCountDS
     C/End-Exec

Can anyone see anything wrong with this? I am sure it is something stupid,
but I can't see 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.