docs.intersystems.com
Home  /  Application Development: Core Topics  /  Using ObjectScript  /  Embedded SQL


Using ObjectScript
Embedded SQL
[Back]  [Next] 
InterSystems: The power behind what matters   
Search:  


You can embed SQL within ObjectScript on InterSystems IRIS Data Platform™.
Embedded SQL
Embedded SQL allows you to include SQL code within an ObjectScript program. The syntax is &sql( ). For example:
  &sql( SELECT Name INTO :n FROM Sample.Person )
  WRITE "name is: ",n
For further details, refer to the Using Embedded SQL chapter in Using InterSystems SQL.