Re: Embedded SQL Problem SQLSTATE 02000

[James Perkins <jrperkinsjr@xxxxxxxxx>]

You can't use a host variable for the library or table name. You have to
either build the SQL in a string or the better solution of changing your
library list before program execution.

HTH,
--
James R. Perkins
http://twitter.com/the_jamezp


On Wed, Jan 6, 2010 at 08:05, <DLee@xxxxxxxx> wrote:

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