Database Connector Requests

A database connector implements a set of generic Uniface requests for the underlying DBMS. Connector requests are well-defined tasks performed by the DBMS connector when it is called.

Connector requests are recognized by every Uniface DBMS connector. Each request is identified by an alphabetic character, such as O for Open or S for Select.

The field uctrl->ufunc indicates the connector request that must be performed. Some connector requests have multiple modes. The requested mode is available in the field uctrl->umode in all connector requests, except the Info request. In the Info request, the mode is available in the field uinfo->umode.

Uniface Connector Requests

Connector Request	Value of uctrl->ufunc	Description	Details
Connector control:
Info	I	Supply DBMS and connector characteristic.	Info('I')
Message	M	Translate a connector or DBMS error code to a text.	Message ('M')
Logon path control:
Logon	L	Log on to the DBMS.	Logon ('L')
Logoff	A	Log off from the DBMS.	Logoff ('A')
Table control:
Open	O	Open a table or create Data Definition Language (DDL) scripts to define a table and its relations.	Open ('O')
Name table	N	Construct the name of the overflow table.	Name table ('N')
Close	Z	Close a table.	Close ('Z')
Data manipulation:
Select	S	Select the records that match a specified profile.	Select ('S')
Fetch	F	Fetch or lock a record.	Fetch ('F')
Write	W	Insert a new record.	Write ('W')
Update	U	Update an existing record.	Update (U)
Delete	D	Delete a record.	Delete ('D')
Wildcard delete/nullify	*	Delete or nullify a set of records.	Wildcard delete/nullify (*)
Transaction control:
Commit	C	Commit a transaction.	Commit ('C')
Rollback	R	Roll back a transaction.	Rollback ('R')
Global Transaction	G	The connector is transaction manager (TM) controlled and the kernel needs TM-specific information.	Global Transaction ('G')
Miscellaneous:
Sql	Q	Submit a Data Manipulation Language (DML) statement to the DBMS.	Q Sql