Unsupport transactions from source problem

chowmunyee · Post by **chowmunyee** » Wed Aug 30, 2006 2:00 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Aug 30, 2006 3:08 am

Please post in appropriate forum.

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