The IN_DB_UTIL_SP_SCHEMA_GET_HIST stored procedure will fetch the INUSER schema history from the IN_PRODUCT_MOD_HIST table.
| Parameter | Description | |
|---|---|---|
| MODE | Type: | INPUT |
| Datatype: | TINYINT | |
| Default Value: | 3 | |
| Description | Specifies whether to display the procedure name during execution. | |
| Options |
1 = Results are selected to the Results grid only. 2 = Results are selected to the Results grid and printed in the Message Tab. 3 = Results are printed in the Message Tab only. |
|
| DEBUG | Type: | RETURN |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display the procedure name during execution. | |
| Options |
YES NO |
|
| V_RETURN_VAL | Type: | OUTPUT |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description |
Specifies whether the execution of the procedure was successful or not. 0 = Success 1 = Error |
|
Example
EXEC IN_SCHEMA_GET_HIST 1; EXEC IN_SCHEMA_GET_HIST 2; EXEC IN_SCHEMA_GET_HIST 3;