Hi,

Lets say I already done ada Create Table like this

CREATE TABLE test (abc BLOB);

how do I alter the compression to 6 in SQL ?

Tried

ALTER TABLE test ALTER COLUMN abc AS BLOB COMPRESSION 6;

But it's not working.

Regards,



Surjanto

Surjanto Kwe,

Your SQL statement appears to be correct.
When you say it is not working, did you get an error message? Or did the compression stay the same?

TIP:
If you want the SQL statement to alter a column for MyTable, open EDBMgr and open an SQL window and execute something like:  select * from MyTable

Now with this window open, right click on the table name in EDBMgr tree and select "Alter Table". Now modify the column (or any other part of the table) to change the compression level, and press "Alter Column" link to save the changes. Now press the Ok button. EDBMgr will try to implement the change to the table, but because your SQL window has the table open (locked), it will complain "Cannot lock table ..." "Would you like to copy the SQL to a new SQL Editor Window...?". Answer Yes and your SQL appears in the new window. You can copy and paste this SQL statement to your program.

(Remember to Unprepare or close the tab that has the "Select * from MyTable" otherwise your program will not be able to execute the DDL statement either.)

Barry

Barry


Or you can simply carry out the action and then get the sql from Explorer | SQL History

Roy Lambert

Barry wrote on Sat, 2 Nov 2013 23:11:12 -0400

>Surjanto Kwe,
>
>Your SQL statement appears to be correct.
>When you say it is not working, did you get an error message? Or did the compression stay the same?
>
>TIP:
>If you want the SQL statement to alter a column for MyTable, open EDBMgr and open an SQL window and execute something like: select * from MyTable
>
>Now with this window open, right click on the table name in EDBMgr tree and select "Alter Table". Now modify the column (or any other part of the table) to change the compression level, and press "Alter Column" link to save the changes. Now press the Ok button. EDBMgr will try to implement the change to the table, but because your SQL window has the table open (locked), it will complain "Cannot lock table ..." "Would you like to copy the SQL to a new SQL Editor Window...?". Answer Yes and your SQL appears in the new window. You can copy and paste this SQL statement to your program.
>
>(Remember to Unprepare or close the tab that has the "Select * from MyTable" otherwise your program will not be able to execute the DDL statement either.)
>
>Barry
>

Surjanto,

<< how do I alter the compression to 6 in SQL ? >>

That's the correct statement.  Are you seeing an error message ?

Tim Young
Elevate Software
www.elevatesoft.com

Sorry Tim,

Consider this as false alarm, don't know exactly what happened, it works just fine now.

Regards,


Surjanto