Adaptive Server immediately instantiates all nonmaterialized columns if you specify a command that includes clauses that require a full data copy to the table. This includes commands such as reorg rebuild and alter table to add a non-nullable column.
