The IN_DB_UTIL_SP_CALLSTACK_TRIM stored procedure is responsible for decrementing the call stack depth for the specified identifier(s) when the IN_DB_UTIL_SP_CLEAR_IDENTIFIER procedure is executed during session tear down.
The IN_DB_UTIL_SP_CALLSTACK_TRIM procedure should never need to be manually executed.
The call stack for each identifier is stored in the IN_DB_UTIL_CALLSTACK table.
| Parameter | Description | |
|---|---|---|
| IDENTIFIER | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | Specifies the identifier for which to extend the call stack. | |
| Options |
IN_DB_UTIL SYNC UPGRADE ALL (SYNC and UPGRADE) |
|
| DEBUG | Type: | INPUT |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display the procedure name during execution. | |
| Options | YES NO |
|
| V_RETURN_VAL | Type: | RETURN |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description | Specifies whether the execution of the procedure was successful or not. 0 = SUCCESS 1 = ERROR |
|
Example
EXEC INUSER.IN_DB_UTIL_SP_CALLSTACK_TRIM @V_IDENTIFIER;