Informix warning

mchaves · Post by **mchaves** » Tue Nov 08, 2005 12:24 am

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,

ray.wurlod · Post by **ray.wurlod** » Tue Nov 08, 2005 5:06 am

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.

mchaves · Post by **mchaves** » Tue Nov 08, 2005 9:09 pm

Thanks Ray.