Assembler Data Manipulation Language Statements

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

idmscu19

This section describes each data manipulation language (DML) statement that requests CA IDMS/DB database access or online service. The DML commands are presented in the following 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 in Logical Record Clauses.

DML Reference for Assembler

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

#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 -- returns control to a program

@ROLLBAK -- rolls back uncommitted changes made to the database

#ROLLBAK -- rolls back the Uncommitted Changes Made to the Database

#SENDMSG -- sends a message to another terminal or user

#SETIME -- defines an event to occur after a specified time interval

#SNAP -- requests a memory snap

#STAE -- establishes or cancels linkage to an abend routine

@STORE -- acquires space and stores records in the database

@STORE (LRF) -- updates the database with field values for new record occurrances

#STRTPAG -- initiates a map paging session

#TREQ -- transfers data between a terminal device and your application

#TRNSTAT -- enables access to transaction statistics about tasks

#WAIT -- relinquishes control to the system

#WTL -- retrieves, sends, and writes messages

#XCTL -- transfers control to a specified program

Logical Record Clauses