#subselect

Differences of DB2 SELECT, Sub-SELECT and Full SELECT

  [  DB2 Developer Jobs ] SELECT -The select-statement is the form of a query that can be directly specified in a DECLARE CURSOR statement or FOR statement, prepared and then referenced in a DECLARE CURSOR statement, or directly specified in an SQLJ assignment clause. It can also be issued using SPUFI or the command line processor which causes a result table to be displayed at your terminal. In…