Data Manipulation Language Statements

Data Manipulation Language Statements

This chapter describes each data manipulation language (DML) statement that requests CA IDMS/DB database access or online service. The DML commands are presented in two ways:

• The first table presents the commands by function.
• Each DML command is presented in alphabetical order. The discussion of each command includes:
  • A description of the DML statement
  • Syntax and syntax rules
  • Currency considerations, where applicable
  • An example of how to use the statement
  • Error handling after a DML statement is issued

The WHERE and ON clauses that are used with DML statements to access logical records created by the Logical Record Facility (LRF) are described at the end of this chapter.

This section contains the following topics:

Functions of DML Statements

#ABEND—terminates the issuing task abnormally

@ACCEPT BIND—moves the bind address

@ACCEPT DBKEY FROM CURRENCY—moves the db-key of the current record

@ACCEPT DBKEY RELATIVE TO CURRENCY—moves the db-key

@ACCEPT PGINFO—moves the page information

@ACCEPT PROC—moves the information block

@ACCEPT STATS—moves system runtime statistics

#ACCEPT—retrieves system task-related information

#ATTACH—instructs the system to initiate a new task

@BIND PROC—establishes communication

@BIND REC—establishes addressability for a record

@BIND SUBSCH—helps the run unit

#BIND TASK—initiates a DC/UCF task

#CHAP—changes the dispatching priority

@COMMIT—commits changes made to the database

#COMMIT—commits changes made to the database

@CONNECT—establishes a record occurrence

#DELETE—notifies the DC/UCF system

#DELQUE—deletes all or part of a queue

#DELSCR—deletes scratch records

#DEQ—releases resources acquired by the issuing task

@DISCON—cancels the current membership of a specified record

#ENQ—acquires resources or tests for availability

#ENDPAG—terminates a map paging session

@ERASE—disconnects or erases records

@ERASE (LRF)—deletes logical record occurrences

@FIND/@OBTAIN Statements—accesses database records

@FINISH—commits changes to database and terminates run unit

#FINISH—commits changes to the database

#FREESTG—requests that the system release variable storage

@GET—transfers the contents of an accessed record occurrence

#GETIME—gets time and date from the operating system

#GETQUE—retrieves a queue record

#GETSCR—retrieves a scratch record

#GETSTG—acquires variable storage from a storage pool

@IF—tests for the presence of member record occurrences

@KEEP—places an explicit shared or exclusive lock on a record

#KEEP—establishes long-term record locks

#LINEEND—requests termination of the current line I/O session

#LINEIN—requests a synchronous transfer of data

#LINEOUT—requests a transfer of data

#LINK—establishes linkage with a program

#LOAD—loads a module into the program pool

#MAPINQ

#MAPMOD—requests that the system modify options in the map request block

@MODIFY—replaces element values of the database record

@MODIFY (LRF)—changes field values of an existing logical-record occurrence

#MREQ—determines how data is transferred

@OBTAIN (LRF)—retrieves the named logical record

#POST—modifies an event control block

#PRINT—requests that the system transmit data

#PUTJRNL—writes a task-defined record to the journal file

#PUTQUE—stores a queue record in the queue

#PUTSCR—stores or replaces a scratch record

@READY—prepares a database area for access by DML functions

@RETURN

#RETURN—returns control to a program

@ROLLBAK—rolls back uncommitted changes made to the database

#ROLLBAK—rolls back uncommitted changes made to the database

#SENDMSG—sends a message to another terminal or user

#SETIME

#SNAP

#STAE

@STORE

@STORE (LRF)

#STRTPAG

#TREQ

#TRNSTAT

#WAIT

#WTL

#XCTL

Logical Record Clauses