on 01-16-2008 6:37 AM
Hello,
I want to pull the data from database dynamically using some runtime parameters through my JDBC sender channel.
For Eg.,
I want to give the SQL queries like this,
select ino,iname from Itable where sal = '?'
update Itable set processed = 'yes' where sal = '?'
Is it possible to give it like this in channel configuration of sender JDBC adapter?
Can you please help me in this regard with a reason?
Thanks,
Surya
You have to use Stored Procedures to achieve this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>>if you give the message ID in the where clause condition which we want to update the database as per the message processed.
Still not clear about your statement. You want to give the Msg Id generated in XI in where clause? If so why? What are you trying to achieve by this?
Regards,
Jaishankar
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
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.