#1142 DB2 REORG fails on 3.5.0

Squirrel SQL
open
nobody
reorg (1) db2 (4)
5
2015-01-08
2014-04-21
Karthik
No

SQuirrel version 3.5.0. Cannot execute reorg table command for DB2.

The query "reorg table schema.table" returns
An unexpected token "schemaname" was found following "reorg table ". Expected tokens may include: "JOIN". SQL Code: -104, SQL State: 42601

The query "reorg table table" returns
An unexpected token "table" was found following "reorg ". Expected tokens may include: "JOIN <joined_table>". SQL Code: -104, SQL State: 42601

When it's a reorg query, SQuirrel had to call SYSPROC.ADMIN_CMD('reorg table schema.table'). That'll do the work

Discussion


Log in to post a comment.

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

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks