org.sourceforge.jxutil.net.ddm.qddrdbd
Interface Constants

public interface Constants

Field Summary

static short	OUTOVRANY Output Override Allowed on Any CNTQRY.
static short	OUTOVRFRS Output Override Allowed on First CNTQRY.
static short	QRYDEL Query Deletable.
static short	QRYINS Query Insensitive to Changes.
static short	QRYRDO Query Read-Only.
static short	QRYSCRABS Query Scroll Absolute Orientation.
static short	QRYSCRAFT Query Scroll After Orientation.
static short	QRYSCRBEF Query Scroll Before Orientation.
static short	QRYSCRREL Query Scroll Relative Orientation.
static short	QRYSNSDYN Query Sensitive with Dynamic Membership.
static short	QRYSNSSTC Query Sensitive with Static Membership.
static short	QRYUNK Query Attribute is Unknown or Undefined.
static short	QRYUPD Query Deletable and Updatable.
static short	RTNEXTALL Return all EXTDTAs for QRYDTAs Sent.
static short	RTNEXTROW Return EXTDTAs by Row.

Field Detail

OUTOVRANY

public static final short OUTOVRANY

Output Override Allowed on Any CNTQRY. On an EXCSQLSTT or OPNQRY command, OUTOVRANY indicates that the query being opened allows an OUTOVR on any CNTQRY command sent by the source system. If the application requester specifies this option, the application server always selects FIXROWPRC for the query. If an OUTOVR object is sent as command data with a CNTQRY command, the answer set row will be fetched according to the descriptors in the OUTOVR. If an OUTOVR object is not sent with a CNTQRY command, the answer set row will be fetched according to the descriptors in the last OUTOVR received with a CNTQRY. If no previous CNTQRY command had an OUTOVR command data object, then the answer set row will be fetched according to the descriptors in the QRYDSC returned by the target with the OPNQRYRM.

See Also:

OUTOVROPT, Constant Field Values

OUTOVRFRS

public static final short OUTOVRFRS

Output Override Allowed on First CNTQRY. On an OPNQRY or EXCSQLSTT command, OUTOVRFRS indicates that the query being opened allows an OUTOVR on the first CNTQRY command sent by the source system. If an OUTOVR object is sent as command data with the first CNTQRY command, the answer set row and every subsequent row will be fetched according to the descriptors in the OUTOVR. If an OUTOVR object is not sent with the first CNTQRY command, the answer set row will be fetched according to the descriptors in the QRYDSC returned by the target with the OPNQRYRM.

See Also:

OUTOVROPT, Constant Field Values

QRYDEL

public static final short QRYDEL

Query Deletable. On an OPNQRYRM, the QRYDEL value in the QRYATTUPD parameter indicates that the query being opened allows read and delete operations on the cursor.

See Also:

Constant Field Values

QRYINS

public static final short QRYINS

Query Insensitive to Changes. On an OPNQRYRM, the QRYINS value in the QRYATTSNS parameter indicates that the query being opened is not sensitive to inserts, updates, or delete operations made to the underlying rows of the result table. Insensitive scrollable cursors are read-only.

See Also:

Constant Field Values

QRYRDO

public static final short QRYRDO

Query Read-Only. On an OPNQRYRM, the QRYRDO value in the QRYATTUPD parameter indicates that the query being opened is a read-only cursor.

See Also:

Constant Field Values

QRYSCRABS

public static final short QRYSCRABS

Query Scroll Absolute Orientation. On a CNTQRY, the QRYSCRABS value in the QRYSCRORN parameter indicates that the orientation for the fetch operaton(s) is absolute. The CNTQRY causes the row specified by its absolute row number to be fetched. If a QRYROWSET value is specified, the next rows in sequence after that row are fetched, according to the description in the DDM term QRYROWSET. This parameter may be used in conjunction with the QRYROWNBR parameter.

See Also:

Constant Field Values

QRYSCRAFT

public static final short QRYSCRAFT

Query Scroll After Orientation. On a CNTQRY, the QRYSCRAFT value in the QRYSCRORN parameter indicates that the orientation for the fetch operaton(s) is after, and that the cursor position is to be placed after the last row in the result table. The SQLSTATE returned for this operation is.

