on 07-04-2008 11:00 AM
just like: select * from TAB where field=A;
use JDBC receiver adapter?
Regards.
Hi,
>>just like: select * from TAB where field=A;
use JDBC receiver adapter?
Receiver JDBC Adapter
For Example:
Actio=INSERT
Statements with this action cause table values to be inserted. Therefore, the statement corresponds to an SQL INSERT statement.
The <access> block contains the new column values.
A statement with the action INSERT must have at least one <access>element. It cannot have a <key> element.
The corresponding SQL statement for StatementName2 in the example above is as follows:
INSERT INTO dbTableName (col1, col2) VALUES(val1, val2)
INSERT INTO dbTableName (col1) VALUES(val11)
The response document contains the following element as well as the number of inserted table lines, including 0.
<insert_count>count</insert_count>
Regards,
Sangeetha
Edited by: Sangeetha on Jul 4, 2008 5:41 PM
Edited by: Sangeetha on Jul 4, 2008 5:49 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
We dont have option to use this type of queries in the JDBC Receiver
We can use in JDBC Sender side
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Have a look into this, it may help you.
http://help.sap.com/saphelp_nw04s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm
Regards
Aashish SInha
PS : reward points if helpful
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.