Page 1 of 1

Unsupport transactions from source problem

Posted: Wed Aug 30, 2006 2:00 am
by chowmunyee
Hi,

Usually im using odbc as a database in server job. Due to my data is very high (11 millions data) then i'm changing the odbc by using informix CLI(source) and target would be Informix Load (target) but Im getting this warning while i'm validating my job all the time.

This is the error i get :
TestLoad_test3table..Informix_CLI_16: This data source does not support transactions.

The Informix version is 9.30

What is mean of this error? but when i run it....but it does not abort the job....

Please advice

thank you

Posted: Wed Aug 30, 2006 3:08 am
by ray.wurlod
Please post in appropriate forum.

Your Informix database was created "with no logging". Therefore it will not accept COMMIT statements sent by DataStage.