Re: Questions about RPG service program as an SQL UDF

I've got an ILE RPG service program that's registered as an SQL UDF.
It's a censorship function, used to censor a view, so that (for example)
sales reps see only the accounts they're supposed to see.

I actually wrote the thing months ago (it hasn't been touched since this
past September), and so I'm just now refamiliarizing myself with how it
works.

But it's determining what user to base its pass/censor decisions on from
this variable:

D myUser s 10a inz(*user)

Seems to work great from a terminal session, whether I'm using native
record level access, or a STRSQL session. But I'm wondering whether,
when the view is accessed from a BIRT report, via JDBC, this is going to
pick up the user making the query, or the user the QZDASOINIT job is
running under.

Another thing: I've got some initialization code in there that, at least
in theory, only needs to execute when the program is first called, and
when the user changes. Currently, the service program runs in the
*CALLER activation group; would I be better off in a named activation
group?

--
JHHL
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (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.