Can we able to pull the data dynamically based on the runtime parameters

[Former Member]

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

[Former Member]

You have to use Stored Procedures to achieve this.

[Former Member]

can you please explain how you acheive that as i already tried that option but couldnt work it out.

Give an example how we can acheive it thru stored procedures.

Urs,

Surya

[Former Member]

What do you mean by dnamic values? How are these calculated?

The procedure for computing these values must be incorporated in the SP and you have to invoke this SP from XI.

Regards,

Jai Shankar

[Former Member]

i mean to say about dynamic values as,

if you give the message ID in the where clause condition which we want to update the database as per the message processed.

so can we do it ?

[Former Member]

>>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