cancel
Showing results for 
Search instead for 
Did you mean: 

Using Native SQL mode of JDBC adapter to chain SQL statements

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Great, Thanks!

BR,

Tony.

Answers (1)

Answers (1)

Former Member
0 Kudos

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.