on 10-13-2009 12:53 PM
Hello All
I'am just wondering is it posible to use variable in jdbc sender adapter in update query. In file adapter we can use variable f.ex to change file name or extension. Is it posible in JDBC adapter ??
update TestXi set [status] = '1' where id = %var% ???
Regards
Maciej
ok so receiver dosen't have any option configurated in dictionary so we cannot use variables in this adapter
Regards
Maciej
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In receivers we can use placeholders to pass the dynamic content
Your target sgould look like
<root>
<StatementName>
<anyName action=u201D SQL_QUERYu201D | u201CSQL_DMLu201D>
<access>SQL-String with optional placeholder(s)</access>
<key>
<placeholder1>value1</placeholder1>
<placeholder2>value2<placeholder2>
</key>
</anyName >
</StatementName>
</root>
refer http://help.sap.com/saphelp_nw04/Helpdata/EN/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm
Regards
Suraj
Hi Maceij
>>I'am just wondering is it posible to use variable in jdbc sender adapter in update query. In file adapter we can use variable f.ex to change file name or extension. Is it posible in JDBC adapter ??
Yes File adapter it is possible but not in sender
So Sender JDBC I dont think it is possible!!!
Regards
Suraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.