The SELECT INTO statement produces a result table consisting of at most one row, and assigns the values in that row to variables. If the table is empty, the statement assigns +100 to SQLCODE and '02000' to SQLSTATE and does not assign values to the variables. If more than one row satisfies the search condition, statement processing is terminated, and an error occurs.
For more information, see SELECT INTO in the SQL Reference topic in the Information Center.