Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of database from which to obtain details |
table_name | VARCHAR(255) | (no default value) | Name of table whose column information is required |
column_name | VARCHAR(255) | All columns for the table | Column name of the table specified |
Column Name | Data Type | Description |
---|---|---|
TABLE_QUALIFIER | VARCHAR (20) | Name of the database |
TABLE_OWNER | VARCHAR (20) | Name of the table owner. Table owner is reserved for future use. It currently returns empty (NULL). |
TABLE_NAME | VARCHAR(255) | Name of the table |
COLUMN_NAME | VARCHAR(255) | Column name of the table |
DATA_TYPE | SMALLINT | Data type code of the column. See Zen Transactional and Relational Data Types. |
TYPE_NAME | VARCHAR (32) | Name of the data type of the column corresponding to DATA_TYPE value |
PRECISION | INTEGER | The precision of the column if the data type is Decimal, Numeric, and so forth. See Precision and Scale of Decimal Data Types. |
LENGTH | INTEGER | The length of the column. |
SCALE | SMALLINT | The scale of the column if the data type is Decimal, Numeric, and so forth. |
RADIX | SMALLINT | Base for numeric data types |
NULLABLE | SMALLINT | Specifies nullability: 1 - NULL allowed 0 - NULL not allowed |
REMARKS | VARCHAR(255) | Remarks field |
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 |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database you are logged in | Name of the database from which the details are to be obtained |
table_name | VARCHAR(255) | All tables for the specified database | Name of the table whose column information is required |
column_name | VARCHAR(255) | All columns for the specified table | Column name of the table specified |
Column Name | Data Type | Description |
---|---|---|
TABLE_QUALIFIER | VARCHAR (20) | Name of the database |
TABLE_OWNER | VARCHAR (20) | Name of the table owner |
TABLE_NAME | VARCHAR(255) | Name of the table |
COLUMN_NAME | VARCHAR(255) | Column name of the table |
ATTRIB_TYPE | CHAR(10) | "Default" if a default value has been assigned to the column "Collate" if the column uses a collating sequence "L" if the column has a logical positioning Null or blank for all other types of attributes |
ATTRIB_SIZE | USMALLINT | Size of the column attribute |
ATTRIB_VALUE | LONGVARCHAR | Value of the column attribute |
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 |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
table_name | VARCHAR(255) | (no default value) | Name of the table for which rights have been specified |
column_name | VARCHAR(255) | All columns of the specified table | Name of the column whose rights are to be obtained |
user_name | VARCHAR(255) | Current user | Name of the user for whom the list of column rights need to be obtained. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
TABLE_QUALIFIER | VARCHAR (20) | Name of the database |
TABLE_OWNER | VARCHAR (20) | Name of the owner of the table |
USER_NAME (GRANTEE) | VARCHAR(255) | Name of the user |
TABLE_NAME | VARCHAR(255) | Name of the table |
COLUMN_NAME | VARCHAR(255) | Name of the column for which the different rights have been granted |
RIGHTS | VARCHAR(12) | One of the following values: SELECT UPDATE INSERT |
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. |
Parameter | Type | Default Value | Description |
---|---|---|---|
table_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
pkey_table_name | VARCHAR(255) | (no default value) | Name of the table whose foreign key is associated with the primary key column |
fkey_table_name | VARCHAR(255) | (no default value) | Name of the table whose foreign key information needs to be obtained |
Column Name | Data Type | Description |
---|---|---|
PKTABLE_QUALIFIER | VARCHAR (20) | Database name of the primary key table |
PKTABLE_OWNER | VARCHAR (20) | Name of the owner of the primary key table |
PKTABLE_NAME | VARCHAR(255) | Name of the primary key table |
PKCOLUMN_NAME | VARCHAR(255) | Column name of the primary key column. |
KEY_SEQ | USMALLINT | Sequence of Keys. The value of this column corresponds to Xi$Part in X$Index. See X$Index. |
FKTABLE_QUALIFIER | VARCHAR (20) | Database name of the foreign key table |
FKTABLE_OWNER | VARCHAR (20) | Name of the owner of the foreign key table |
FKTABLE_NAME | VARCHAR(255) | Name of the foreign key table |
FKCOLUMN_NAME | VARCHAR(255) | Column name of the foreign key column. |
UPDATE_RULE | Utinyint | Update Rule |
DELETE_RULE | Utinyint | Delete Rule |
PK_NAME | VARCHAR(255) | Name of the primary key |
FK_NAME | VARCHAR(255) | Name of the foreign key |
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 |
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. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
group_name | VARCHAR(255) | (no default value) | Name of the group used to return group information. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
DATABASE_QUALIFIER | VARCHAR (20) | Name of the database |
GROUP_ID | USMALLINT | Group Id |
GROUP_NAME | VARCHAR (255) | Name of the group |
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 |
Condition | Error Message |
---|---|
database_qualifier is a blank string | Please enter a valid database name. Database name cannot be a blank string. |
group_name is a blank string | Group name cannot be a blank string. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
procedure_name | CHAR(255) | (no default value) | Name of the procedure whose definition text is required. Pattern matching is not supported. |
Column Name | Data Type | Description |
---|---|---|
DATABASE_QUALIFIER | VARCHAR (20) | Name of the database |
SP_TEXT | LONGVARCHAR | Stored procedure definition text |
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. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
trigger_name | VARCHAR(255) | (no default value) | Name of the trigger whose definition text is to be returned. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
DATABASE_QUALIFIER | VARCHAR (20) | Name of the database |
TRIGGER_TEXT | LONGVARCHAR | Trigger definition text. |
Database_Qualifier | TRIGGER_TEXT |
---|---|
Demodata | CREATE TRIGGER MyInsert AFTER INSERT ON A FOR EACH ROW INSERT INTO B VALUES (NEW.col1, NEW.col2); |
Condition | Error Message |
---|---|
database_qualifier is a blank string | Please enter a valid database name. Database name cannot be a blank string |
trigger_name is null | No argument or default value supplied. |
trigger_name is a blank string | Trigger name cannot be a blank string. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qual | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
udf_name | VARCHAR(255) | (no default value) | Name of the user-defined function whose function text is required. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
DATABASE_QUALIFIER | VARCHAR (20) | Name of the database |
UDF_TEXT | LONGVARCHAR | The text of the User Defined Function |
Database_Qualifier | UDF_TEXT |
---|---|
Demodata | Create function Myfunction(:a integer) Returns integer as Begin Return :a * :a; End |
Database_Qualifier | UDF_TEXT |
---|---|
wsrde | CREATE FUNCTION GetSmallest(:A integer, :B Integer) RETURNS Integer AS BEGIN DECLARE :smallest INTEGER IF (:A < :B ) THEN SET :smallest = :A; ELSE SET :smallest = :B; END IF; RETURN :smallest; END |
Condition | Error Message |
---|---|
database_qualifier is a blank string | Please enter a valid database name. Database name cannot be a blank string |
udf_name is null | No argument or default value supplied. |
udf_name is a blank string | User-defined function name cannot be a blank string. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qual | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
view_name | VARCHAR(255) | (no default value) | Name of the view whose definition text is required. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
DATABASE_QUALIFIER | VARCHAR (20) | Name of the database |
VIEW_TEXT | LONGVARCHAR | View definition text. |
Database_Qualifier | VIEW_TEXT |
---|---|
Demodata | SELECT "T1" ."Last_Name" ,"T1" ."First_Name" ,"T1" ."Phone" FROM "Person" "T1" |
Condition | Error Message |
---|---|
database_qualifier is a blank string | Please enter a valid database name. Database name cannot be a blank string. |
view_name is null | No argument or default value supplied. |
view_name is a blank string | View name cannot be a blank string. |
Parameter | Type | Default Value | Description |
---|---|---|---|
table_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
table_name | VARCHAR(255) | (no default value) | Name of the table for whose indexes are to be obtained. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
TABLE_QUALIFIER | VARCHAR (20) | Name of the database |
TABLE_OWNER | VARCHAR (20) | Name of the owner of the primary key table |
TABLE_NAME | VARCHAR(255) | Name of the primary key table |
INDEX_NAME | VARCHAR(255) | Name of the index |
INDEX_TYPE | VARCHAR (20) | Type of the Index: primary, foreign, or normal |
COLUMN_NAME | VARCHAR(255) | Name of the column on which index is defined |
ORDINAL_POSITION | USMALLINT | Ordinal position of the index |
DUPLICATES_ALLOWED | CHAR(3) | Yes, if it is a duplicate index No, if it is not a duplicate index |
UPDATABLE | CHAR(3) | Yes, if the index is updatable No, if the index is not updatable |
CASE_SENSITIVE | CHAR(3) | Yes, if the index is case-sensitive No, if the index is not case-sensitive |
ASC_DESC | CHAR(1) | D, Descending A, Ascending |
NAMED_INDEX | CHAR(3) | Yes, if it is a named index No, if it is not a named index |
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 |
Qual | TO | TN | IN | IT | CN | Opos | Dup | Up | Case | A/D | NI |
---|---|---|---|---|---|---|---|---|---|---|---|
Demodata | Null | Dept | Building_Room | Normal Index | Building_Name | 0 | Yes | Yes | Yes | A | Yes |
Demodata | Null | Dept | Building_Room | Normal Index | Room_Number | 1 | Yes | Yes | No | A | Yes |
Demodata | Null | Dept | Dept_Head | Normal Index | Head_Of_Dept | 0 | No | Yes | No | A | Yes |
Demodata | Null | Dept | Dept_Name | Normal Index | Name | 0 | No | Yes | Yes | 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 |
---|---|
database_qualifier is a blank string | Please enter a valid database name. Database name cannot be a blank string. |
table_name is a blank string | View name cannot be a blank string. |
Parameter | Type | Default Value | Description |
---|---|---|---|
pkey_table_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
table_name | VARCHAR(255) | (no default value) | Name of the table whose primary key information is requested. Pattern matching is supported |
Column Name | Data Type | Description |
---|---|---|
TABLE_QUALIFIER | VARCHAR (20) | Name of the database |
TABLE_OWNER | VARCHAR (20) | Name of the owner of the primary key table |
TABLE_NAME | VARCHAR(255) | Name of the primary key table |
COLUMN_NAME | VARCHAR(255) | Name of the primary key column |
COLUMN_SEQ | USMALLINT | Sequence of the columns (a segmented index) |
PK_NAME | VARCHAR(255) | Name of the primary key |
Table_ qualifier | Table_owner | Table_name | Column_name | Column_Seq | PK_name |
---|---|---|---|---|---|
'demodata' | Null | Pkeytest1 | Col1 | 0 | PK_col1 |
'demodata' | Null | Pkeytest1 | Col2 | 1 | PK_col1 |
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. |
Parameter | Type | Default Value | Description |
---|---|---|---|
database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
procedure_name | VARCHAR(255) | (no default value) | Name of the procedure for which rights are specified. Pattern matching is supported. |
user_name | VARCHAR(255) | Current user | Name of the user for whom the list of procedure rights needs to be obtained. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
PROCEDURE_QUALIFIER | VARCHAR (20) | Name of the database |
PROCEDURE_OWNER | VARCHAR (20) | Name of the owner of the procedure |
USER_NAME (GRANTEE) | VARCHAR(255) | Name of the user |
PROCEDURE_NAME | VARCHAR(255) | Name of the procedure |
RIGHTS | VARCHAR(12) | One of the following values: ALTER EXECUTE Note that RIGHTS pertains only to procedures in a database that uses V2 metadata. |
Procedure_Qualifier | Procedure_owner | User_name | Procedure_name | Rights |
---|---|---|---|---|
Demodata | Null | John | Dept1_Proc | ALTER |
Demodata | Null | John | Dept1_Proc | EXECUTE |
Procedure_Qualifier | Procedure_owner | User_name | Procedure_name | Rights |
---|---|---|---|---|
Demodata | Null | Mary | MyProc | ALTER |
Demodata | Null | Mary | Proc2 | ALTER |
Demodata | Null | Mary | Proc2 | EXECUTE |
Condition | Error Message |
---|---|
database_qualifier is a blank string | Please enter a valid database name. Database name cannot be a blank string. |
procedure_name is a blank string | Procedure name cannot be a blank string. |
user_name is a blank string | User name cannot be a blank string. |
psp_procedure_rights called for a database with V1 metadata | View and Stored Procedure permissions are not supported for metadata version 1. |
Parameter | Type | Description |
---|---|---|
object_name | VARCHAR(776) | The current name of the column, index, user-defined function, stored procedure, table, trigger or view. Object_name must be specified in a particular format depending on the type of object: Column: table_name.column_name. Index: table_name.index_name. Function: function_name Procedure: procedure_name Table: table_name Trigger: table_name.trigger_name View: view_name |
new_name | VARCHAR(776) | A user-defined name for the object. The name must conform to the naming conventions for the type of object. See Naming Conventions in Zen Programmer’s Guide. |
object_type | VARCHAR(13) | The type of object being renamed. Object_type must be one of the following: COLUMN, INDEX, FUNCTION, PROCEDURE, TABLE, TRIGGER or VIEW. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
procedure_name | VARCHAR(255) | (no default value) | Name of the stored procedure whose information is required. Pattern matching is supported. |
procedure_type | VARCHAR(5) | (no default value) | 'SP' returns the stored procedures 'SSP' returns the system stored procedures (this type is currently not supported) |
Column Name | Data Type | Description |
---|---|---|
PROCEDURE_QUALIFIER | VARCHAR (20) | Name of the database |
PROCEDURE _OWNER | VARCHAR (20) | Name of the owner of the procedure |
PROCEDURE _NAME | VARCHAR(255) | Name of the procedure |
PROCEDURE_TYPE | VARCHAR(25) | Type of procedure. The types are STORED PROCEDURE or SYSTEM STORED PROCEDURE. |
NUM_INPUT_PARAMS | INT | Returns null, because SQLPROCEDURES returns null when executed against Zen DSN |
NUM_OUTPUT_PARAMS | INT | Returns null, because SQLPROCEDURES returns null when executed against Zen DSN |
NUM_RESULT_SETS | INT | Returns null, since SQLPROCEDURES returns null when executed against Zen DSN |
REMARKS | VARCHAR(255) | Remarks |
TRUSTEE | INTEGER | For V2 metadata, returns 0 for a trusted stored procedure and -1 for a nontrusted stored procedure. The TRUSTEE column is empty for V1 metadata. |
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. |
Qualifier1 | Owner1 | Name1 | Type1 | Num_input_params | Num_output_params | Num_result_sets | Remarks | Trustee |
---|---|---|---|---|---|---|---|---|
pervasivesystdb | Null | psp_udfs | Stored Procedure | Null | Null | Null | Null | |
pervasivesystdb | Null | psp_users | Stored Procedure | Null | Null | Null | Null | |
1The complete column name includes “procedure_” prepended to this name: Procedure_qualifier, procedure_owner, and so forth. |
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 a blank string | Table name cannot be a blank string. |
procedure_type is a blank string | Procedure type cannot be a blank string. |
procedure_type is a value other than SP, SSP, or null | Procedure type can be SP, SSP, or null. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
table_name | VARCHAR(255) | (no default value) | Name of the table whose information needs to be obtained. Pattern matching is supported. |
table_type | VARCHAR(20) | (no default value) | Must be one of the following: 'User table' returns only the user tables 'System table' returns all the system tables NULL returns all tables |
Column Name | Data Type | Description |
---|---|---|
TABLE_QUALIFIER | VARCHAR (20) | Name of the database |
TABLE_OWNER | VARCHAR (20) | Name of the table owner |
TABLE_NAME | VARCHAR(255) | Name of the table |
TABLE_TYPE | VARCHAR (15) | System table - if the table is a system table User table - if the table has been created by any user |
REMARKS | VARCHAR(255) | Remarks |
FILE_LOCATION | VARCHAR(255) | Location where the file is saved |
Table_Qualifier | Table_owner | Table_name | Table_Type | Remarks | File_location |
---|---|---|---|---|---|
Demodata | Null | X$file | System table | Null | File.ddf |
Demodata | Null | X$field | System table | Null | Field.ddf |
Demodata | Null | X$Attrib | System table | Null | Attrib.ddf |
Demodata | Null | Billing | User table | Null | Billing.mkd |
..... |
Table_Qualifier | Table_owner | Table_name | Table_Type | Remarks | File_location |
---|---|---|---|---|---|
Demodata | Null | Class | User table | Null | class.mkd |
Demodata | Null | Billing | User table | Null | Billing.mkd |
..... |
Table_Qualifier | Table_owner | Table_name | Table_Type | Remarks | File_location |
---|---|---|---|---|---|
Demodata | Null | X$file | System table | Null | File.ddf |
Demodata | Null | X$field | System table | Null | Field.ddf |
Demodata | Null | X$Attrib | System table | Null | Attrib.ddf |
..... |
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 a blank string | Table name cannot be a blank string. |
table_type is a blank string | Table type cannot be a blank string. |
table_type is something other than 'system table,' 'user table,' or null | Table type can be system table, user table or null. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
table_name | VARCHAR(255) | All tables | Name of the table for which rights have are specified. Pattern matching is supported. |
user_name | VARCHAR(255) | Current user | Name of the user for whom the list of table rights needs to be obtained. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
TABLE_QUALIFIER | VARCHAR (20) | Name of the database |
TABLE_OWNER | VARCHAR (20) | Name of the owner of the table |
USER_NAME (GRANTEE) | VARCHAR(255) | Name of the user |
TABLE_NAME | VARCHAR(255) | Name of the table |
RIGHTS | VARCHAR(12) | One of the following values: SELECT ALTER DELETE INSERT REFERENCES SELECT UPDATE |
Table_Qualifier | Table_owner | User_name | Table_name | Rights |
---|---|---|---|---|
Demodata | Null | John | Dept | ALTER |
Demodata | Null | John | Dept | DELETE |
Demodata | Null | John | Dept | SELECT |
Table_Qualifier | Table_owner | User_name | Table_name | Rights |
---|---|---|---|---|
Demodata | Null | Mary | Class | SELECT |
Demodata | Null | Mary | Class | ALTER |
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 a blank string | Table name cannot be a blank string. |
user_name is a blank string | User name cannot be a blank string. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
table_name | VARCHAR(255) | All tables | Name of the table for which the trigger is defined. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
TRIGGER_QUALIFIER | VARCHAR (20) | Name of the database |
TRIGGER_OWNER | VARCHAR (20) | Name of the owner of the Trigger |
TABLE_NAME | VARCHAR(255) | Name of the table for which the trigger is defined. |
TRIGGER_NAME | VARCHAR(255) | Name of the trigger |
ISUPDATE | UTINYINT | Is set if it is an update trigger |
ISDELETE | UTINYINT | Is set if it is an delete trigger |
ISINSERT | UTINYINT | Is set if it an insert trigger |
ISAFTER | UTINYINT | Is set if the trigger action time is "after" |
ISBEFORE | UTINYINT | Is set if the trigger action time is "before" |
REMARKS | VARCHAR(255) | Remarks |
Trigger_qualifier | Trigger_owner | Table_name | Trigger_name | isupdate | isdelete | isinsert | isafter | isbefore | Remarks |
---|---|---|---|---|---|---|---|---|---|
mydbase | Null | A | Insert | 0 | 0 | 1 | 0 | 0 | Null |
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 a blank string | Table name cannot be a blank string. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
udf_name | VARCHAR(255) | All user-defined functions | Name of the udf whose details are needed. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
UDF_QUALIFIER | VARCHAR (20) | Name of the database |
UDF_OWNER | VARCHAR (20) | Name of the owner of the UDF |
UDF _NAME | VARCHAR(255) | Name of the UDF |
UDF_TYPE | VARCHAR(25) | Type of UDF (always set to 1) Currently, Zen does not support any special type of UDF. |
NUM_INPUT_PARAMS | INT | Returns null, because SQLPROCEDURES returns null when executed against Zen DSN. |
NUM_OUTPUT_PARAMS | INT | Returns 1, because UDFs return only scalar values |
NUM_RESULT_SETS | INT | Returns 0, because UDFs do not return resultsets |
REMARKS | VARCHAR(255) | Remarks |
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 |
Condition | Error Message |
---|---|
database_qualifier is a blank string | Please enter a valid database name. Database name cannot be a blank string. |
udf_name is a blank string | User-defined function name cannot be a blank string. |
Parameter | Type | Default Value | Description |
---|---|---|---|
database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
group_name | VARCHAR(255) | All groups (if group_name is null) | Name of the group used to return the user information. Pattern matching is supported. If group name is specified (i.e. if it is not NULL), only users belonging to the same group will be returned. |
user_name | VARCHAR(255) | All users (if user_name is null) | Name of the user. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
DATABASE_QUALIFIER | VARCHAR(20) | Name of the database |
GROUP_ID | USMALLINT | Group ID of the group to which user belongs |
GROUP_NAME | VARCHAR(255) | Name of the group to which user belongs |
USER_ID | USMALLINT | ID of the user |
USER_NAME | VARCHAR(255) | Name of the user |
Database_qualifier | Group_Id | Group_Name | User_Id | User_Name |
---|---|---|---|---|
Demodata | 1 | DevGrp | 3 | John |
Demodata | 2 | DevGrp1 | 1 | Mary |
Demodata | 1 | DevGrp | 4 | Michael |
Database_qualifier | Group_Id | Group_Name | User_Id | User_Name |
---|---|---|---|---|
Demodata | 1 | DevGrp | 3 | John |
Demodata | 2 | DevGrp | 4 | Michael |
Condition | Error Message |
---|---|
database_qualifier is a blank string | Please enter a valid database name. Database name cannot be a blank string. |
user_name is null | User name cannot be a null. |
group_name is a blank string | Group name cannot be a blank string. |
Parameter | Type | Default Value | Description |
---|---|---|---|
database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
view_name | VARCHAR(255) | All views (if view_name is null) | Name of the view for which rights are specified. Pattern matching is supported. |
user_name | VARCHAR(255) | Current user (if user_name is null) | Name of the user for whom the list of view rights needs to be obtained. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
VIEW_QUALIFIER | VARCHAR (20) | Name of the database |
VIEW_OWNER | VARCHAR (20) | Name of the owner of the view |
USER_NAME (GRANTEE) | VARCHAR(255) | Name of the user |
VIEW_NAME | VARCHAR(255) | Name of the view |
RIGHTS | VARCHAR(12) | One of the following values: ALTER DELETE INSERT SELECT UPDATE |
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 |
View_Qualifier | View_owner | User_name | View_name | Rights |
---|---|---|---|---|
Demodata | Null | Mary | vw_Class | ALTER |
Demodata | Null | Mary | vw_Class | SELECT |
View_Qualifier | View_owner | User_name | View_name | Rights |
---|---|---|---|---|
Demodata | Null | Mary | vw_Class | ALTER |
Demodata | Null | Mary | vw_Class | SELECT |
Condition | Error Message |
---|---|
database_qualifier is a blank string | Please enter a valid database name. Database name cannot be a blank string |
view_name is a blank string | View name cannot be a blank string. |
user_name is a blank string | User name cannot be a blank string. |
psp_procedure_rights called for a database with V1 metadata | View and stored procedure permissions are not supported for V1 metadata. |
Parameter | Type | Default Value | Description |
---|---|---|---|
Database_qualifier | VARCHAR(20) | Current database | Name of the database from which the details are to be obtained |
view_name | VARCHAR(255) | (no default value) | Name of the view whose information is required. Pattern matching is supported. |
Column Name | Data Type | Description |
---|---|---|
VIEW_QUALIFIER | VARCHAR (20) | Name of the database |
VIEW_OWNER | VARCHAR (20) | Name of the owner of the view |
VIEW_NAME | VARCHAR(255) | Name of the view |
REMARKS | VARCHAR(255) | Remarks |
TRUSTEE | INTEGER | For V2 metadata, returns 0 for a trusted view and -1 for a non-trusted view. The TRUSTEE column is empty for V1 metadata. |
View_Qualifier | View_Owner | View_Name | Remarks | Trustee |
---|---|---|---|---|
Demodata | Null | Vw_Person | Null | 0 |
View_Qualifier | View_Owner | View_Name | Remarks | Trustee |
---|---|---|---|---|
Demodata | Null | Vw_Person | Null |
Condition | Error Message |
---|---|
database_qualifier is a blank string | Please enter a valid database name. Database name cannot be a blank string |
view_name is a blank string | Table name cannot be a blank string. |