|
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
|
||