"JimHeavey" wrote:

> I have written a program which looping through a bunch of records and then
> reads a particular row on  a DB2 table.  When the 1326 record is processed, I
> get a DB2 error when I attempt to get a Data Reader Object.  The error
> message I get is as follows: "[DB2] SQL0805N  Package
> "DB2U.NULLID.SYSLH203.5359534C564C3031" was not found. 
> SQLSTATE=51002<br>Called from Module: DataTableUtilities  Method:
> GetDataReader"
>
> Researching this I found information that says it can occur if you do not
> explicitly close "your statement object".  I take this to mean the Command
> object, but I find no "close" method for command, I did however find a
> "Dispose()" method.  So I issued this command after I closed the DataReader,
> but still I get this same error after 1325 records.
>
> I closed the Connection object and re-opened a new connection and this
> provides me with an additional 1325 "read" before I abend with the same error
> message.
>
> What exactly am I doing wrong?  I could close and re-open my connection
> object after 1320 reads as a work around, but this does not sound right.
>
> Any ideas?
>
> Thanks in advance for your assistance....