DG4ODBC and the AS400 ODBC (HS_FDS_FETCH_ROWS parameter)
I am trying to figure out what is the optimal setting for ODBC connection to an DB2/AS400 server
In order to get the AS400 to return correct records i have to set HS_FDS_FETCH_ROWS to 1
If i set it to anything other than 1 , the results returned are incorrect (some rows are skipped or some fields are blank/null)
This is causing some lag when compared to ODBC connectivity from MS access. Any pointers in the right direction will be greatly appreciated. Thank you
These are my current parameters
HS_FDS_CONNECT_INFO = AS400
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so.2.0.0
HS_FDS_SUPPORT_STATISTICS=TRUE
HS_FDS_TRACE_LEVEL = 99
HS_FDS_TRACE_FILE_NAME = /u01/as400.log
HS_FDS_FETCH_ROWS = 1
HS_RPC_FETCH_SIZE = 6000
HS_RPC_FETCH_REBLOCKING = ON
HS_ROWID_CACHE_SIZE = 3
set ODBCINSTINI=/etc/odbcinst.ini
set ODBCINI=/etc/odbc.ini