Page 1 of 1

Informix warning

Posted: Tue Nov 08, 2005 12:24 am
by mchaves
Hi there,

I am getting a warning from informix every time I run a ds job. It's not causing the job to fail but I'd like to see if anyone has ever seen this before and resolved.

This is the waring :

BadDebt..Informix_CLI_1: This data source does not support transactions.


The job has a odbc connection to informix and just executes a query and dumps the data into a file. It doesn't do any update, insert or delete.

Any help will be appreciated.

Cheers,

Posted: Tue Nov 08, 2005 5:06 am
by ray.wurlod
Use a database that does support transaction logging. This is a standard message from Informix when you use a database created with -nologging option.

DataStage's philosophy is to log all messages from the database, on the grounds that the database vendor thought it important enough to inform you, so DataStage should not be arrogant enough to deny you access to that knowledge.

Posted: Tue Nov 08, 2005 9:09 pm
by mchaves
Thanks Ray.