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 procedure columns.
All values should be set. Set Null values as follows:
*For a string, set the value to null 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 qualifier,
String owner,
String name,
String column_name,
short  column_type,
short  data_type,
String type_name,
int    precision,
int    length,
short  scale,
short  radix,
short  nullable,
String userdata,
String remarks)
Table 79. Parameters for SetObjInfo When Using schemaobj_proccolumn
Parameter
Type
Description
INPUT
qualifier
String
The name of the database in which the table is created.
owner
String
The owner of the table.
name
String
The name of the table.
column_name
String
The name of the column of the specified table.
column_type
short
Whether the procedure column is a parameter or a result set column.
data_type
short
The data type of the column.
type_name
String
The X/Open data type name.
precision
int
The number of digits of mantissa precision.
length
int
The maximum length for character data types.
scale
short
The number of significant digits to the right of the decimal point.
radix
short
Reserved for future use.
nullable
short
Whether the column can be null.
userdata
String
Any proprietary data about the column that the IP wants to access. The IP uses dam_describeColDetail to get this information.
remarks
String
The description of this procedure column.
RETURN
NONE

See also

*dam_describeColDetail