A scenario like ,there is a BTEQ where it has delete statement followed by an insert and update.Suppose the delete statement has been executed successfully and there occurs an error during insert. So in this scenario it should exit the BTEQ and the table should get the previously loaded value which was present before Delete.(handling rollback in Bteqs)
Answer
The Delete and the Insert statements should be written within the BT and ET statemants and rollback should be given before end transaction. if insert fails then it should go to the rollback step. This works only in teradata mode and not in ANSI (please confirm the ans for this question before consolidation)
Answer
The Delete and the Insert statements should be written within the BT and ET statemants and rollback should be given before end transaction. if insert fails then it should go to the rollback step. This works only in teradata mode and not in ANSI (please confirm the ans for this question before consolidation)
1 comments:
For Hadoop Tutorials visit http://hadooptutorialsonline.blogspot.in/
ReplyPost a Comment