spfix [-shortnames file] [-upcase] [-cleanup] file1 [file2...]
||File with shortnames for tables. The format is the same for
TBLFIX: one line per table, with table name followed by the shortname, with
white space as a separator. You can use |
|| If you specify |
||Miscellaneous cleanup, see below.|
SPFIX permits you to script out a database from Enterprise Manager, and split the objects into files on their own so that you then can put the files under source control. The input file(s) does not have to come from EM; they could come from any source.
SPFIX puts each object into a file of its own, and each file is name object.ext, where object is the name of the object and ext is .SP for stored procedures, .SQLFUN for user-defined functions, .TRI for triggers and .VIEW for views. This agrees with the AbaPerls SQL directory structure, except on one point: SPFIX places each trigger in a file on its own, but all triggers for a table should be in one file. You will have fix this yourself.
SPFIX writes all the files to the current directory.
These are the changes that SPFIX performs when it generates the files:
If you specify
(The reader may question some of these changes. Apparently at some time in the dim and distant past I had some junk code, which needed these fixes.)
SPFIX is fairly rough tool, and you should probably build an empty database with DBBUILD to find any syntax errors, and also verify with the original database that SPFIX succeeded in finding all objects in the input file(s).