Archives of the TeradataForum

Message Posted: Wed, 18 Aug 2010 @ 07:53:33 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: .IF ..THEN statement

From:		Alves, Patrick

Hi,

.quit will return to the OS (unix/ windows) the error code send by bteq ( 0 : no errors , 4 :warning, 8 , 12, etc. look into bteq documentation to get details).

.quit 0 will force to return 0 to the OS even if there were errors during script execution

.qui 99 will return errorcode 99 to the OS

you can put different code after .quit and treat this code in a O/S script ( .sh for exemple) . if activytycount ==> number of rows returned by the sql_statement .if errorcode ==> if there was an error or warning during execution of the sql statement. So these two statement are different.

Regards.

Patrick
TD Consultant.