Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 5 Procedures : proc_defn

proc_defn
The proc_defn table holds procedure definitions.
Structure
The proc_defn table has the following structure:
TABLE proc_defn (
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
pd_version
INTEGER NOT NULL,
pd_type INTEGER NOT NULL,
pd_index INTEGER NOT NULL,
pd_size INTEGER NOT NULL,
pd_directory VARCHAR(25) NOT NULL,
pd_file VARCHAR(25) NOT NULL,
pd_data IMAGE NOT NULL)
0  pro data (textual procedure definition)
1  lst data (binary procedure definition)
2  nod data (not used)
3  gwd data (iProcess Modeler layout information)
4  nod data (not used)
5  VBA project data (VBA project files)
If pd_type is 5, contains the sub-directory path (relative to SWDIR\projects) where any VBA project files related to this procedure definition are stored. Filenames are stored in pd_file.
If pd_type is 0 to 4, this field contains a hyphen.
If pd_type is 5, contains the filename of a VBA project file related to this procedure definition (if there is one). The file is physically stored in the location defined by pd_directory.
If pd_type is 0 to 4, this field contains a hyphen.
Primary Key
The following primary key is defined for this table.
Triggers
None.
Indexes
The following index is defined for this table.
Table Activity
The proc_defn table contains one or more rows for each instance of each procedure definition 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