This is my file at the moment,, Informix database

dbsinit:01
inf_init:0421
lock_retry:0
infenv_lock_timeout:5
bdb_max_session_schedule:3
inf_fetarrsize:0
ssts_set_rows:3
cursor_refresh:30



I need to add fetch and insert rows, can someone help me with the syntax????

Can u please elabotrate what databse u r using, because
db-resource file is having different setup for INFORMIX and ORACLE. I can give u the specific setup based on database u r using.



Thanks

Alam Badre

database is INformix

Hi,

the setting which is required for INFORMIX db_resource file :

************************
dbsinit:01
inf_fetarrsize:0
bdb_max_session_schedule:3
inf_init:0621
lock_retry:"0"
infenv_lock_timeout:30
pdqpriority:100
*************************


In addition to the default resource file, db_resource, it is possible to set up an alternative resource file to override resource values for specific users or groups of users. The alternative resource file is specified with the environment variables USR_DBS_RES and USR_DBC_RES. USR_DBS_RES is used to specify the path to a file containing an alternative resource file for the server and must be set on the machine running the database driver. USR_DBC_RES is used to specify the path to a file containing an alternative resource file for the client and must be set on the machine running the application virtual machine. Any driver resource
set in the alternative resource file will override the setting of the same driver resource in db_resource.



Here, I am attaching a docs Chapt. 8 of which describes settings of all the INFORMIX driver related resource parameters which can be very helpful to you.


Thanks



Alam Badre

Got the documant , thanks a lot is it the same for Baan IVc4??

I am specifically interested in fetch and insert optimization.

yes, Matt.

it is same for the BaaN IV C4 also.



Thanks

Alam Badre