|
From: Vincent M. V. <VVi...@so...> - 2011-05-16 16:31:09
|
Hi Rob, Thanks for the reply. I tried your suggestion, I changed the fetch size to 2,000 and it still cut off at 1,000 records. Do you think it could be the driver that I am using? Currently I am using an evaluation version of the HXTT Access v5.0 driver (Access JDBC 4.0 Package). Is there another driver you would recommend using for Access 2007? If you have any questions, please contact me. Thank you, Vincent Visconti Database Analyst/Programmer Sound Recording Special Payments Fund 570 Lexington Avenue, 21st Floor New York, NY 10022-6837 Phone: 212-310-9429 e-mail: vvi...@so...<mailto:vvi...@so...> From: Robert Manning [mailto:rob...@gm...] Sent: Friday, May 13, 2011 8:31 PM To: Vincent M. Visconti Cc: squ...@li... Subject: Re: [Squirrel-sql-users] DBCopy problem Hmmm, it seems a bit too coincidental that the default select batch size for the DBCopy plugin is 1000, and that is also the maximum number of records retrieved by the HXTT driver to be copied. How about if you try this: Open File -> Global Preferences -> DBCopy - and change "ResultSet fetch size" to say 2000 and try the copy operation again (first, remove the records from the destination database table). If that manages to somehow copy 2000 records this time, then I would say that the driver is limiting the total number of records in the result set based on the fetch size. In which case, you could then try increasing that setting to a number above the total number of records to be copied. Rob On Fri, May 13, 2011 at 11:30 AM, Vincent M. Visconti <VVi...@so...<mailto:VVi...@so...>> wrote: Hi, I'm trying to copy tables from Access 2007 into DB2 for i5/OS. I'm connecting to the Access DB via HXTT Access Client driver and the i5 via the JTOpen(AS/400) driver. The problem is when I copy a table from Access to i5, it only copies 1,000 records. I get a message that the copy was successful, but it only copies the 1st 1,000 records. I tried changing around some settings, but nothing seems to help. Any suggestions? Thank you! If you have any questions, please contact me. Thank you, Vincent Visconti Database Analyst/Programmer Sound Recording Special Payments Fund 570 Lexington Avenue, 21st Floor New York, NY 10022-6837 Phone: 212-310-9429<tel:212-310-9429> e-mail: vvi...@so...<mailto:vvi...@so...> ------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Squirrel-sql-users mailing list Squ...@li...<mailto:Squ...@li...> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ |
