Answer Detail: RE: what is the effect of the OPTIONS statement ERRORS=1

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Print |

Question: what is the effect of the OPTIONS statement ERRORS=1

December 12, 2007 13:48:28	#1
komalahanumantharao	Member Since: November 2007 Total Comments: 11
RE: what is the effect of the OPTIONS statement ERRORS=1
Stop on errors=1 (if you set this option to 1 the session will be stopped after occurance of 1 error row. if it is 0 theÂ session will not be stopped even u got n number of errors.