Hi Friends,
I have installed informix IDS9.21 FC7 on Hp -UX machine.
but when i try to access tables from database, i am able to work
very proper through dbaccess, but not through isql.
i am gettting this error.

$isql system

set isolation dirty read;
select * from iivnd


the error is :
256: Transaction not available.

please advise/suggest me to fix this problem.


thanks

Sundar

In order to have transactions (ie Begin...Commit) you must turn on logging for a given database.

Hi Friends,
I am new to informix. I have installed and created databases , but
this problem i have been getting since last three days.
please tell me the command to turn on logging on the database.

thanks

sundar

Hi,

Use ontape command for changing the logging mode like
ontape -s -L 0 -A or -B db_name

-A : set the following database(s) to ansi logging
-B : set the following database(s) to buffered logging

Bye