README-File for changes to static Operator information in M4
============================================================

Name of this file: README.txt
Directory for this file: .../MiningMart/m4install

This readme file describes how to make changes to the Operators.sql file
which is needed to insert static operator information into an M4 schema.

Add new or updated entries for operators to the file "constraints.txt"
found in this directory. Use the placeholders for M4 Ids 
as exemplified in that file.

Then call the Java program FortlaufendeIDs from the command line 
(make sure Java is installed and the file "FortlaufendeIDs.class"
is in this directory):

java -cp . FortlaufendeIDs constraints.txt 500 ausgabe.txt

The number 500 gives the lowest M4 ID which will be given to
a table entry. Any number higher than 50 or so can be used.

The command above will create a file "ausgabe.txt" which can be used to 
install the operators into an M4 schema. The file "ausgabe.txt"
corresponds to "Operators.sql" which is found both in the oracle and 
postgres subdirectory.

Copy "ausgabe.txt" to the two directories and rename it to "Operators.sql"
(overwriting the previous versions of "Operators.sql"). In the Oracle version,
you should add two lines to the end of "Operators.sql": 

commit;
exit;

This makes the M4 installation script run smoothly on to the next task after
it has executed "Operators.sql". For the postgres version this is not needed.

If you are a MiningMart developer, remember to check the new files into the 
CVS repository.

Finally, use the SQL script "replace_operators.sql" (available both
in the oracle and postgres subdirectory), which can be called from 
the SQL command line interpreter, to update the information in your
M4 schema.