Re: embedded sql and object_statistics

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Jay,

I've run into that before. The problem is that as far as SQL is 
concerned, l_objects is a single entry in the list.

You would have to have something like

 where objname in (:l_objects1, :l_objects2, :l_objects3...)

which is difficult if you don't know the exact number of entries that 
would be in the list.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx
pdow@xxxxxxxxxxxxxx /

On 4/18/2023 9:31 AM, Jay Vaughn wrote:
> 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