×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




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




This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 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.