Build-information might be used by an advanced application building its own request parcels (DBCAREA option Request-mode=B) to obtain needed information that is otherwise unavailable. Such information might be used to ascertain parcels that the database supports or how to construct such parcels.
Refers to the session whose CLIv2 connection number is specified in the QEPCONN field. Since they do not apply, the QEPTLEN, QEPRQST, and QEPTOKEN fields must contain binary zeroes.
Returns information for advanced applications. Since new items may be added in the future the length of the result may vary depending on the version of CLIv2 or TDP.
Item Code | Mnemonic | Response DBQERBI (DbqerBI for C) | |
---|---|---|---|
Field | Value | ||
54 | QEPIBI | QERBIXN ('extNameStatus' for C, EXT-NAME-STATUS for COBOL, EXT_NAME_STATUS for PL/I) | One of the following EBCDIC characters:
|
QERBISE ('stmtErrorStatus' for C, STMT-ERROR-STATUS for COBOL, STMT_ERROR_STATUS for PL/I) | One of the following EBCDIC characters:
This information is deprecated by the Multi-statement-errors-support query. |
||
QERBIRC ('rowCountStatus' for C, ROW-COUNT-STATUS for COBOL, ROW_COUNT_STATUS for PL/I) | One of the following EBCDIC characters:
|
||
QERBIAT ('arrayXformsOffStatus' for C, ARRAY_XFORMS-OFF-STATUS for COBOL, ARRAY_XFORMS_OFF for PL/I) | One of the following EBCDIC characters:
|
||
QERBIXM ('xmlStatus' for C, XML-STATUS for COBOL, XML_STATUS for PL/I) | One of the following EBCDIC characters:
|
||
QERBIFF ('fastFailStatus' for C, FASTFAIL-STATUS for COBOL, FASTFAIL_STATUS for PL/I) | One of the following EBCDIC characters:
|
||
(Reserved: 2 bytes) | |||
QERBISMN ('maxNumSeg' for C, MAX-NUM-SEG for COBOL, MAX_NUM_SEG for PL/I) | A two-byte unsigned integer indicating the maximum number of segments that may be used to transfer an SQL Stored Procedure to the database. If the value is zero, then the SQL Stored Procedures are not supported; otherwise, there is no meaningful use for this value. For information about SQL Stored Procedures, see Stored Procedures. | ||
QERBILR ('largeRowsStatus' for C, LARGE-ROWSSTATUS for COBOL, LARGE_ROWS_STATUS for PL/I) | One of the following EBCDIC characters:
|