Updating Record.

oldforum

• July 16, 2007 00:00

• Answered

Follow

Hello, I have abig problem in updating an existing record. my target database is oracle and the source table is a Text File. I successfully added new records by using Insert query in DB Output component, but when I try to update and existing record, an error occurs. Is there's a way for me to update the existing record in the target database? I already tried removing the datas from the target but the problem is, those datas have constraints, so it will not allow me to delete existing data. Please healp me... Thank You...

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  It's working now... :) Thanx..
  
  Now i need to work on my LookUp Errors.
• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  Hello,
  did you try use DBOutputTable in this way?
  
  <Node
  cloverFields="EMP_NO;FIRST_NAME;LAST_NAME;HIRE_DATE"
  dbConnection="DBConnection0"
  dbTable="employee_tmp"
  id="OUTPUT"
  maxErrors="10"
  sqlQuery="UPDATE employee_tmp SET FIRST_NAME=?,LAST_NAME=?,HIRE_DATE=? WHERE EMP_NO=?"
  type="DB_OUTPUT_TABLE"/>
  
  OtaSanek

Please sign in to leave a comment.