The Summary of the Actions page of the Table Reorganization wizard allows you to review the generated action script before applying it to a database. You can also copy this script instead of applying it directly to the database and paste it to any other tool.
The script contains all required SQL statements in the correct sequence.
For the Remote Export/Import reorganization method, the generated script also contains remote calls to Informix DBLOAD and DBACCESS utilities to export and import table data during the reorganization operation. The Table Reorganization wizard streamlines the entire operation by executing all commands in the script using JDBC connection and its own transparent telnet or SSH session. If you want to execute this script manually, you have to separate SQL statements from Informix command calls and execute SQL statements from any SQL Editor or dbaccess and execute DBLOAD commands from the server workstation or from your remote telnet or SSH session.
The script is very valuable when you perform Remote Export/Import reorganization because it generates updated CREATE TABLE statement based on your visual designer entries and also generates all SQL statements required to recover existing user permissions, table triggers, views, synonyms and foreign key constraints for all other tables linked by primary/foreign key relationships to this table. These objects are automatically dropped by the Informix server engine when the table is dropped.
Press the Start button to apply the reorganization operation to the table.
To copy the generated script into another text editor: