Skip to Content
avatar image
Former Member

about JDBC Adpter

Hi Expert:

i do a scenario of sqlserver->XI->oracle, beacase the message is too big to pull the data once,so at the sender adapter , i use the sql statement:SELECT TOP 1 percent id,one,two,three,five,six,seven,eight,nine,ten From test where processed=0 ,

at the sqlserver side(sender),the table has a clumn "processed" ,it's marked the row data had been pulled.

my problem is that how can i update the processed clumn which had been send the row data to the oracle

additional: the "sql server" data items is huge ( 5000000 items), so i can't pull the data to the oracle once.Otherwise pi server will be crashed.

best regard

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Apr 27, 2009 at 02:56 AM

    Hi Kevin,

    Please have a look at the following links and see if it helps you resolve the problem

    jdbc-adapter-no-update-to-database

    and

    https://www.sdn.sap.com/irj/scn/wiki

    Best Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27, 2009 at 04:01 AM

    you have the option of a Query SQL Statement and Update SQL Statement in the sender JDBC.

    So for your case after the select query give your next statement in the Update SQL Statement.

    http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2009 at 04:19 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2009 at 01:26 AM

    i had solved

    Add comment
    10|10000 characters needed characters exceeded