Skip to Content
0
Former Member
Dec 01, 2008 at 05:44 PM

Selecting only one row at a time

1158 Views

Hi experts,

i have following doubt regarding selecting rows from a db:

Is there any way of selecting only one row AT A TIME from a dabase just to collect the data in rows instead of in a unique document containing all the rows?

I would like you to ellaborate on this as i need to send only one row to the IE, and then other row, and so on... without throwing any error!

I have seen that there are SELECT SINGLE and SELECT UP TO 1 ROW, but these two methods are only useful when retrieving only one row, and that does not match my requirements. I need to process all the rows but one by one..

I know that we can use the receiver jdbc adapter as if it was a sender by means of its specific datatype, but how to do it row by row??

Hope i had explained well..

Thanks in advance and best regards,

David