Extended Dynamic Package support and .NET

All,



Was trying to determine if the .NET provided supports extended dynamic packages like the ODBC, and
OLEDB provides do.



Found the following in the IBM DB2 UDB for iSeries .Net Provider Technical Reference:



iDB2QueryOptimizeGoal

The following table shows the iDB2QueryOptimizeGoal enumeration supported by the Managed Provider.



Enum value Description

----------------- ------------------

Default Optimize queries based on whether SQL packages (extended dynamic) are being used.
When not using packages, queries are optimized with the goal of returning the first block of data
quickly (FirstBlock). When packages are used, queries are optimized with the goal of returning the
entire query result quickly (FullQuery). Because the Managed Provider does not support SQL packages
(extended dynamic), the Default value has the effect of always optimizing based on FirstBlock.



FirstBlock Optimize queries with the goal of returning the first block of data quickly. This
is the best option to use if you know you do not plan to read the entire result set into your
application, or if you are using a DataReader to read your data.



FullQuery Optimize queries with the goal of returning the entire query result quickly. This
is the best option to use when using a DataAdapter, because filling a DataAdapter always causes the
entire result set to be read.





So it would seem that the answer is no, which seems surprising to me.



Too bad, now I have to convince the .NET developers to quit using dynamic statements when the
statement never actually changes.



Charles Wilt

--

Software Engineer

CINTAS Corporation - IT 92B

513.701.1307

wiltc@xxxxxxxxxx <mailto:wiltc@xxxxxxxxxx>




This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.