I have a question/suggestion.

My requirement is as follows:

I am creating a feature that lists programs and their authorised users. This list will be used with the IceBreak Exit program.
There are two types of users – real i5/OS users and “Virtual Users”. Virtual users have their userIDs and passwords stored in a file.
In the browser I want to display the list of users that have not been authorised to a specific program. In the case of Virtual Users this is a straight forward Exception Join SQL
However, in the case of i5/OS users this is not so straight forward. The method is as follows:

1. List users to ILOB with QUSLOBJ
2. For each user in the list we need an query to determine if the user is present the authorised list, if so, this user information is NOT sent to the browser. This means we need to run a query for each user in the list.
3. Result, the browser only displays users that have not been authorised.

Running a query for each user on the system is not very efficient and could result in very slow response times. So – there are two other ways to handle this:

1. Don’t use SQL – use SETLL instead to determine if a record exists, or
2. Do a single query (using a cursor) and dump all authority records into an ILOB. The ILOB can then be searched for each user entry processed.

So – my question is – to avoid re-inventing any wheels – Is there an IceBreak function that accepts an SQL string and returns the result of the query in an ILOB. – if so, do you have any examples?

Regards
Syd