SetObjInfo method
- 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.
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 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
| 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. |
| fktable_qualifier | String | The name of the database in which the foreign key table falls. Can be used to distribute tables into physically different databases. Specify SCHEMA in most cases. |
| 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. This is 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 |