>>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.
>

Yes, this is very complicated...

>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.
>

Here is the problem: for most operations we need to use user's configuration. Only for this particular application I need to change temp dir to something else.


>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.


Yes, and that's unfortunate... Of course, I can parse Config.fpw file to find them, but it's not an easy solution. SYS would be so much easier...