Accessing Tables Outside ASF › CA IDMS/DB Data Manipulation Language (DML)

CA IDMS/DB Data Manipulation Language (DML)

ASF-defined tables are implemented as logical records. Application programs using DML statements can access tables through the Logical Record Facility (LRF). The LRF DML commands OBTAIN, STORE, MODIFY, and ERASE are used to manipulate data in tables defined through ASF.

Build Access Paths

For a program to access a particular table, a predefined access path must exist in the subschema for the DML verb being used. The paths are defined according to the responses contained in the following fields on the Extended Table Definition screen:

• Display Access—If YES (default), an OBTAIN path is built, allowing a program to retrieve the table.
• Load Access—If YES, a STORE path is built, allowing a program to load data into the table. YES is the default for stored tables. For views, this field is always NO and cannot be changed, though the DBA can define a STORE path for the view by using the subschema compiler.
• Change Access—If YES (default), a MODIFY path is built, allowing a program to change data in the table.
• Erase Access—If YES, an ERASE path is built, allowing a program to delete data from the table. YES is the default for stored tables. For views, this field is always NO and cannot be changed, though the DBA can define an ERASE path for the view by using the subschema compiler.

Access Tables from Programs

Data tables can be accessed through LRF DML programs written in COBOL, PL/I, or Assembler.

To access a stored table or view through a DML program, specify the logical record name. The logical record name and the subschema name can be obtained from the Extended Table Definition screen. The schema name assigned at installation is IDMSR.

Note: When accessing a data table through a DML program, any selection criteria and/or calculations defined for the table will apply.

This product ignores row-level security.