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

open
nobody
None
5
2012-12-29
2007-08-06
No

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.

Discussion

  • Rob Manning

    Rob Manning - 2007-08-08

    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

    eagle79 - 2007-11-01

    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.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks