how to use sql variables in jdbc send adapter??
i wanna use a variable in the sql statement in the jdbc send adapter.
i know i can key sql statement in the "Query SQL Statement" in the jdbc send adapter.but i dont know how to use variables in the sql statement.
i mean, for example, the sql statement is "SELECT * FROM t_student WHERE READFLAG = 0", but now i wanna instead of "0"(the value of the READFLAG) using a variable.
and if i can use a variable to replace the "0"(the value of the READFLAG above sql statement), then how can i send a value to the variable??
request help in the regard.
thx in advance.
Try to use Stored procedure to achieve this
for SQL DB Sender Stored procedure with XI Sender Adapter supported
but with oracle it has some restrictions ,
Am not sure but with service pack SP15 and with oracle 10.2 series Sender JDBC supports Stored procedure or else u cannot go with Stored procedure with Oracle
refer sapnote : 941317