Stored Procedure in PI

[Former Member]

Hi,

I have a requirement to use stored procedure that is generating a keyvalue and sending it to some other table.

there is two input parameter and one output paramenter in stored procedure. With two INPUT parameter it will send SUPERKEY to OUTPUT parameter. that output parameter value have to be stored in table.

my traget structure is like this.

SUPERKEY, Country, ID,Dec.

Where SUPERKEY is the value form Strored procedure and other column data will come form flat file.

Please tell me how to achive this and what will be mapping design.

Thanks

Laxmi Bhushan

[Former Member]

Hi Laxmi Bhusan,

For creating the Stored procedure, you just follow the below link, what Statement Structure you need to use in the case of call the stored procedure.

http://help.sap.com/saphelp_nw04/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm

For your requirement in stored procedure, I am n't clearly, Can you explain properly.

Thank you,

Sateesh

Edited by: sateesh kumar .N on Sep 17, 2010 8:00 AM

[Former Member]

Hi,

I have to use Stored procedure in reciever JDBC where it will create a KEY that will store in the database .

Based on two input parameter it will send the generated key in the output parameter.

Remaining data from will come from the file .

Stureture will be like

File JDBC

KEY -- From Strored Procedure in Target jdbc

value1 value1

value2 value2

value3 value3

Please provide your input

thanks

Edited by: laxmi bhushan on Sep 17, 2010 12:12 PM