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

schemaobj_pkey class

The schemaobj_pkey class is used to define primary key schema information. Use the SetObjInfo method to set values for this object.
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 pktable_qualifier,
String pktable_owner,
String pktable_name,
String pkcolumn_name,
short key_seq,
String pk_name)
 
Table 57: Parameters for SetObjInfo when using schemaobj_pkey 
Parameter
Type
Description
IN
 
 
pktable_qualifier
String
The name of the database in which the primary key table falls. Can be used to distribute tables into physically different databases. You would normally specify SCHEMA. If you want to expose this field as an empty value, then return a 0 when OAIP_getInfo(SQL_MAX_QUALIFIER_NAME) is called and set this field value to null.
pktable_owner
String
The owner of the primary key table. Set the value to SYSTEM or USER.
SYSTEM – the table is managed by the OpenAccess SDK SQL Engine.
OAUSER – the table is managed by the IP.
The value for this parameter and OA_COLUMNS must match.
pktable_name
String
The name of the primary key table. This is how the end user refers to it.
pkcolumn_name
String
The name of the primary key column.
key_seq
short
The column sequence number in the key, starting with 1.
pk_name
String
The primary key identifier.
RETURN
 
 
 
NONE