Page 1 of 1

SINGLE ROW

Posted: Thu Mar 08, 2007 7:48 pm
by 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.

Posted: Fri Mar 09, 2007 11:14 pm
by 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

DB2 - SQL INSERT DELETE UPDATE

Posted: Sat Mar 10, 2007 7:06 am
by 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.

Topic deleted by Admin

Posted: Fri Jan 15, 2016 10:00 pm
by academyindia4
<< Content deleted By Admin >>