Re: Need to restrict User at Record level in file (Is it possible)

I also use SQL CURSOR loops.

The program start gets who the user is & what stuff that user has access to,
which is fed into the CURSOR definition.

A related topic is who the report is for.

We do a lot of reports where
Person-A actually generates it
Person-B actually uses it

On Thu, 02 Oct 2008 22:12:38 +0000, vhamberg wrote

Simple approach is to use SQL - have a SELECT statement using a host
variable - the branch number - in the WHERE clause. No need for tons
of logicals - just one with an index that includes the branch in an
appropriate order.

HTH
Vern
-------------- Original message ----------------------
From: Al Mac Wheel <macwheel99@xxxxxxxxxx>

You can build logicals on the fly.

The CL calls an RPG to identify the branches this user may access, then
uses that info to create a logical that only accesses that branch, then

OVR

specify that logical. It can be in QTEMP to limit long term disk space
impact, and expedite cleanup afterwards.
Performancewise that's effective only on small physical files.:

More details on Paul's response

http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/rzarl/rzar

llo

gical.htm

Basically they can only access the physical through various logical

files

or views. And the views or logical files could use selection criteria.
The problem with this is you then end up having multiple logical files

out

there with different security. So if you have 100 branches you end up
with 100 LFs against that physical (or more if your keen on different
sorting criteria). Think: Design for growth.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options, visit:
http://lists.midrange.com/mailman/listinfo/midrange-l or email:
MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment
to review the archives at http://archive.midrange.com/midrange-l.

--
WOW! Homepage (http://www.wowway.com)