on 09-06-2009 4:49 PM
There is a database that needs acessing that has numbers at the start of some column names, e.g. 9AVERSION. This means that XML SQL format is not an option, since the XML element would have to be named <9AVERSION> and that is not allowed due to the first character being a number.
I could set the Message protocol of the JDBC receiver to Native SQL string, but is it then possible to somehow chain the SQL INSERT commands together? I would typically have a message with over 1000 records to insert.
Is there a way to chain SQL commands so that I can execute all of the INSERT commands one after the other with one call to the adapter?
BR,
Tony.
HI,
You can look for SQL_DML to resolve the purpose..
Check - http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Thanks
Swarup
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yew sql_dml will resolve your issue,
using SQL_DML you can directly pass the query as a whole with placeholder values. you can also pass multiple sql queries in one message.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.