Message Level 2: DBMS Connector Requests

These messages provide different types of information depending on the connector request issued.

Code 2—Formats of Connector Function Call Messages
Connector Request	Message and Definition
Logon path control:
L Logon	`L,pseudo:`X`onconnector:`dbms X is a connector code for the DBMS. dbms is the DBMS connector in use.
A Logoff	`A,pseudo:`X`onconnector:`dbms X is a connector code for the DBMS. dbms is the DBMS connector in use.
Table control:
O Open	`O,mode:`M`,onfile/table:`table/filename M is: 0 = Open the file or table and do not create. 1 = Open the file or table and create if it does not exist. 2 = Special call for the Create Table facility. 4 = Generate SQL to create referential integrity constraints. 5 = Generate SQL to drop referential integrity constraints. 6 = Generate SQL to check for referential integrity violations.
Z Close	`Z,mode:0,onfile/table:`table/filename
Data manipulation:
S Select	`S,mode:`M`,onfile/table:`table/filename`index:`XS Where M is : 0 = Select records or rows and create hitlist. 1 = Select records or rows and return number of hits, but do not add to hitlist. 2 = Restricted look up function for existence check. 3 = Select new records or rows and append to the hitlist. 4 = Used for `selectdb`. X is preferred index access number (‘0’: row id or RFA). S is preferred index selection operator: LIKE, <, <=, =, =>, or >.
F Fetch	`F,mode:`M`,onfile/table:`table/filename`index:`XS Where M is : 0 = Fetch record or row. 1 = Fetch and lock record or row. 2 = Position record or row and lock. No data fetched; used for update and delete of overflow segments. X is index access number (‘0’ physical address: row id or RFA). S is index selection operator: LIKE, <, <=, =, =>, or >.
W Write (Insert new occurrence)	`W,mode:0,onfile/table:`table/filename`length:`L L is length of I/O buffer.
U Update (Update existing occurrence)	`U,mode:0,onfile/table:`table/filename`length:`L L is length of I/O buffer.
D Delete	`D,mode:0,onfile/table:`table/filename
Q Sql	`Q, mode:` M `,pseudo:` X `on connector:`dbms Where M is: 0 = Send an SQL statement to the DBMS. If the statement selects data, return the last row of the result. 2 = Return the first row of selected data. 3 = Return a subsequent row. X is a connector code for the DBMS. dbms is the DBMS connector in use.
* Wildcard delete/nullify	`*, mode:`M`,onfile/table:`table/filename`index:`XS Where M is: 0 = Cascading delete 1 = Nullify delete X is index access number (‘0’ physical address: row id or RFA). S is index selection operator: LIKE, <, <=, =, =>, or >.
Transaction control:
C Commit	`C,pseudo:`X`onconnector:`dbms dbms is the DBMS connector in use.
G Global transaction	`G,pseudo:`X`onconnector:`dbms X is a connector code for the DBMS dbms is the DBMS connector in use
R Rollback	`R,pseudo:`X`onconnector:`dbms X is a connector code for the DBMS. dbms is the DBMS connector in use.