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
Ardealul

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

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,221
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
Hi,

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.

Regards

Roger

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