skip to main content
OpenAccess SDK SQL Engine core methods for Java : Exchanging data : SetObjInfo method
 

SetObjInfo method

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 75. Parameters for SetObjInfo when using schemaobj_proc
Parameter
Type
Description
INPUT
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
The 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