Guest.Visitor
01-01-1995, 02:00 AM
We are running our intranet on NT and in a web page are retrieving 400 data and updating 400 files. We are issuing SQL inserts from an NT server to update files on the AS400. This uses ODBC. 2 issues: 1 - even though we have *USRLIBL set up as the libraries to search under the ODBC setup on the NT Server, we still have to explicitly name the libraries on either a select or insert statement. 2 - when the ODBC job enters the as400 it starts job qzdasoinit under sbs qserver. This job sits in a SELW state for about 20-25 seconds before the job executes. We have tried changing the time slice and wait parameters, but that does not seem to have an impact. Any ideas on how to speed up that response time when using odbc to issue sql calls? Thanks very much. Ann Richmond