Re: Embedded SQL Problem SQLSTATE 02000

Thanks Care and Alan for your reply;

I got this working I think because I removed the quote. Thanks

Here is what I ended up with for my select..

SELECT * FROM SWFILES/CLMPAY WHERE CMCOCD = ? AND CMPSTD =
? ORDER BY CMPSTD, CMCOCD, CMAGNT, CMCOVC, CMPOLM, CMFILE,
CMPCHK

Alan the reason I wanted to prep, was because I may want to substitue the
library name, the host variables each time the program is run, depending
if this is run in production, or against a different company(CMCOCD) or
period ending date (CMPSTD)

The above was accomplished by hard coding the library name (SWFILES) I
also successfully ran it by removing the library reference completely.

Any suggestions on how I can do it better, much welcome,

I don't do embedded SQL often, so each time is a challenge.

Thanks again for your help.

Regards,



SWBC
9311 San Pedro Ave., Suite 600
San Antonio, TX 78216

Visit our website at www.swbc.com

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