scenario: i have form where users will input the empno, after providing the empno, the user will click on a button that connects to AS/400 using ODBC (lsxodbc and lotusscript) and will get specific record from a table (contains 140K records), however the retrieal time takes about 2 minutes, but if use client access (SQL query) it only takes about 15 seconds to access a specific record.
do you have any alternative way instead of using ODBC?
what’s the difference between LEI and DECS?
thanks
Subject: Accessing DB2 database in AS/400
Not that I know anything about it, but have you read the Admin help about the DB2 connector? That seems to be what you’d be looking for. Also, it appears to have settings that would affect how it works, such as being restricted to single threading (which would probably slow it down, and you wouldn’t want to use if your system is capable of multithreaded execution.)
Subject: Accessing DB2 database in AS/400
You can take a look at lotus connectors. Search the help for “LC LSX”. With LC you can use the native drivers - but the db2 client has to be set up on the clients. Alternatively you can put the db2 client on the domino server and when performing the query just run an agent on the domino server and put the result into a temporary document, or something like that. Can be quite fast as the server pools the connections so alot of time is saved there.LEI is basicly an extention to DECS. DECS can be installed when installing the Domino server. To use LC you do not need LEI.