I have a graph that tries to add records in a table where the columns are not null. Null value makes it fail but not null records already got inserted. I don't want that.
I would like to have a graph that checks the existence of the values and if there is at least one null value is there, the graph should stop. I don't want to create a table to have not null constraint and have the table spit out error message. I would like to use ctl2 to cause the graph fail based on the null value. Can you please help me figure out which return code actually makes a graph fail?
I would like to have a graph that checks the existence of the values and if there is at least one null value is there, the graph should stop. I don't want to create a table to have not null constraint and have the table spit out error message. I would like to use ctl2 to cause the graph fail based on the null value. Can you please help me figure out which return code actually makes a graph fail?
-
Hi kasturi,
"void raiseError(string message)" will stop engine.
http://doc.cloveretl.com/documentation/ ... -ctl2.html -
Thanks. It worked .
Please sign in to leave a comment.
Comments 2