Hello,

I started to develop a IBM DB2 driver to libdbi (about 70% was done)

Currently the libdbi need know about how many rows a select query need
to return then allocate the rows need. The DB2 API don't have any
function to return the number of rows.

How I can do it?

One way to solve this is perform the query: 'select count(*) from
([big select here])' before send the 'big select' query . This can
tell me how many rows the select return.

I think DB2 and Oracle have this 'problem'. These database engines
works with result set and row set. But libdbi need to know the total
rows return to allocate the memory need.

Thanks.

-- 
-----------------------------------------------------------
João Henrique Freitas - joaohf_at_gmail.com
Campinas-SP-Brasil
BSD051283
LPI 1
http://www.joaohfreitas.eti.br
------------------------------------------------------------------------------
_______________________________________________
Libdbi-drivers-devel mailing list
Libdbi-drivers-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel

Reply via email to