skip to main content
OpenAccess SDK SQL Engine core methods for .NET : Helper classes : schemaobj_column class : SetObjInfo method
 

SetObjInfo method

This method is used to set values for an object to return schema information about columns.
All values should be set. Set Null values as follows:
For strings, set the value to null.
For 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 table_qualifier,
String table_owner,
String table_name,
String column_name,
short data_type,
String type_name,
int char_max_length,
int numeric_precision,
short numeric_precision_radix,
short numeric_scale,
short nullable,
short scope,
String userdata,
String operator_support,
short pseudo_column,
short column_type,
short remarks)
Stringremarks)
 
Table 43: Parameters for SetObjInfo when using schemaobj_column 
Parameter
Type
Description
IN
 
 
table_qualifier
String
The name of the database in which the table is created.
table_owner
String
The owner of the table.
table_name
String
The name of the table.
column_name
String
The name of the column of the specified table.
data_type
short
The data type of this column.
type_name
String
The X/Open column type.
char_max_length
int
The length in bytes of data transferred to the client in its default format.
numeric_precision
int
The maximum number of digits used by the data in the column.
numeric_precision_radix
short
Reserved for future use.
numeric_scale
short
The total number of digits to the right of the decimal point.
nullable
short
Specifies whether the column can be null.
scope
short
Scope of the SQL_BEST_ROWID column.
userdata
String
Any proprietary data about the column that you want the IP to access. The IP calls dam_describeColDetail to get this information.
operator_support
String
A place for the IP to maintain which operators it supports for conditions on this column (for example, =, >, LIKE), when this column is considered for a restriction or a search condition.
pseudo_column
short
Indicates whether the column is a pseudo column such as Oracle ROWID.
column_type
short
Defines the column type.
remarks
String
The description of the column.
RETURN
 
 
 
NONE
 

See also 

dam_describeColDetail