×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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 mailing list archive is Copyright 1997-2024 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.
midrange.com
