Hello,

Is there any way (method) to get about whether LOG mode is created or not for informix database using JDBC.

Ex: I may create either

create database myLogDB with LOG MODE ANSI
[OR]
create database myNoLogDB

Is there any method (or way) in JDBC to retreive information (True or False) on LOG MODE in the above cases.

Thanks in advance
Sreedhar

Hi,

You could try the following:

select * from sysmaster:sysdatabases

Of course filter on the database name and select the right columns. But if you look in this table then it will explain itself (I hope)