The biggest enhancement(s) I would like to see in UNLOAD: 1. Transitive closure for PK/FK dependencies when unloading table structures. I believe it's currently possible for a table with an FK into another table to be unloaded _before_ the table with the corresponding PK. Trying to load this structure will fail. R:Base ought to ensure that the order of tables is reloadable.
2. Transitive closure for view dependencies when unloading views. I believe it's currently possible for view B that depends on view A to be unloaded before view A is unloaded. This can happen if you define A, then B, then drop A and redefine it. Obviously, the resulting file will fail to create view B when it is run. 3. Currently, stored procedures are not unloaded in any way. I'd like to see the SYS_PROCEDURES and the other table for procedures (the name escapes me at the moment) unloaded as well. -- Larry
