SELECT INTO statement

The SELECT INTO statement can be used instead of the SET command if you want to put the output of a query into a variable. You can set one or multiple variables with this statement.

Be sure that the statement returns just one row, otherwise you may will get an runtime error.


 create procedure myproc1 (out v_tabschema varchar(100), out v_tabname varchar(100))

    select tabschema,tabname into v_tabschema, v_tabname
      from syscat.tables
      order by create_time desc
      fetch first 1 rows only;

A similar behaviour is by using the VALUES statement:

 create procedure myproc (out v_timestamp timestamp)
   values current timestamp into v_timestamp;

Link to the DB2 Information Center: DB2 9.7 DB2 10.1 DB2 10.5