NZ sql script calling

vamsi.4a6 · Post by **vamsi.4a6** » Fri Jan 02, 2015 3:55 am

I am new to netezza and i have one sql file consists of following statements which we are calling from NZ connector[Read from sql option]

Insert statement1

Update statement1

Updatestatement2

I want all 3 sql statments should be success and if any sql statement is failed i want to rollback all the sql staments that are executed succesfully

chulett · Post by **chulett** » Fri Jan 02, 2015 9:10 am

Check the documentation - I believe that separating them with a single semi-colon makes them individual transactions while 'double semi-colons' means all as one transaction.

vamsi.4a6 · Post by **vamsi.4a6** » Mon Jan 05, 2015 4:21 am

I believe following settings are sufficient to handle my scenario after reading the documentation and please correct me if i am wrong?

Fail on error=YES

if you specify Fail on error as Yes, all statements are executed as one transaction. If one fails, the statements already executed rolls back and the rest are not executed.

Atomic mode=YES
This property is activated when you specify Fail on error as Yes. The default value for Atomic Mode is Yes and all statements are executed in one transaction.

chulett · Post by **chulett** » Mon Jan 05, 2015 8:41 am

Let us know.

vamsi.4a6 · Post by **vamsi.4a6** » Tue Apr 07, 2015 3:28 am

Kindly let me know whether my undersanding is correct or not?

ray.wurlod · Post by **ray.wurlod** » Tue Apr 07, 2015 3:57 am

Better idea. Why don't you press the Help button when these properties are selected, learn what the possible values are and the effects of each, and report back with your findings?

chulett · Post by **chulett** » Tue Apr 07, 2015 6:44 am

I was assuming you'd be testing your understanding then letting us know if they were indeed correct or not.