Display Format - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantage™

If an external stored procedure returns an SQLSTATE value other than success, a BTEQ session displays an error.

IF the SQLSTATE category is … THEN the display format is …
warning
*** Warning: 7505 in UDF/XSP dbname.xspname: SQLSTATE 01H xx:
 <text>
where:
  • 7505 is the Teradata designated warning code for user-defined functions, user-defined methods, and external stored procedures
  • dbname.xspname is the name of the external stored procedure and the name of the database in which the stored procedure resides
  • 01H xx is the value that the external stored procedure sets the SQLSTATE output argument to, according to values for the warning category in the table in SQLSTATE Values.
  • <text> is the value of the error message output argument, if the external stored procedure uses parameter style SQL
not a warning
*** Failure 7504 in UDF/XSP  dbname.xspname: SQLSTATE  ccsss:
 <text>
where:
  • 7504 is the Teradata designated error code for user-defined functions, user-defined methods, and external stored procedures
  • dbname.xspname is the name of the external stored procedure and the name of the database in which the stored procedure resides
  • ccsss is the value that the external stored procedure sets the SQLSTATE output argument to, according to the table in SQLSTATE Values.
  • <text> is the value of the error message output argument, if the external stored procedure uses parameter style SQL