Pervasive PSQL System Stored Procedures

Table_ qualifier	Table_owner	Table_name	Column_name	Data_type	Type_name	P	L	S	R	N	R
'demodata'	Null	tx	C_binary	-2	Binary	10	10	Null	Null	1	Null
'demodata'	Null	tx	C_char	-1	Char	10	10	Null	Null	1	Null
'demodata'	Null	tx	C_tinyint	-6	Tinyint	Null	1	0	10	1	Null
.....
Legend: P = Precision; L = Length; S = Scale; R = Radix; N = Nullable; R = Remarks

Table_ qualifier	Table_owner	Table_name	Column_name	Data_type	Type_name	P	L	S	R	N	R
'wsrde'	Null	tx	C_binary	-2	Binary	10	10	Null	Null	1	Null
'wsrde'	Null	tx	C_char	-1	Char	10	10	Null	Null	1	Null
'wsrde'	Null	tx	C_tinyint	-6	Tinyint	Null	1	0	10	1	Null
.....
Legend: P = Precision; L = Length; S = Scale; R = Radix; N = Nullable; R = Remarks

Table_ qualifier	Table_owner	Table_name	Column_name	Data_type	Type_name	P	L	S	R	N	R
'wsrde'	Null	tx	C_binary	-2	Binary	10	10	Null	Null	1	Null
Legend: P = Precision; L = Length; S = Scale; R = Radix; N = Nullable; R = Remarks

Condition	Error Message
database_qualifier is a blank string	Please enter a valid database name. Database name cannot be a blank string.
database_qualifier is an undefined database	Unable to open table: X$File
table_name is undefined in the database	No error is returned and no results are returned
table_name is null	Table name cannot be null
table_name is a blank string	Table name cannot be a blank string
column_name is a blank string	Column name cannot be a blank string
column_name is undefined in the table	No error is returned and no results are returned

Table_ qualifier	Table_owner	Table_name	Column_name	Attrib_Type	Attrib_Size	Attrib_Value
'demodata'	Null	tx	C_binary	Default	2	01
'demodata'	Null	tx	C_char	Default	11	'Thisisatest'

Table_ qualifier	Table_owner	Table_name	Column_name	Attrib_Type	Attrib_Size	Attrib_Value
'demodata'	Null	tlogicalmv	col2	L	1	1
'demodata'	Null	tlogicalmv	col1	L	1	2

Table_ qualifier	Table_owner	Table_name	Column_name	Attrib_Type	Attrib_Size	Attrib_Value
'demodata'	Null	tx	C_binary	Default	2	01

Condition	Error Message
database_qualifier is a blank string	Please enter a valid database name. Database name cannot be a blank string.
database_qualifier is an undefined database	Unable to open table: X$File
table_name is undefined in the database	No error is returned and no results are returned
table_name is null	Table name cannot be null
table_name is a blank string	Table name cannot be a blank string
column_name is a blank string	Column name cannot be a blank string
column_name is undefined in the table	No error is returned and no results are returned

Table_Qualifier	Table_owner	User_name	Table_name	Column_name	Rights
Demodata	Null	John	Dept	Name	SELECT
Demodata	Null	John	Dept	Building_name	SELECT
Demodata	Null	John	Dept	Building_name	INSERT
Demodata	Null	Mary	Dept	Name	UPDATE

Table_Qualifier	Table_owner	User_name	Table_name	Column_name	Rights
Demodata	Null	John	Dept	Building_name	INSERT
Demodata	Null	John	Dept	Building_name	SELECT
Demodata	Null	John	Dept	Name	SELECT

Table_Qualifier	Table_owner	User_name	Table_name	Column_name	Rights
Demodata	Null	John	Dept	Name	SELECT

Table_Qualifier	Table_owner	User_name	Table_name	Column_name	Rights
Demodata	Null	Mary	Dept	Name	UPDATE

Condition	Error Message
database_qualifier is a blank string	Please enter a valid database name. Database name cannot be a blank string.
table_name is null	Table name cannot be null.
table_name is a blank string	Table name cannot be a blank string.
column_name is a blank string	Column name cannot be a blank string.
user_name is a blank string	User name cannot be a blank string.

PkQ	PkO	PkT	PkCol	Seq	FkQ	FkO	FkT	FkCol	UR	DR	PK	FK
Demodata	Null	Employee	Id	0	Demodata	Null	Employee	Supid	1	2	EmpPkey	ForgnKey
Legend: PkQ = Pkey_ table_ qualifier; PkO = Pkey_table_owner; PkT = Pktable_ name; PkCol = Pk_ column_ name; Seq = Key_seq; FkQ = Fktable_qualifier; FkO = Fktable_owner; FkT = Fktable_name; FkCol = Fkcolumn_name; UR = Update_rule; DR = Delete_rule; Pk = Pk_ name; FK = Fk_ name

