skip to main content
OpenAccess SDK SQL Engine core methods for Java : Exchanging data : schemaobj_pkey class
 

schemaobj_pkey class

This 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 74. Parameters for SetObjInfo When Using schemaobj_pkey
Parameter
Type
Description
INPUT
pktable_qualifier
String
The name of the database that contains the primary key table. Can be used to distribute tables into physically different databases. In most cases, 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 key, starting with 1.
pk_name
String
The primary key identifier.
RETURN
NONE