skip to main content
OpenAccess SDK SQL Engine core methods for .NET : Helper classes : schemaobj_proc class : Using SetObjInfo with the schemaobj_proc class
 

Using SetObjInfo with the schemaobj_proc class

This method is used to return schema information about stored procedures.
All values should be set. Set Null values as follows:
• For a string, set the value to null.
• For an integer, set the value to DAMOBJ_NOTSET.
Refer to Chapter 5 "Schema definition and management" in the OpenAccess SDK SQL Engine Programmer's Guide for information about each of the values to set.
void SetObjInfo(
String proc_qualifier,
String proc_owner,
String proc_name,
int num_input_params,
int num_output_params,
int num_result_sets,
short proc_type,
String userdata,
String remarks)
 
Table 62: Parameters for SetObjInfo When Using schemaobj_proc 
Parameter
Type
Description
IN
 
 
proc_qualifier
String
The name of the database in which the stored procedure exists.
proc_owner
String
The owner of the stored procedure.
proc_name
String
The name of the stored procedure.
num_input_params
int
The number of input parameters. Not used at this time.
num_output_params
int
The number of output parameters. Not used at this time.
num_result_sets
int
Number of result sets.
proc_type
short
The type of the stored procedure.
userdata
String
A place for the IP to maintain IP-specific data. The IP can read it by using dam_describeProcedure.
remarks
String
The description of the stored procedure.
RETURN
 
 
 
NONE
 

See also 

• dam_describeProcedure