How to find rowcount in DB2

avishalpatil · #1 (**permalink**) 05-20-09, 04:31

Hi all
Could you please provide me the query for rowcount in DB2

Regards
Vishal

przytula_guy · #2 (**permalink**) 05-20-09, 04:33

you mean select count(*) ..

rahul_s80 · #3 (**permalink**) 05-20-09, 04:53

get diagnostics
for no of rows impacted in last ins/upd/del

dr_te_z · #4 (**permalink**) 05-20-09, 05:20

Code:

D:\Script>db2 -a "update employee set hiredate = hiredate + 1 day where workdept = 'D21'"

SQLCA Information

 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: 0   sqlerrml: 0
 sqlerrmc:
 sqlerrp : SQL09053
 sqlerrd : (1) 0                (2) 0                (3) 7
           (4) 0                (5) 0                (6) 0
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
           (7)      (8)      (9)      (10)       (11)
 sqlstate: 00000

7 rows are updated. this can be derived from the 3rd occurence of sqlerrd.

avishalpatil · #5 (**permalink**) 05-20-09, 06:51

I mean......I have to select first two rows from a table.In oracle we can do this like:-->

select * from emp where rownum<=2

How can i achive above query in DB2??

Regards
Vishal

przytula_guy · #6 (**permalink**) 05-20-09, 07:11

select .. fetch first 2 rows only

Internet Services

Web Development

Digital Marketing

Consumer Tech