update data in database table.

[Former Member]

hi experts,

i am new to XI.

i did a scenario like File to Database. It's execute successfull.

But how to update data in table.

For example query : update employee set address ='new address' where empId = 888.

how to give data types and message mappings

any body help.

Thanks in advance

[udo_martens · Accepted solution]

Hi Rama,

you can use action attribute "UPDATE".

Plz have a look to <a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm">Document Formats for the Receiver JDBC Adapter</a>

Regards,

Udo

[Former Member · Accepted solution]

Thanks alot.

[Former Member]

Hi,

Please define the data in the following format.

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Sudheer.