Every target table includes a mandatory column with the name oid that contains the OID of the object corresponding to the table row.
JADE supports the following RPS object identifier (oid) length mapping options.
Map to String (7.1 format), which is a length 28‑character fixed‑length string of the "ccccccc.nnnnnnnnnnnnnnnnnnnn" format, with leading zeros in both the class and instance fields. The ccccccc value is the 7‑character class number, 1 character is for the separator, and nnnnnnnnnnnnnnnnnnnn is the 20‑character instance id.
This is the recommended oid mapping option, as any oid can be represented in this way.
Map to String (7.0 format), which is a length 16‑character fixed‑length string using a "ccccc.nnnnnnnnnn" format, with leading zeros in both the class and instance fields. The ccccc value is the 5‑character class number, 1 character is for the separator, and nnnnnnnnnn is the 10‑character instance id. (From JADE 7.1, system class numbers start at 1,000,000, so if a reference to a system class is included in the RPS mapping, the mapping will need to be changed to use the 7.1 format OID mapping option.)
If the instance id value is greater than 9,999,999,999, the RPS node will assert and you must rebuild the RPS node by using the Split Into Columns Int/BigInt option.
Int/Int, which maps oids and references into two integer columns of _clsno (type int) and _instid (type int).
This mapping option cannot accommodate instance ids larger than 2,147,483,647.
Int/BigInt, which maps oids and references into two integer columns of _clsno (type int) and _instid (type bigint), to accommodate 64-bit instance ids.
This mapping option cannot accommodate instance ids larger than 9,223,372,036,854,775,807.
For details about setting up RPS mapping, see "