DB_OUTPUT_TABLE and cloverFields attribute

hwhwhw

• October 30, 2007 00:00

• Answered

Follow

can allows specification of more SQL query/DML statement to be executed against database? Questionmarks [?] in the more query text are placeholders which are filled .

Example:
<Node id="OUTPUT" type="DB_OUTPUT_TABLE" dbConnection="NorthwindDB"
cloverFields="Field0;Field1;Field2;Field3;Field4;Field5"
sqlQuery="
delete from dictionary_table where userid=? ;
insert into employee_table (LAST_NAME,DATE) values (?,sysdate) ;
insert into master_table (aF,bF) values (?,?) ;
update slave_table set aName=? where ID = ? "
/>

• 

  dpavlis

  • October 30, 2007 09:58

  0

  Comment actions Permalink

  This will be supported in next release of Clover - 2.4 - we are currently working on it.
  
  For now, you may only use SimpleCopy component to split the flow into 4 streams and use 4 DBOutputTable(s) to send those 4 statements into database.
• 

  hwhwhw

  • October 31, 2007 00:36

  0

  Comment actions Permalink

  Thank you, look forward to the next version of the launch.

Please sign in to leave a comment.