Hello,
when using the scalar function RAISE_ERROR to cause an error when executing an SQL statement, what would be the considerations for choosing the value for the first parameter SQLSTATE?
The IBM documentation says that it must be a 5-character value containing only characters in ranges 0-9 or A-Z and the first two characters cannot be 00, 01 or 02, but are there any other rules or conventions to follow or is the choice completely arbitrary?
Thanks in advance.
when using the scalar function RAISE_ERROR to cause an error when executing an SQL statement, what would be the considerations for choosing the value for the first parameter SQLSTATE?
The IBM documentation says that it must be a 5-character value containing only characters in ranges 0-9 or A-Z and the first two characters cannot be 00, 01 or 02, but are there any other rules or conventions to follow or is the choice completely arbitrary?
Thanks in advance.
Comment