Programming data areas needed when executing each Datacom/DB command.

Products

• Datacom
• DATACOM - AD
• COMMON SERVICES FOR Z/OS
• Common Services
• Datacom/DB

Issue/Introduction

For every application program command issued in the Datacom/DB environment, certain data areas are needed to identify the program issuing the command, or to hold data sent to or retrieved from the database. Is there a listing of what areas are needed for each command?

 

 

 

Resolution

Datacom/DB services are requested through the call facility of the particular language you are using in the application program. The entry point DBNTRY should be called with the following parameters as noted in the list below.

• User Information Block (UIB): The User Information Block is the first parameter of any call made to the Datacom/DB entry point, DBNTRY. To identify the program to Datacom/DB, specify up to 32-bytes of user information in this area. No special format is required, but the program name in the first eight positions is recommended. When logging is specified, the first eight characters are recorded in the log records for the task. Since this information is passed to user exits, site standards may require programs to supply specific information in this data block.
  
  
• Request Area (RA): The Request Area is used to specify requests made to Datacom/DB, and then test the results.  Datacom/DB also uses it to save control information between related requests.
  
  
• Work Area (WA): The work area is used with record update and add commands to pass the elements listed in the element list, to Datacom/DB. The elements are listed in the order required.  The work area is also used, in conjunction with record retrieval commands, to receive those elements back from Datacom/DB.
  
  
• Element List (EL): The element list specifies which data elements are to be retrieved, updated or added. The maximum number of elements per request is defined in the MAXELRQ MUF startup option (consult the person responsible for performing systems tasks).
  
  
• Request Qualification Area (RQA): The Request Qualification Area parameter is used only by commands which begin with SEL. The Request Qualification Area is used to pass set definition specifications for the select first (SELFR) command. A set definition includes a search condition, order-by specification and set options.

In the following list, Req indicates that the area is required for the command.

Command	Description	UIB	RA	WA	EL	RQA
ABEND	Abnormal Termination Command	Req	Req	Req
ADDIT	Add Record	Req	Req	Req	Req
CLOSE	Close User Requirements Table	Req	Req
CNTKR	Count for Key Value Range	Req	Req	Req
CNTKY	Count for Equal Key Value	Req	Req	Req
CNTTB	Count for Table	Req	Req	Req
COMIT	Commit Transaction	Req	Req
DELET	Delete Record	Req	Req
GETIT	Retrieve Next Sequential Record	Req	Req	Req	Req
GETPS	Get Next Physical Sequential Record	Req	Req	Req
GSETL	Set to Starting Key	Req	Req
GSETP	Set Physical Sequential Record	Req	Req	Req	Req
INQIN	Inquire CA Datacom/DB Version Level	Req	Req	Req
LOCBR	Locate Backwards	Req	Req
LOCKG	Locate Key Equal or Higher	Req	Req
LOCKI	Test for Logical Intersections of Two Keys	Req	Req
LOCKL	Locate Key Equal or Lower	Req	Req
LOCKR	Locate a Record in a Specified Range	Req	Req
LOCKX	Locate Key Exact	Req	Req
LOCKY	Locate Key Equal or Higher	Req	Req
LOCNE	Locate Next Equal Key Value	Req	Req
LOCNK	Locate Next Key	Req	Req
LOCNR	Locate Next Record in Specified Range	Req	Req
LOCNX	Locate Next	Req	Req
LOGCP	Checkpoint the Task	Req	Req	Req
LOGCR	Log Checkpoint with Release	Req	Req	Req
LOGDR	Log Directed Read	Req	Req	Req
LOGDW	Log Directed Write	Req	Req	Req
LOGIT	Add Data to Log Area	Req	Req	Req
LOGLB	Read Back a LOGIT Record	Req	Req	Req
LOGTB	Back Out Transactions	Req	Req
NOOPS	No Operation	Req	Req
OPEN	Open User Requirements Table	Req	Req
RDUBR	Read Backwards (Update)	Req	Req	Req	Req
RDUID	Read Record by ID (Update)	Req	Req	Req	Req
RDUKG	Read Record Greater Than/Equal to Key (Update)	Req	Req	Req	Req
RDUKL	Read Key Less Than or Equal to Key (Update)	Req	Req	Req	Req
RDUKR	Read Record in a Specified Range (Update)	Req	Req	Req	Req
RDUKX	Read Key Exact (Update)	Req	Req	Req	Req
RDUKY	Read Key Exact (Update)	Req	Req	Req	Req
RDULE	Read Located Entry (Update)	Req	Req	Req	Req
RDUNE	Read Next Equal Key Value (Update)	Req	Req	Req	Req
RDUNK	Read Record with the Next Sequential Key Value (Update)	Req	Req	Req	Req
RDUNR	Read the Next Record in a Specified Range (Update)	Req	Req	Req	Req
RDUNX	Read Next (Update)	Req	Req	Req	Req
REDBR	Read Backwards	Req	Req	Req	Req
REDID	Read Record by ID	Req	Req	Req	Req
REDKG	Read Record Greater Than/Equal to Key	Req	Req	Req	Req
REDKL	Read Key Less Than or Equal to Key	Req	Req	Req	Req
REDKR	Read Record in a Specified Range	Req	Req	Req	Req
REDKX	Read Key Exact	Req	Req	Req	Req
REDKY	Read Key Exact	Req	Req	Req	Req
REDLE	Read Located Entry	Req	Req	Req	Req
REDNE	Read Next Equal Key Value	Req	Req	Req	Req
REDNK	Read Record with the Next Sequential Key Value	Req	Req	Req	Req
REDNR	Read the Next Record in a Specified Range	Req	Req	Req	Req
REDNX	Read Next	Req	Req	Req	Req
RELES	Release Record	Req	Req
RELFL	Release Table	Req	Req
ROLBK	Roll Back Transaction	Req	Req
SELCN	Continue Set Record Selection	Req	Req	Req
SELFR	Select Set and Return First Record	Req	Req	Req	Req	Req
SELNR	Select Next Record	Req	Req	Req
SELPR	Release Set	Req	Req
SELSM	Select Same Record	Req	Req	Req
SELST	Stop Set Record Selection	Req	Req	Req
TEST	Test Option Command	Req	Req
UPDAT	Update Record	Req	Req	Req	Req