PSQL Database Naming Convention for 8.5 Databases

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.5

Beginning 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.
  • DDF: <ElliottRoot>\Bin85\DDFROOT
  • Data: <ElliottRoot>
  • ELI85DATA             for Company 01 tables
  • DDF: <ElliottRoot>\Bin85\DDF40
  • Data: <ElliottRoot>\Data
  • ELI85DATA02         for Company 02 tables
  • ELI85DATA03         for Company 03 tables
  • etc.

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:

  • [Database]:
  • Server=TS4
  • Root=XXXROOT
  • Company01-DSN=XXX85DATA
  • Company02-DSN=XXX85DATA02
  • etc.

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.

Create Elliott 8.5 Databases by Using EL850DB.EXE Utility

You can create Elliott 8.5 Databases with the standard naming convention by using the EL850DB.EXE utility. Please refer to the following KB article for more detail:

Feedback and Knowledge Base