The SELECT statement returns at most one row   Use an INTO clause to assign the returned values directly to host variables. See SELECT statements that return at most one row.

The SELECT statement may return multiple rows   Use cursors to manage the rows of the result set. See Using cursors in embedded SQL.