Number of rows retured in select statament

[venky_b]

I want know how many number rows are retrieved from the select statement in jdbc adapter

[santhosh_kumarv]

Hi Venkatesh,

>>I want know how many number rows are retrieved from the select statement in jdbc adapter

It depends upon the query condition and the data in the database.

If your requirement to to count the records then u can map the node to count standart function.

Input node -

---

> remove context -

---

> count -

---

> output node.

noe your output node will have the no of records/message of the input node.

Hope this help...

Regards

San

[udo_martens]

Hi venkatesh,

you can get that in the mapping. Message Mapping: use standard function count, XSLT: use XPath function count(//row).

Regards,

Udo

[former_member192892]

If you want the count, then you can use the standard function count with the source tag row

[Former Member]

Hi

It can access n numbers of rows depends on the condition and the no. of coloumns..a if u are fetching milions of rows at a time then it become a huge messag in the XI...

Thanks

Farooq.