The procedure you are viewing may be nested in a batch of SQL text. To aid in the viewing of nested procedure, new columns have been added to the sysprocesses table to specify the object ID, current statement number and line number of the current statement of the procedure that is currently running.
Table 5-14 shows the new columns added to the sysprocesses table.
Column Name |
Datatype |
Specifies |
|---|---|---|
id |
integer |
The object ID of the running procedure; if 0, no procedure is running. |
linenum |
integer |
The line number of the current statement within the running stored procedure, or the line number of the current SQL batch statement, if no procedure is running. |
stmtnum |
integer |
The current statement number within the running procedure, or the SQL batch statement number, if no procedure is running. |
For more information, see “Configuring Adaptive Server to Save SQL Batch Text” on page 4-17 of the System Administration Guide.
