Message Level 2: DBMS Connector Requests
These messages provide different types of information depending on the connector request issued.
Connector Request |
Message and Definition |
---|---|
Logon path control: |
|
X is a connector code for the DBMS. dbms is the DBMS connector in use. |
|
X is a connector code for the DBMS. dbms is the DBMS connector in use. |
|
Table control: |
|
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. |
|
|
|
Data manipulation: |
|
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 X is preferred index access number (‘0’: row id or RFA). S is preferred index selection operator: LIKE, <, <=, =, =>, or >. |
|
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) |
L is length of I/O buffer. |
U Update (Update existing occurrence) |
L is length of I/O buffer. |
|
|
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. |
|
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: |
|
dbms is the DBMS connector in use. |
|
X is a connector code for the DBMS dbms is the DBMS connector in use |
|
X is a connector code for the DBMS. dbms is the DBMS connector in use. |