docs.intersystems.com
Home / InterSystems SQL Reference / SQL Functions / %OID


InterSystems SQL Reference
%OID
Previous section           Next section
InterSystems: The power behind what matters   
Search:  


A scalar function that returns OID of an ID field.
Synopsis
%OID(id_field)
Arguments
id_field The field name of an ID field, or a reference 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
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
See Also


Previous section           Next section
View this book as PDF
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-02-19 00:53:50