Topic
No replies
SystemAdmin
SystemAdmin
90 Posts
ACCEPTED ANSWER

Pinned topic ODS error when a sql script contains a REORG TABLE statement

‏2011-10-25T18:48:59Z |
We create the following SQL script file with 3 lines:

ALTER TABLE MYTABLE ADD MYNEWCOLUMN INTEGER NOT NULL DEFAULT 0;
UPDATE TABLE MYTABLE SET MYNEWCOLUMN = 0;
REORG TABLE MYTABLE;

ODS is marking the third line with the REORG statement as an "error" and ODS states that it is expecting a REFRESH statement.

Why doesn't it support the REORG TABLE statement?