Skip to Content
avatar image
Former Member

JDBC Sender OS Command

Hi All,

I want to know where the operating system command runs when used in jdbc sender adapter , In PI or in the database after executing the sql queries? I am wondering if i can use a Stored procedure through a script in database. Any help appreciated .And forgive me for my ignorance Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 16, 2011 at 11:18 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 19, 2011 at 05:17 AM

    What you can do is :

    Create a multi Mapping.

    JDBC Sender DT - JDBC Receiver STored Procedure DT and

    JDBC Sender DT - Actual Receiver .

    Key points to remember is , on Interface Determination .. maintain order runtime ..... this will help to execute first Stored procedure then your actual target , if stored procedure fails then other interface will also not execute as maintain runtime order is checked.

    REgards

    PS

    Add comment
    10|10000 characters needed characters exceeded