SINGLE ROW

[ibmlearner]

HI ALL !!!!!!!


HOW DO I KNOW THAT IM SELECTING A SINGLE ROW ????

WE CAN SAY WHEN WHERE CLAUSE IN SELECT STATEMENT.

APART FROM THAT ANY ANSWER PLZ ???

TIA.
_________________
Thanks & Regards
-------------------------
Learner

[Veera]

There are few SQL internal fields whcih are part of SQLCA area..if we look at the
internal strucutre of the SQLCA will know the info reg the variable it has as part
of its strucutre.

SQLERRD(3)
For INSERT, UPDATE, REFRESH, and DELETE, shows the number of rows affected.
For a FETCH statement, SQLERRD(3) contains the number of rows fetched.

Get some info on SQLCA area you will find more info on this.

Thanks,
Veera

[Sheela]

Apart from what veera said,

for singleton select statements,
if SQLCODE=0 means query selected one record
if SQLCODE=-811 means query selected multiple records.
_________________
Regards,
Sheela