Teradata: How can I raise an error in a stored pro

问题:

Is there a way to raise errors inside of Teradata stored procedures?

For example, I want to check if a table is empty. If the table is empty I wish to cause the stored procedure to error out with the error message "Table Empty".

That will allow me to bubble up the error to the calling application.

回答1:

TD13+ implements Standard SQL's SIGNAL/RESIGNAL.