String Delimiters

To ensure the greatest portability of your SQL code, use single quotation marks around string constants in SQL.

EXEC SQL
     SELECT LAST_NAME INTO :LAST-NAME FROM EMPLOYEE
     WHERE LAST_NAME = 'SMITH'
END-EXEC.