Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 5 Procedures : proc_version

proc_version
The proc_version table holds information that is specific to a version of a procedure (or sub-procedure or sub-procedure parameter template).
Structure
The proc_version table has the following structure:
TABLE proc_version(
node_id
number(5) NOT NULL,
proc_id number(5) NOT NULL,
major_vers number(5) NOT NULL,
minor_vers number(5) NOT NULL,
pd_version number(7) ,
pv_status number(2) ,
pv_user varchar2(49) ,
pv_comment varchar2(128) NULL,
pv_created date ,
pv_modified date ,
pv_released date ,
pv_withdrawn date ,
pv_is_subproc number(1) )
Status of this version. Either: Released (0), Incomplete (1), Unreleased (2), Model (3) or Withdrawn (14).
Flag that defines whether (1) or not (0) this version is a sub-procedure.
Primary Key
The following primary key is defined for this table.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following index is defined for this table.
Storage
The following STORAGE values are defined for this table.
Table Activity
The proc_version table contains one row for every version of every procedure (or sub-procedure or sub-procedure parameter template) defined on the system.
Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.