how to update row by row in Jdbc Adapter sender ?

[former_member189387]

Hi friends ,

No i am reading data from a table using select query and resulting data i am keeping in the FTP folder as XML File.

I want to

1. to know how many rows i read ?

2. Update the read completed time in each row of the sender side table .

( I am using <b>select * from a table where tag='n' </b> . I am giving this in <b>Query SQL Statement</b> of JDBC Sender adapter processing parameter .

I am writing update query as update table set tag='y' where tag='n' .

Will it perform row by row ?

3. Insert in to another R3 System table the rows which i read as a log .

Can you please give procedure to do that .

Expecting your reply asap .

Thank you

Best Regards.,

V.Rangarajan

[justin_santhanam]

Rajan,

<i> 1. To know how many rows i read?</i>

While selecting the rows you will get the outbound payload with <Rows> tag in it. So if you count the no.of <Rows> tag you will get the no.of rows you read.

Do the logic as

Rows(Change context to higher level) ->COUNT(Statistic function) -> Target

3 . Can u please explain little bit more.

Best regards,

raj.

[former_member189387]

Hi raj ,

Thanks for ur reply . I am new to xi . Just i am doing a scenario . I can able to read the ms-sql server table data using jdbc Sender adapter .

Can i use RFC Adapter to insert the values to R3 table ?

If i have mapped to rfc fields will it store into the table once we read the data from ms_sql server table using select query of JDBC Sender Adapter ?

Best Regards

V.Rangarajan

[bhavesh_kantilal]

><i>Can i use RFC Adapter to insert the values to R3 table ? </i>

You sure can. Write a RFC that will read these input values and push into the corrsponding R3 tables.

You will just need to write the ABAP code to do the insertion in your RFC, make sure it is remote enabled and then import this RFC into XI.

Regards

Bhavesh

[prateek]

<i>Can i use RFC Adapter to insert the values to R3 table ? </i>

Yes. In this case ur RFC would include an insert statement in its source code

<i>If i have mapped to rfc fields will it store into the table once we read the data from ms_sql server table using select query of JDBC Sender Adapter ?</i>

Not directly. As i said ur RFC source code should include the required statement to query the database

Regards,

Prateek

[prateek]

<i>1. to know how many rows i read ? </i>

At XI, you need to check the target structure created in the sxmb_moni and look for the data there. At sender u need access to the database.

<i>Will it perform row by row ?</i>

Internally Yes. But u couldnt differentiate the selected rows.

<i> 3. Insert in to another R3 System table the rows which i read as a log</i>

as a log??

If u want to update R3 database, u could opt for

JDBC - XI - IDoc scenario, or JDBC - XI - Proxy

Regards,

Prateek