Security Database Information and DSECTs › Accessing Security Information › DML Access

DML Access

Navigational DML

For navigational DML access to a security database, you specify the appropriate security subschema and issue DML statements to navigate the security records that are described later in this appendix.

You can issue navigational DML statements through CA OLQ, CA Culprit, or a user-written program to access the user catalog through subschema IDMSSECU and other security definitions in the system dictionary through subschema IDMSSECS. You cannot access SQL-defined database resources through navigational DML.

More Information

• For more information about using CA OLQ, see the CA OLQ User Guide.
• For more information about using CA Culprit, see the CA Culprit for CA IDMS User Guide.
• For more information about programming with navigational DML, see the CA IDMS Navigational DML programming Guide and the language-specific reference manual.

SQL DML

For SQL access to information about global and system resources, you define SQL schemas for the non-SQL-defined security schemas (IDMSSECU and IDMSSECS) and issue SQL statements that specify records in the security databases as tables.

Security information about SQL-defined database resources resides in the SQL-defined tables in the SYSTEM schema that are described later in this appendix.

More Information

• For more information about using the Command Facility to issue SQL statements, see the CA IDMS Common Facilities Guide.
• For more information about accessing a non-SQL-defined database with SQL, see the CA IDMS SQL Reference Guide.
• For more information about programming with SQL, see the CA IDMS SQL Programming Guide.