Consider the following external stored procedure C function:
void xsp_getregion( VARCHAR_LATIN *region,
char sqlstate[6])
{
...
}
You can use the sqlstate argument to return the SQLSTATE result code value.
For example, if the value of the region argument is not a valid value, you can set the value of the sqlstate argument to return a data exception:
strcpy(sqlstate, "U0005");
In a BTEQ session, the exception condition appears in the following format, where dbname is the name of the database of the external stored procedure:
*** Failure 7504 in UDF/XSP dbname.xsp_getregion: SQLSTATE U0005: