Warnings signal, that some operation was executed under unusual conditions. Warning is not an error and doesn't cause transaction rollbacks - the operation can be considered succesful. The Sz_warning function returns the warning number. Warnings can be traced - (TRACE_USER_WARNING situation).
The following table lists warning names, number returned by the Sz_warning function and warning description.
||no error and warning
||execution of a transaction from a client was done inside another transaction (the same situation raises an exception in SQL)
||termination of a transaction from a client was done outside a transaction
||integrity constraint on a table is incorrect
||record cannot be restored because it's not deleted
||default column value incorrect
||working with deleted (but not yet dropped) record
||object must be renamed in its definition too
||record cannot be deleted because it's not valid (has already been deleted)
||an error occurred, warning is not signalled