May 15, 2012 in Database
Sometimes, you need to run the DB2
REORG command from the JDBC code. You will need to run the
REORG command usually after executing the
ALTER TABLE DROP COLUMN statement. In order to execute the
REORG command from JDBC, you can do this as follows:
Call Sysproc.admin_cmd ('reorg Table [YOUR_TABLE_NAME]');
I hope that this tip can be useful to you.