Skip to Content
author's profile photo Former Member
Former Member

Execute a SQL-Insert after update the target

Hi to All,

my scenario is SQL_1 -> XI -> SQL_2, but after update the SQL_2, I need to execute an SQL-insert. Can I do this without BPM?

Regarts

Roberto

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jun 21, 2006 at 12:11 AM

    Hi Roberto,

    If you want to insert the SQL_2 after updation of SQL_2 then BPM is not required.

    After updating the target you can execute the insert operation. I think , you can go for Stored procedures here.

    But if you want Response back to XI after successful Update, then BPM is required.

    >>You can do this in the stored procedure. For e.g just check this blog-

    /people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

    Regards,

    Moorthy

    Message was edited by: Krishna Moorthy P

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 21, 2006 at 12:00 AM

    hi,

    you can use stored-procedure for target.

    you can make coding something you want in stored procedure.

    thanks

    venjamin

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi venjamin

      Is there a way to execute the store procedure after update the SQL_2. My problem is that I need to copy one record to other table in SQL_2, but only when the update is made it from SAP XI.

      Thanks

      Roberto

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.