Re: stored procedure(?) question

Well - you don't have to have the values in a table, you could build a
dynamic SQL statement and build up an IN Predicate from an array or
wherever you have the host values.

But I think I might have seen a more elegant solution that I can't
immediately recall.

On Thu, 4 Apr 2019 at 14:18, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Hi Tim

The list has to be in a data file of some kind - if it's in QTEMP or
wherever, you can use it.

What kind of thing is the list? It could be an array, content in a user
space, whatever. Let us know, we can help better, then.

Vern

On 4/4/2019 7:50 AM, tim wrote:

I have an rpg program that generates a list of invoices (not using sql
to create list). I would like to use this generated list in sql.

so,

select * from tablelist where invno in (rpg program generated list)

is this possible?

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com