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
INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
major_vers SMALLINT NOT NULL,
minor_vers SMALLINT NOT NULL,
pd_version INTEGER NULL,
pv_status SMALLINT NULL,
pv_user VARCHAR(49) NULL,
pv_comment VARCHAR(128) NULL,
pv_created DATETIME NULL,
pv_modified DATETIME NULL,
pv_released DATETIME NULL,
pv_withdrawn DATETIME NULL,
pv_is_subproc SMALLINT NULL)
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.
Triggers
None.
Indexes
None.
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