It is not possible to rearrange or delete columns in a table without dropping the entire table. You can, however, create a view on the table, which includes only the columns you want, in the order you want. This has the same effect as redefining the table
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Start the unload. . . .
Regardless of other suggestions you may receive, i suggest you will want a complete unload before you do anything else. Even if you have an image copy or volume backup, having the unloaded data is a good precaution. If it it too large for dasd, use cart/tape.
After the unload completes, if there have been no suggestions that will meet your request, do the drop, create, and reload of the selected data.