org.sourceforge.jxutil.net.ddm.qddrdbd
Class QRYROWSET

java.lang.Object
  |
  +--org.sourceforge.jxutil.net.ddm.qddprmd.DATA
        |
        +--org.sourceforge.jxutil.net.ddm.qddprmd.NUMBER
              |
              +--org.sourceforge.jxutil.net.ddm.qddprmd.BIN
                    |
                    +--org.sourceforge.jxutil.net.ddm.qddprmd.BIN16
                          |
                          +--org.sourceforge.jxutil.net.ddm.qddrdbd.QRYROWSET

public class QRYROWSET

extends BIN16

Query Rowset Size (QRYROWSET) on an OPNQRY or CNTQRY command indicates whether a rowset of rows is to be returned with the command. The effect of a command that returns a rowset is equivalent to performing the specified number of single-row fetches across the network, but since they are retrieved by a single command, the operation is more network-efficient. This parameter is not used for a multirow fetch (an atomic operation). See NBRROW for multirow fetches. For an OPNQRY command, a rowset of size S consists of the first row in the result table followed the next S-1 rows in sequence (FETCH NEXT) in the result table. For a CNTQRY command, a rowset of size S consists of the row fetched using the QRYSCRORN and QRYROWNBR in the CNTQRY followed by the next S-1 rows in sequence (FETCH NEXT) in the result table. QRYROWSET on a EXCSQLSTT command for a stored procedure call indicates whether a rowset of rows is to be returned for any non-dynamic scrollable cursors or for non-scrollable cursors conforming to the limited block query protocol returned by the stored procedure. For each such result set returned by the stored procedure, a rowset of size S consists of the first row in the result table for the result set followed the next S-1 rows in sequence (FETCH NEXT) in the result table. The rowset is said to be complete when the requested number of rows (S) are fetched or when a fetch results in a negative SQLSTATE or a SQLSTATE of 02000. Otherwise, the rowset is incomplete and it is the source SQLAM's responsibility to dispose of the incomplete rowset as indicated below. Generally speaking, with the exception of a very large row size relative to the query block size or a very large QRYROWSET value, a single CNTQRY request will result in a complete rowset. QRYROWSET applies to non-dynamic scrollable cursors and to non-scrollable cursors conforming to the limited block query protocol. For a non-scrollable cursor or result set, the following applies: If the QRYPRCTYP is FIXROWPRC, the QRYROWSET is ignored on all subsequent CNTQRY commands. If the QRYPRCTYP is LMTBLKPRC: - If QRYROWSET is not specified on the OPNQRY command or EXCSQLSTT command for a stored procedure call, then the QRYROWSET parameter is not allowed on any CNTQRY command for the cursor or result set - If QRYROWSET is specified on the OPNQRY command or EXCSQLSTT command for a stored procedure call, then the QRYROWSET parameter is required on every CNTQRY command for the cursor or result set If a QRYROWSET value is not specified for a non-dynamic scrollable cursor, then the following behavior applies for the cursor according to the QRYPRCTYP parameter returned on the

Field Summary

static short

CP

Fields inherited from class org.sourceforge.jxutil.net.ddm.qddprmd.BIN16

value

Constructor Summary

QRYROWSET(DDM ddm, int len)

Methods inherited from class org.sourceforge.jxutil.net.ddm.qddprmd.BIN16

write

Methods inherited from class org.sourceforge.jxutil.net.ddm.qddprmd.DATA

getCP, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

CP

public static final short CP

See Also:

Constant Field Values

Constructor Detail

QRYROWSET

public QRYROWSET(DDM ddm,
                 int len)
          throws IOException