Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: truncate table informix

Permlink Replies: 1 - Pages: 1 - Last Post: Jun 16, 2011 12:38 AM Last Post By: Roger Bjarevall

Posts: 8
Registered: 11/26/10
truncate table informix
Posted: Jun 15, 2011 9:48 AM
   thread.click_reply Reply

when truncating a table in informix, dbvis returns:
$TIME [TRUNCATE - 0 row(s), 0.000 secs] Command processed. No rows were affected
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 1 warnings, 0 errors]

truncate occurs though.
Roger Bjarevall

Posts: 5,464
Registered: 12/17/04
Re: truncate table informix
Posted: Jun 16, 2011 12:38 AM    global.in_response_to.tooltip in response to: Ardealul
   thread.click_reply Reply

The number of affected rows when running a SQL statement is fetched from the JDBC driver. When running the truncate command the Informix driver don't seem to set the count to reflect the number of affected rows. Hopefully this will be fixed in a future version of the driver.



Point your RSS reader here for a feed of the latest messages in all forums