i use C++ to connect DB.
after using ontape -N db,
there is no problem to create proc, and disable triggers ect.
but when i try to execute the proc,i always get 256 error code?

finderr 256
-256 Transaction not available.

You cannot begin a transaction in this database because it does not
have a transaction log. In order to support transactions, you must
start a transaction log. Refer to your Administrator's Guide for
information on how to start a transaction log.



is it normal error message?
how to avoid it?

thanks in advance.

Yes ontape -N dbname turns off logging to start a transaction begin work commit etc you need to have loggin set to either Buffered or unbuffered loggin ontape -U or ontape -B

ontape -N DB1 -B DB1

if i use command above,

Database 'DB1' - Logging status updated.
Database 'DB1' - Logging status updated.

Program over.


what's that meaning? unbuffer first, then buffer again?

Can I use -N and -B , -U at same time?

what kind of command i can check the DB in exactly which status concern the log?

Thanks in advance.

Problem solved, in the procedure, there is begin work, which open transaction, i remove this begin work, it is ok now.

There ya go when setting the loggin only use one option in the future -U = Unbuffered -N = No Logging (which by the way is unsafe if there is ever a crash) the -B if for buffered logging