OPNQRYRM reply message (X'2205')

The distributed data management (DDM) architecture OPNQRYRM (open query) reply message indicates that the open query (OPNQRY) command or execute SQL statement (EXCSQLSTT) command completed normally, and that a query process has been initiated.

This reply message also indicates the type of query protocol and cursor that are used for the query.

Format

Parameters

DSSHDR

The 6-byte header that contains information about the data stream structure (DSS).

LL

The length specified as a 2-byte binary integer. This length includes LL and CP.

CP

X'2205', the 2-byte codepoint of the OPNQRYRM reply message.

QRYATTSCR

An optional parameter that specifies the query attribute for scrollability. The codepoint is X'2149'.

QRYATTSET

An optional parameter that indicates whether a cursor is enabled for the a single row or multiple rows to be returned. The codepoint is X'214A'.

QRYATTSNS

An optional parameter that specifies the sensitivity of an opened cursor to changes made to the underlying base table. The codepoint is X'2157'.

QRYATTUPD

An optional parameter that indicates the updatability of an opened cursor. The codepoint tis X'2150'.

QRYBLKFCT

An optional parameter that contains the value of the blocking factor, a limit that is imposed by the target server that dictates the number of rows that can be blocked at a time for a query. The codepoint is X'215F'.

QRYBLKTYP

An optional parameter that indicates the type of query blocks in which the answer set data will be returned. The codepoint is X'2133'.

QRYINSID

A required parameter that uniquely identifies the instance of a query. The codepoint is X'215B'.

This parameter is returned on the OPNQRYRM reply message by the target server when a query is opened. Any subsequent references to this query by the target server must include the QRYINSID value in order to identify the correct instance of the query.

QRYPRCTYP

A required String parameter that specifies the type of query protocol that is used. The codepoint is X'2102'.

SQLCSRHLD

An optional Boolean parameter that indicates whether the requester specified the hold cursor position option. The codepoint is X'211F'.

SRVDGN

An optional parameter (X'1153') that contains server diagnostic information. The data portion is a string with a maximum length of 32,767 bytes. The string can be any information the server sends to aid in problem diagnosis. For more information about SRVDGN, see DRDA, Version 4, Volume 3: Distributed Data Management (DDM) Architecture, which is available from The Open Group at www.opengroup.org.

SVRCOD

A required parameter (X'1149') that contains the severity code. SVRCOD consists of a 2-byte length field (LL), a 2-byte codepoint (CP), and the data. The data is a 2-byte binary value. The following list describes the possible 2-byte values:

0: INFO – Information only severity code
4: WARNING – Warning severity code
8: ERROR – Error severity code
16: SEVERE – Severe error severity code
32: ACCDMG – Access damage severity code
64: PRMDMG – Permanent damage severity code
128: SESDMG – Session damage severity code

For more information on these parameters, see DRDA, Version 4, Volume 3: Distributed Data Management (DDM) Architecture, by the Open Group.

Reply data objects

The following reply data objects can be chained to the OPNQRYRM message in response to the OPNQRY command:

QRYDSC (X'241A'): Query answer set description.
QRYDTA (X'241B'): Query answer set data.