|
From: Robert M. <rob...@gm...> - 2011-05-14 00:30:54
|
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...> 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 > e-mail: 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... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
