Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DG4ODBC and the AS400 ODBC (HS_FDS_FETCH_ROWS parameter)

dscheingoldNov 12 2012 — edited Nov 15 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2012
Added on Nov 12 2012
3 comments
758 views