Pervasive logo

Prev SQL Engine Reference Next

X$Proc


The X$Proc system table is associated with the file PROC.DDF. X$Proc contains the compiled structure information for every stored procedure defined. The structure of X$Proc is as follows:

 
Table C-13 X$Proc System Table Structure

Column Name
Type
Size
Case Insensitive
Description
Xp$Name
CHAR
30
Yes
Stored procedure name.
Xp$Ver
UTINYINT
1
N/A
Version ID.
Xp$Id
USMALLINT
2
N/A
0-based Sequence Number.
Xp$Flags
UTINYINT
1
N/A
1 for stored statement, 2 for stored procedure or 3 for external procedure.
Xp$Misc
LONGVARCHAR
(LVAR)
<=990
N/A
Internal representation of stored procedure.


Note
Stored procedures and external procedures were supported in versions prior versions of Pervasive.SQL. Only stored procedures are supported in Pervasive.SQL V8.

One index is defined for the X$Proc table, as follows:

 
Table C-14 X$Proc System Table Index Definitions

Index Number
Segment Number
Column Name
Duplicates
Case Insensitive
Segmented
0
0
Xp$Name
No
Yes
Yes
0
1
Xp$Id
No
N/A
No

Index Number corresponds to the value stored in the Xi$Number column in the X$Index system table. Segment Number corresponds to the value stored in the Xi$Part column in the X$Index system table.


Prev
X$View
Contents
Up
Check for Revisions
Next
X$User