i use ODBC and lotusscript to connect to a DB2 database that resides in AS/400, when retrieving values (i.e. empno) on the DB2 database, i notice that it takes too long (about 2-3 minutes) to retrieve the empno. the total no of records that is stored in the db2 database is more than 147K. do you have any other options that is much faster than using ODBC?
thanks in advance