SupportSupport

Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: truncate table informix

Welcome, Guest: Login / Register; Guest Settings

Reply to this Thread

Search Forum

Back to Thread List

	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

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: 4,566
Registered: 12/17/04

Re: truncate table informix
Posted: Jun 16, 2011 12:38 AM

in response to: Ardealul

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

Pages: 1

Back to Thread List