So far have got a connection and a read happening via a SELECT statement? If l wanted to read a single record from a db2 table (8.2 Express) via VB what would be the preferred method, for example SELECT * FROM TABLE where KEY = 'VALUE', is there another method l am unaware of ?

if key=value returns a single row (unique index) this is preferred
otherwise : select .... fetch first rows only (if multiple rows apply to result)