Embedded SQL compile error

["Chandra Krieg" <ckrieg@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>]

I'm working on a project for a client and the following code gives me a
compile error on the fields of IN_CASENO, IN_RECNO and IN_RECITM which are
all pgm described fields.

 

 

     C/EXEC SQL

     C+  DECLARE csp2csr CURSOR FOR

     C+  SELECT ABABCD, ABACCD, ABADCD, ABAJCD, ABAICD

     C+  FROM CSPICASE2

     C+  WHERE (SUBSTR(ABABCD,6,13) >= :in_caseNo) AND

     C+        ABACCD >= :in_recno) AND

     C+        (SUBSTR(ABADCD,1,2) >= :in_recitm)

     C+  ORDER BY ABABCD, ABACCD, ABADCD

     C/END-EXEC     

 

I can't figure out why.  The error is that these fields are not defined or
unusable.

 

Any suggestions?

 

Thanks

ICTChandra