User defined Error Messages

[scarletAni]

Hi !!
Is there any way of raising a user defined exception in Teradata ?
I need one and am not able to find relevant material.
Can someone help ?

 

[dnoeth]

The only way i'm aware of is

ROLLBACK 'An error occured' WHERE any_condition;

which results in error 3513 with errortext 'An error occured'

Dieter

 

[scarletAni]

Can we use ABORT 'Error Occurred'. Will it shange the value of SQLCODE ?

 

[scarletAni]

Also how can we check the value 3513 has been assigned to SQLCODE ?

 

[dnoeth]

ABORT is exactly the same as ROLLBACK.

I never tried it within a Stored Procedure (outside of an exception handler), but checked it now:
ABORT sets SQLCODE to 0 and SQLSTATE to '00000', succesfull completion...

Dieter

 

[scarletAni]

So, ABORT may not work for me. I must try ROLLBACK. How do I check the SQLCODE value once the procedure is complete ?

 

[dnoeth]

ABORT is a synonym for ROLLBACK.
And SQLCODE/SQLSTATE is only available within a SP and even within it can't be used to check for ABORT, because it's no error :-(