db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: [jira] Commented: (DERBY-822) Client driver: Pre-fetch data on executeQuery()
Date Sat, 11 Feb 2006 18:40:18 GMT
> I am not convinced that the comment about LMTBLKPRC is correct, I
> think it is also allowed for FIXROWPRC. Will look more into that.

I think so, too, although there are a number of restrictions in the
fixed row query protocol case. From page 126 of DRDA V.1:

   For the fixed row query protocol, the qryrowset is a parameter on
   the OPNQRY command that allows the requester to specify the return
   of a rowset with the OPNQRYRM. This parameter applies only to
   scrollable, non-sensitive dynamic, non-rowset cursors (QRYATTSCR
   is TRUE, QRYATTSNS is not QRYSNSDYN, QRYATTSET is FALSE). For these
   cursors, qryrowset specifies that a DRDA rowset is to be returned
   with the OPNQRYRM (see Appendix B (on page 655) for more information
   about DRDA rowsets). For all other cursors, the parameter is ignored
   and no data is returned with the OPNQRYRM.

Note that not only are there restrictions, but it also seems that
the client has to request this rowset. We can't just send it
automatically when the restrictions are met unless the client also
sets qryrowset.

thanks,

bryan



Mime
View raw message