How to find out the n number of records inserted??

[GabrielSagaya]

In File to JDBC Scenarios, i am inserting n records in Oracle.

How to find out the n number of records inserted??

[agasthuri_doss · Accepted solution]

Hi,

>How to find out the n number of records inserted??

In Message Mapping you can find a function Counter you can make use of it. This Counter will generate the number of record per message if you want to consolidate all the record then from sourse side with the help of variant you can handle it with this counter function.

Regards

Agasthuri Doss

[Former Member]

Hi gabriel,

u get the number of affected rows in response. <insert_count>count</insert_count>. but as u are having a file-->jdbc scenario i am assuming it will be asynch. so u also need to think on these lines.

regards,

latika.

[Former Member]

Hey

just write a UDF for this,set the context to root node and increase the counter by 1 each time a new records comes in

Thanx

Aamir

[Former Member]

Hi,

If you are using the statement "UPDATE_INSERT", get the response on element <insert_count>count</insert_count>. It will give you the inserted rows.

This link can be very helpfull.

[http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm]

regards.

roberti