SPFIX

SPFIX reads one or more files with stored procedures, user-defined functions, triggers and views and put each object in a file on its own. You can also request various changes to be made to the code.

Command-line syntax:

   spfix [-shortnames file] [-upcase] [-cleanup] file1 [file2...]

`-shortnames`	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 `--` to introduce a comment.
`-upcase`	If you specify `-upcase`, all SQL keywords will be cast into uppercase.
`-cleanup`	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:

Adds an empty header with the SourceSafe keywords $Header: $ and $History: $.
Removes any DROP or GRANT.
If you have specified -upcase, SQL keywords are cast in uppercase.
For tables that have shortnames defined in the file you specified with -shortname, SPFIX inserts the shortname as alias in FROM clauses. If the tablename is used as a column prefix in the query, SPFIX replaces the table name with the shortname. Thus, instruments.insid becomes ins.insid, if ins is the shortname for instruments. This usually improves readability a lot.

If you specify -cleanup, SPFIX also performs these additional changes.

Tabs are replaced with spaces assuming that the tab stop are in positions 9, 17, 25 etc. If the tab stops were intended to be elsewhere..., well tabs are only used by crippled and old ladies anyway.
Insert blank linkes before the keywords SELECT, INSERT, UPDATE, DELETE, BEGIN TRAN, COMMIT, IF and CREATE.
UPDATE...SET is split to be on different lines
SELECT...FROM is split to be on different lines.
Spaces are inserted after commas that are followed immediately by a non-blank character.

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