×
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.
Found that already .... thanks.
Rich
________________________________
On 10/31/2024 1:09 PM, Marc Rauzier wrote:
Le 31/10/2024 à 17:33, Rich Loeber a écrit :
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.
What about GENERATE_SQL procedure?
https://www.ibm.com/docs/en/i/7.5?topic=services-generate-sql-procedure
Or, with iACS Database/Schemas tool, right click on the file (table) and Definition or Generate SQL/DDL option?
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><mailto: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
midrange.com
