SQL Statements › SELECT › Select-Into Statement › Example 1.

Example 1.

Put the row for employee 528671, from the employee table, into the specified host variables.

 EXEC SQL
      SELECT *
      INTO :EMPNO, :FNAME, :MI, :LNAME, :DEPTNO,
      :HIREDATE, :SALARY
      FROM CA.TEMPL
      WHERE EMPNO = '528671'
 END-EXEC