DataDirect OpenAccess SDK Help

SetObjInfo method

Save PDF

SetObjInfo method

Save PDF

Last Updated: May 12, 2026
2 minute read

OpenAccess SDK
Version 8.1
Documentation

This method is used to return schema information about primary and foreign keys.

Refer to Schema Definition and Management in the OpenAccess SDK 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,
  String fktable_qualifier, 
  String fktable_owner, 
  String fktable_name, 
  String fkcolumn_name, 
  short  key_seq, 
  short  update_rule, 
  short  delete_rule,
  String fk_name, 
  String pk_name)

Parameters for SetObjInfo When Using schemaobj_fkey

Parameter	Type	Description
INPUT
pktable_qualifier	String	The name of the database that contains the primary key table. This parameter can be used to distribute tables into physically different databases. Typically, specify SCHEMA. To expose this field as an empty value and return a 0 when OAIP_getInfo(SQL_MAX_QUALIFIER_NAME) is called, 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 (how the end user refers to it).
pkcolumn_name	String	The name of the primary key column.
fktable_qualifier	String	The name of the database that contains the foreign key table. This parameter can be used to distribute tables into physically different databases. Typically, specify SCHEMA.
fktable_owner	String	The owner of the foreign 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.
fktable_name	String	The name of the foreign key table (how the end user refers to it).
fkcolumn_name	String	The name of the foreign key column.
key_seq	short	The column sequence number in key, starting with 1.
delete_rule	short	Not used. Set to DAMOBJ_NOTSET.
fk_name	String	The foreign key identifier.
pk_name	String	The primary key identifier.
RETURN
	NONE