on 01-08-2013 5:23 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.