help for SQL_DML

[Former Member]

Hi friends,

i am doing proxy to JDBC...

i need to use SQL_DML for JDBC.

i have a scenario i first need to delete the data and update it later.

could u plz help in writing the sql code for this as i am very much new to SQL..

thanking u in advance....

dont worry abt points...i will do that part!!!!!!111

[Former Member]

i am trying to update a database table ...the data coming from xi needs first deletion of existing data in table and insert the new data....

[Former Member]

SQL_DML is being used as we need to do further actions also apart from what i asked...plz help me

[bhavesh_kantilal]

You need to give us more info on what you actually are trying.! The exact requirement with may be an example.

Regards

Bhavesh

[Former Member]

Hi Chaitanya

If you still want to use DML, take a look at the following help doc

http://help.sap.com/saphelp_nw04s/helpdata/en/f7/5440f9b4f07f42a451b310f958690d/frameset.htm

Regards

krishna

[bhavesh_kantilal]

Hi,

1. Why are you using a SQL DML? You can use Action = Delete and Action -= Update.

2. Can you provide an example of what you need to do?

Look into this link for the document formats for the JDBC adapter,

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

Regards

Bhavesh