Condition in receiver jdbc adapter?

[Former Member]

In file to JDBC scenario we want to update fields in receiver database only if the field starts with say abc..., so where we need to write condition to update specific fileds in database table?

[Former Member · Accepted solution]

hi suresh,

create 2 interfaces ,one which updates and condition and the other which will do the needful when condition is not met.

go to interface determination

1)in that add these two interfaces ,after adding u ll see condition editor towars right,so enter the respective conditions here.

Thanks & Regards,

Rama krishna

[deepak_shah]

hi

u can write the condtion in Sender JDBC communication channe, where in u can use an UPDATE sql statement

ie for eg UPDATE <tablename> where field = "abc" ..

[Former Member]

> In file to JDBC scenario we want to update fields in receiver database only if the field starts with say abc..., so where we need to write condition to update specific fileds in database table?

You can do this in Interface Determination in Integration Directory.

Give the condition there and when your conditon will be true, it will execute the mapping and your fields will be updated into database table.

[Former Member]

HI,

U can check the condition in Graphical mapping.

If specific field is abc then only pass the values to target JDBC structures if it is not then dont pass the values to target JDBC structure.

CHirag