(If your select statement is merely necessary to determine if you should do an update or not, it should just be returning a single value and not any data at all).<BR><BR>3.

The PROC SQL SELECT statement uses a CONNECTION TO component in the FROM clause to retrieve data from the ORACLE table. The Pass-Through query (in italics) is enclosed in parentheses and uses ORACLE ...