#535 DB2 - on warning you say 0 records updated - that's wrong

[stan towianski]

Hi,

For DB2 (and check others), when I do a sql like:
delete from xxx;

db2 gives a warning which squirrel-sql interprets incorrectly as an error and tells me 0 records were updated when in fact they still were updated.

Warning: [IBM][CLI Driver][DB2] SQL0513W The SQL statement will modify an entire table or view. SQLSTATE=01504

SQLState: 01504
ErrorCode: 513
0 Row(s) Deleted <-- this is wrong
Query 1 of 1 elapsed time (seconds) - Total: 0.391, SQL query: 0.391, Building output: 0
Commit completed normally.

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

Well for me, DB2 doesn't issue this kind of warning. Are you using a snapshot version of SQuirreL with the DB2 Plugin? What version of DB2 on which platform?

Rob

[eagle79]

Logged In: YES
user_id=1300245
Originator: NO

As I am aware, this is not a Squirrel issue, but a driver issue. 0 is actually the update count returned by the driver. I am not entirely certain of that fact, however.