I'm doing an embedded rpgle sql select on qsys2.object_statistics, and my
where clause contains...
where objname in (:l_objects)

l_objects = char(2048) and will contain a comma delimited string of
objects, just as sql "IN" would want to see... ie. 'OBJECT1', 'OBJECT2'

in debug it looks fine... I even tried (trim(:l_objects))

However when I run it, I get sqlcode 100.

But if I convert the thing to dynamic sql, i can get it to work. (but I
really don't want to have to do that)...

any suggestions to make it work without dynamic?

tia
Jay

This thread ...

Follow-Ups:

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.