Problem in JDBC receiver Updation
I am updating the DB using the JDBC receiver adapter.
Tell me for the following case updation can be done or not.
key Field Field1 Field2
A X Y
C X Y
Consider above is the datas cmng to receiver JDBC to update the database. But here the record B has the field2 as empty in this case i should not update the record b with the field2 only field1 updation should takes place. Bcoz if i update the field2 with empty value the existing value may get deleted, hence only the field1 should be updated. Please tell me how to handle this.
Do i need to hae 2 diff update stmt for this. Revert back for any quries.
Edited by: Prem Kumar on Sep 24, 2008 4:27 PM