Archives of the TeradataForum

Message Posted: Mon, 01 Nov 2004 @ 15:49:59 GMT

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

The first part of if/then/else statement is possible in TD. Please check the manuals for BTEQ for further syntaxes.

You might not be able to capture the out parameter of a sp in a local variable of a BTEQ script.

For SQL STATE like 23505 you will have to map the states to error codes either via a table or on the run in the sp. The mappings are available in Volume 6 DML, Appendix D.

Thanks.

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