Current & Future Database Naming Standards
Listed below is the current and future naming convention for PSQL Control Center database names:
- ELLIOTTDATA V7.X DDF
- ELIDATA V8.x DDF
- ELI90DATA V9.0
& after DDF
Standards for V8.3Beginning with Elliott V8.3, it is necessary to associate the database names in PSQL Control Center to the Company data directories. They will default as follows:
- ELIROOT for tables in the root directory, this is needed for the new report writer in 8.3.
- ELIDATA for Company 01 tables
- ELIDATA02 for Company 02 tables
- ELIDATA03 for Company 03 tables
These are the defaults. However, if your database is customized and a separate set of DDF and database names are created. Then you be override the standard naming assumption by Elliott in EL800.CFG file. For example, you may add a section as follows:
The Server entry is required for using new Report Writer. It is used to construct the connection strings to the databases.
The Root and Companynn entries do not have to be present in EL800.CFG. When they are not present, the default database names (ELIROOT and ELIDATA ...etc.) are assumed.
The main changes of Elliott 8.3 DDF is we added the ELIROOT convention to support the root directory database files in order for the new report writer to function. In addition, Elliott 8.3 DDF add the required report writer tables in the ELIDATA database. Another big area of changes, we now added various NSCTLFIL_9999 table definition so you can access each NSCTLFIL records with proper column definition.