>Jim,
>
>Leaving aside the fact, that whole complicated code is already written based on ALTER TABLE, how can I do this process for DBC's tables?
Run GENDBC to get all the code you need to create the table, PK, FKs, RI, indexes, etc. Store all that in a metadata table. After you create the replacement table, drop the original table from the DBC, move the new table over, rename it. You would then need to add the new table to the DBC and run the code to replace all this info back in the DBC.
IMHO, this is a total mess when a simple [to me at least] solution is to just start your JobControl with the settings you need in a CONFIG.FPW.
As for your reply back to me, I can not find anywhere a function that returns the setting for SORTWORK, EDITWORK and PROGWORK. The only function is SYS(2023) for TMPFILES.
Mark McCasland
Midlothian, TX USA