cancel
Showing results for 
Search instead for 
Did you mean: 

Query SQL Statement: Syntax for Stored procedure in Sender JDBC Channel

former_member201264
Active Contributor
0 Kudos

Hi Gurus,

I have to call a Stored Procedure from MS SQL Server.

The Stored Procedure name is SP_Vendor.

My concerns are:

1. how to import SQL Structure Metadata for this Stored procedure using External Definitions?

2. Query SQL Statement: Syntax for Stored procedure in Sender JDBC Channel?

3. Any blog with sender JDBC Channel screen shot with stored procedure.

Regards,

Sreeni.

Accepted Solutions (1)

Accepted Solutions (1)

MichalKrawczyk
Active Contributor
0 Kudos

hi,

>>>1. how to import SQL Structure Metadata for this Stored procedure using External Definitions?

create it manually as per

http://help.sap.com/erp2005_ehp_04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

<resultset> <-- structure

>>>>2. Query SQL Statement: Syntax for Stored procedure in Sender JDBC Channel?


execute storedprocname <params>

Regards,

Michal Krawczyk

former_member201264
Active Contributor
0 Kudos

Hi Michal/Praveen,

>>>>>execute storedprocname <params>

could you please clarify me at <params>:

My Stored procedure as bolow:

----------------------

SP_vendor

     parameters (Folder)

          @Bunit

          Returns integer

------------------------------

Here what should I use for <params>

Please clarify me.

Regards,

Sreeni

MichalKrawczyk
Active Contributor
0 Kudos

Hi,

params = parametrs put them there if you have any,

Regards,

Michal Krawczyk

former_member181985
Active Contributor
0 Kudos

execute SP_vendor @Bunit='xxxx'

xxxx - value for Bunit (in quotes '')

Answers (1)

Answers (1)

former_member181985
Active Contributor
0 Kudos

Hi,

You should use Execute command. Check SAP help: http://help.sap.com/saphelp_nw2004s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

For stored procedures, in general the return structure would be

<Return>

<FieldName1></FieldName1>

<FieldName2></FieldName2>

...

</Return>

Search forum for more help on blogs

Regards,

Praveen