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

Example 2.

Put the maximum salary in the employee table into the host variable MAXSALARY.

 EXEC SQL
      SELECT MAX(SALARY)
      INTO :MAXSALARY
      FROM CA.TEMPL
 END-EXEC