Elliott Database Naming Convention
Listed below is the standard Elliott database naming convention for current and future versions of Elliott:
- ELLIOTTDATA V7.X DDF
- ELIDATA V8.0-8.2 DDF
- ELI85DATA V8.5 DDF
- ELI90DATA V9.0
& after DDF
Standards for V8.5Beginning with Elliott V8.5, 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.
- ELI85DATA for Company 01 tables
- ELI85DATA02 for Company 02 tables
- ELI85DATA03 for Company 03 tables
These are the defaults. However, if your database is customized, a separate set of DDF and database names are created. Then you need to override the standard naming assumption by Elliott in EL850.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-DSN entries do not have to be present in EL850.CFG. When they are not present, the default database names (ELIROOT and ELI85DATA ...etc.) are assumed.
The main change in Elliott 8.5 DDFs is that all Elliott document numbers are assumed to be in String format where alphabetic values can be stored. In addition, we added the ELIROOT convention to support the root directory database files in order for the new Report Desk to function. Additionally, we now have added various NSCTLFIL_9999 table definition so you can access each NSCTLFIL record with proper column definitions.