Data Manipulation Language Statements

Data Manipulation Language Statements

This chapter describes the Data Manipulation Language (DML) that applies to CA IDMS/DB, CA IDMS/DC, and CA IDMS UCF.

Note: The DC/UCF references in this chapter include both the CA IDMS/DC and CA IDMS UCF products.

DML consists of statements that enable you to access the database management system (DBMS) and to request Logical Record Facility (LRF) and data communications services.

This chapter presents the following information:

• Tables describing the database and data communications functions of DML statements
• Tables grouping the DML statements by function

Discussions of each DML statement (statements are in alphabetical order). Discussions include an overall description of the statement, Syntax, parameter descriptions, and examples

Important! When you review the Syntax for each DML statement, note that you must code the Parameters in the order in which they are shown.

This section contains the following topics:

Functions of DML Statements

DML Statements Grouped by Function

ABEND (DC/UCF)

ACCEPT (DC/UCF)

ACCEPT BIND RECORD

ACCEPT DBKEY FROM CURRENCY

ACCEPT DBKEY RELATIVE TO CURRENCY

ACCEPT IDMS STATISTICS

ACCEPT PAGE_INFO

ACCEPT PROCEDURE CONTROL LOCATION

ACCEPT TRANSACTION STATISTICS (DC/UCF)

ATTACH (DC/UCF)

BIND MAP (DC/UCF)

BIND PROCEDURE

BIND RECORD

BIND RUN_UNIT

BIND TASK (DC/UCF)

BIND TRANSACTION STATISTICS (DC/UCF)

CHANGE PRIORITY (DC/UCF)

CHECK TERMINAL (DC/UCF)

COMMIT

CONNECT

DC RETURN (DC/UCF)

DELETE QUEUE (DC/UCF)

DELETE SCRATCH (DC/UCF)

DELETE TABLE (DC/UCF)

DEQUEUE (DC/UCF)

DISCONNECT

END LINE TERMINAL SESSION (DC/UCF)

END TRANSACTION STATISTICS (DC/UCF)

ENDPAGE (DC/UCF)

ENQUEUE (DC/UCF)

ERASE

ERASE (LRF)

FIND/OBTAIN

FINISH

FREE STORAGE (DC/UCF)

GET

GET QUEUE (DC/UCF)

GET SCRATCH (DC/UCF)

GET STORAGE (DC/UCF)

GET TIME (DC/UCF)

IF

INQUIRE MAP (DC/UCF)

KEEP CURRENT

KEEP LONGTERM (DC/UCF)

LOAD TABLE (DC/UCF)

MAP IN (DC/UCF)

MAP OUT (DC/UCF)

MAP OUTIN (DC/UCF)

MODIFY MAP (DC/UCF)

MODIFY RECORD

MODIFY RECORD (LRF)

OBTAIN (LRF)

POST (DC/UCF)

PUT QUEUE (DC/UCF)

PUT SCRATCH (DC/UCF)

READ LINE FROM TERMINAL (DC/UCF)

READ TERMINAL (DC/UCF)

READY

RETURN (DC/UCF)

ROLLBACK

SEND MESSAGE (DC/UCF)

SET TIMER (DC/UCF)

SNAP (DC/UCF)

STARTPAGE (DC/UCF)

STORE RECORD

STORE RECORD (LRF)

TRANSFER (DC/UCF)

WAIT (DC/UCF)

WRITE JOURNAL (DC/UCF)

WRITE LINE TO TERMINAL (DC/UCF)

WRITE LOG (DC/UCF)

WRITE PRINTER (DC/UCF)

WRITE TERMINAL (DC/UCF)

WRITE THEN READ TERMINAL (DC/UCF)

Logical-Record Clauses (WHERE and ON)