cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Update query and variable

maciej_jarecki
Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

maciej_jarecki
Contributor
0 Kudos

ok so receiver dosen't have any option configurated in dictionary so we cannot use variables in this adapter

Regards

Maciej

former_member187339
Active Contributor
0 Kudos

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

former_member187339
Active Contributor
0 Kudos

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