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.