Re: RCAC Question

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Should have added that there is an API you can use programmatically...

Generate Data Definition Language (QSQGNDDL) API

Charles

On Thu, Oct 31, 2024 at 10:47 AM Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

> How about retrieving the SQL Source of the table?
>
> I'd expect that to show you the RCAC statements.
>
> Charles
>
>
>
> On Thu, Oct 31, 2024 at 10:34 AM Rich Loeber <rich@xxxxxxxxx> wrote:
>
> > Row and Column controls are additional security in the IBM i Db2 that let
> > you limit access to specific fields in a database to specific users and
> > also to limit access to certain records to certain users.  DSPFD tells me
> > nothing.  RCAC is all built by running SQL statements and there is no
> > "native" CL that you can use to set it up.
> >
> > Rich
> >
> > ________________________________
> >
> >
> > On 10/31/2024 12:31 PM, Patrik Schindler wrote:
> >
> > Hello Rich,
> >
> > Am 31.10.2024 um 17:22 schrieb Rich Loeber <rich@xxxxxxxxx><mailto:
> > rich@xxxxxxxxx>:
> >
> >
> >
> > I have a database file that was built with DDS.  Both Row and Column
> > controls have been implemented.
> >
> >
> >
> > What exactly are row and column controls in this context?
> >
> >
> >
> > Now I would like to see what those controls are.  I understand that they
> > are stored in the *FILE object, but is there a way to see what is already
> > configured if I don't have access to the SQL that was used to create them?
> >
> >
> >
> > Uhm. Above you said, you've used DDS to create the PF. This is confusing.
> >
> >
> >
> > Ideally, I'd really like to access this information programmatically.
> >
> >
> >
> > Please try dspfd output(*outfile). This should contain a lot of
> > information regarding a PF, no matter if SQL or DDS.
> >
> > :wq! PoC
> >
> >
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.