Legend: PkQ = Pkey_ table_ qualifier; PkO = Pkey_table_owner; PkT = Pktable_ name; PkCol = Pk_ column_ name; Seq = Key_seq; FkQ = Fktable_qualifier; FkO = Fktable_owner; FkT = Fktable_name; FkCol = Fkcolumn_name; UR = Update_rule; DR = Delete_rule; Pk = Pk_ name; FK = Fk_ name

Condition	Error Message
table_qualifier is a blank string	Table name cannot be a blank string.
pKey_table_name is a blank string	Primary key table name cannot be a blank string.
pKey_table_name is null	No argument or default value supplied. Argument: 2.
fKey_table_name is a blank string	Foreign key table name cannot be a blank string.

Database_qualifier	Group_Id	Group_Name
Demodata	1	PUBLIC
Demodata	2	DevGrp1
Demodata	3	DevGrp2

Database_qualifier	Group_Id	Group_Name
Demodata	2	DevGrp1
Demodata	3	DevGrp2

Database_Qualifier	SP_TEXT
Demodata	Create procedure Myproc(:a integer, OUT :b integer) as Begin Set :a = :a + 10; Set :b = :a; End

Database_Qualifier	SP_TEXT
wsrde	Create procedure Myproc1(:a integer) returns (name char(20)) as Begin Select name from employee where Id =:a; End

Condition	Error Message
database_qualifier is a blank string or null	Please enter a valid database name. Database name cannot be a blank string
procedure_name is null	No argument or default value supplied.
procedure_name is a blank string	Procedure name cannot be a blank string.

Database_Qualifier	TRIGGER_TEXT
Demodata	CREATE TRIGGER MyInsert AFTER INSERT ON A FOR EACH ROW INSERT INTO B VALUES (NEW.col1, NEW.col2);

Database_Qualifier	UDF_TEXT
Demodata	Create function Myfunction(:a integer) Returns integer as Begin Return :a * :a; End

Database_Qualifier	VIEW_TEXT
Demodata	SELECT "T1" ."Last_Name" ,"T1" ."First_Name" ,"T1" ."Phone" FROM "Person" "T1"

Qual	TO	TN	IN	IT	CN	Opos	Dup	Up	Case	A/D	NI
Demodata	Null	Billing	Student_Trans	Normal Index	Student_ID	0	No	Yes	No	A	Yes
Demodata	Null	Billing	Student_Trans	Normal Index	Transaction_Number	1	No	Yes	No	A	Yes
Demodata	Null	Billing	Student_Trans	Normal Index	Log	2	No	Yes	No	A	Yes
.....
Legend: Qual = Table_ qualifier; TO = Table_owner; TN = Table_name; IN = Index_name; IT = Index_type; CN = Column_name; Opos = Ordinal_position; Dup = Duplicates_allowed; UP = Updatable; Case = Case_ sensitive; A/D = Asc_desc; NI = Named_index

Condition	Error Message
pkey_table_qualifier is a blank string	Please enter a valid database name. Database name cannot be a blank string.
table_name is null	No argument or default value supplied.
table_name is a blank string	Table name cannot be a blank string.

Procedure_Qualifier	Procedure_owner	User_name	Procedure_name	Rights
Demodata	Null	John	Dept1_Proc	ALTER
Demodata	Null	John	Dept1_Proc	EXECUTE

Qualifier1	Owner1	Name1	Type1	Num_input_params	Num_output_params	Num_result_sets	Remarks	Trustee
mydbase	Null	Myproc1	Stored Procedure	Null	Null	Null	Null
mydbase	Null	Myproc2	Stored Procedure	Null	Null	Null	Null
1The complete column name includes “procedure_” prepended to this name: Procedure_qualifier, procedure_owner, and so forth.

Trigger_qualifier	Trigger_owner	Table_name	Trigger_name	isupdate	isdelete	isinsert	isafter	isbefore	Remarks
mydbase	Null	A	Insert	0	0	1	0	0	Null

UDF_ qualifier	UDF_owner	UDF_name	Udf_type	Num_ input_params	Num_ output_params	Num_result_sets	Remarks
mydbase	Null	CalcInterest	1	Null	1	0	Null
mydbase	Null	Factorial	1	Null	1	0	Null

View_Qualifier	View_owner	User_name	View_name	Rights
Demodata	Null	John	vw_Dept	ALTER
Demodata	Null	John	vw_Dept	DELETE
Demodata	Null	John	vw_Dept	SELECT