%OID

Synopsis

%OID(id_field)

Description

%OID takes a field name and returns the fully formed OID (object ID) for the object. The field must be either an ID field or a reference field (a foreign key field). Specifying any other type of field in id_field generates an SQLCODE -1 error.

Examples

The following example shows %OID used with a reference field:

SELECT Name, Spouse, %OID(Spouse)
FROM Sample.Person
WHERE Spouse IS NOT NULL

Copy code to clipboard

The following Embedded SQL example shows %OID used with a reference field:

  &sql(SELECT Name, Spouse, %OID(Spouse)
       INTO :n,:s,:soid
       FROM Sample.Person)
  WRITE !,"Name is:",n
  WRITE !,"Spouse name is:",s
  WRITE !,"Spouse OID is:",soid

Copy code to clipboard

See Also

• SELECT

• %OBJECT