See Also:

Constant Field Values

QRYSCRBEF

public static final short QRYSCRBEF

Query Scroll Before Orientation. On a CNTQRY, the QRYSCRBEF value in the QRYSCRORN parameter indicates that the orientation for the fetch operaton(s) is before, and that the cursor position is to be placed before the first row in the result table. The SQLSTATE returned for this operation is 00000.

See Also:

Constant Field Values

QRYSCRREL

public static final short QRYSCRREL

Query Scroll Relative Orientation. On a CNTQRY, the QRYSCRREL value in the QRYSCRORN parameter indicates that the orientation for the fetch operaton(s) is relative. The CNTQRY fetches the row whose row number is relative to the current cursor position by the value in QRYROWNBR. For example, if QRYROWNBR is 2, then the row that is two rows previous to the current cursor position is fetched. If a QRYROWSET value is specified, the next rows in sequence after that row are fetched, according to the description in the DDM term QRYROWSET. This parameter may be used in conjunction with the QRYROWNBR parameter.

See Also:

Constant Field Values

QRYSNSDYN

public static final short QRYSNSDYN

Query Sensitive with Dynamic Membership. On an OPNQRYRM, the QRYSNSDYN value in the QRYATTSNS parameter indicates that the query being opened is sensitive to changes to the underlying rows of the result table. This includes changes made through the cursor by the application as well as committed changes made by other processes. In addition, the scrollable sensitive cursor being opened has a result table which dynamically changes size and ordering with updates to the base table. See the DRDA Technical Standard Appendix on Scrollable Cursors for an overview of scrollable cursors.

See Also:

Constant Field Values

QRYSNSSTC

public static final short QRYSNSSTC

Query Sensitive with Static Membership. On an OPNQRYRM, the QRYSNSDYN value in the QRYATTSNS parameter indicates that the query being opened is sensitive to changes to the underlying rows of the result table. This includes changes made through the cursor by the application as well as committed changes made by other processes. In addition, the scrollable sensitive cursor being opened has a result table with a static size and static ordering of rows. See the DRDA Technical Standard Appendix on Scrollable Cursors for an overview of scrollable cursors.

See Also:

Constant Field Values

QRYUNK

public static final short QRYUNK

Query Attribute is Unknown or Undefined. On an OPNQRYRM, the QRYUNK value in the QRYATTxxx parameter for which it is an enumerated value indicates that the query being opened does not have a defined value for this attribute or the value is unknown.

See Also:

Constant Field Values

QRYUPD

public static final short QRYUPD

Query Deletable and Updatable. On an OPNQRYRM, the QRYUPD value in the QRYATTUPD parameter indicates that the query being opened allows read, delete, and update operations on the cursor. Each such delete or update operation can cause the base table to be modified and applies to a row that has been fetched.

See Also:

Constant Field Values

RTNEXTALL

public static final short RTNEXTALL

Return all EXTDTAs for QRYDTAs Sent. On a CNTQRY command, RTNEXTALL indicates that the source system expects to receive all the EXTDTA objects associated with QRYDTA objects returned in response to the CNTQRY command.

See Also:

RTNEXTDTA, QRYBLK, Constant Field Values

RTNEXTROW

public static final short RTNEXTROW

Return EXTDTAs by Row. On a CNTQRY command, RTNEXTROW indicates that the source system expects to receive externalized data objects from the target separately from the base data and one row at a time if the query can return any such objects. Each CNTQRY command can return data in one of the following ways: "One or more QRYDTA objects if there are no EXTDTAs associated with any rows in the QRYDTA objects. The next CNTQRY command retrieves additional base data. "One or more QRYDTA objects if there are EXTDTAs associated with one or more rows in the QRYDTA objects. Each subsequent CNTQRY command retrieves the EXTDTAs for the next row having associated EXTDTAs until all pending EXTDTAs are retrieved by the application requester. "One or more EXTDTA objects for the next row in a previously returned QRYDTA objects. See CNTQRY for details.

See Also:

RTNEXTDTA, Constant Field Values