on 04-04-2012 1:07 PM
Good day.
I need the following, I need a jdbc interface, which run more than oneselect in the same data type in different tables, and I return to bank information for an abap proxy.
I am in doubt, I use a cc jdbc receiver correct? Anyone have any examples of this solution?
Thank you.
If you have few selects from different tables but of same database, you might also want to think about select joins and use the query in the channel itself. This way you can avoid using Stored procedure. But if you query is complex then the better approach is using SP.
Refer this link
http://www.w3schools.com/sql/sql_join_full.asp
SELECT column_name(s)
FROM table_name1
FULL JOIN table_name2
ON table_name1.column_name=table_name2.column_name
Hope that helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes, sure, you can pass parameters.
Here you are an example :
http://scn.sap.com/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures
Your target message must have the format:
<StatementName>
<storedProcedureName action=” EXECUTE”>
<table>realStoredProcedureeName</table>
<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>
</storedProcedureName >
</StatementName>
See this:
http://help.sap.com/saphelp_nwpi711/helpdata/en/43/9519abb1146353e10000000a11466f/frameset.htm
REgards,
Carme
pls refer below threads might be it's helpful for ur prob:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you know that you can run stored procedures right ? (on sender and receiver JDBC adapter)
so you can have as many select statements as you need
Would that work for you ?
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,
I know of a functioning procedures, but I have a question about it.
Must be a JDBC Receiver as it will not run for polling, but by theactivation ecc.
Another important thing I need to pass as parameterto the procedure, a field.
How would the data structure in this situation? How would this parameter?
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.