Skip to Content
avatar image
Former Member

help for SQL_DML

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    May 16, 2007 at 05:52 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • May 16, 2007 at 05:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 16, 2007 at 05:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 16, 2007 at 06:07 AM

    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....

    Add comment
    10|10000 characters needed characters exceeded