Leave feedback
  • Question

    JDBC Output Connector - UPDATE Syntax

Enter a new topic
  • Dennis Staiger Dennis Staiger
    0 likes 442 views

    We are trying to perform an UPDATE call in a JDBC Output Connector but we cannot find the correct syntax for it.

    The connector documentation shows an example for an insert call (INSERT INTO myTable *) but fails to mention how to perform an UPDATE. The statement we are looking for is "UPDATE myTable SET field1 = 'abc' WHERE field2 = 'someValue').

    What is the syntax to perform an UPDATE and how can we pass in the parameters (fields to update as well as the conditions in the WHERE clause)? I assume that we also need an XMLOut process as is the case with the INSERT statement, but how does it have to be structured?

    Any advice is welcome.

     

    Regards,

    Dennis

    Monday 16 June, 2014

 

Latest from the blogs

Read more