PSQL Database Names And DDF Convention

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

Beginning 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.
  • DDF: <ElliottRoot>\Bin\DDFROOT
  • Data: <ElliottRoot>
  • ELIDATA                 for Company 01 tables
  • DDF: <ElliottRoot>\Bin\DDF40
  • Data: <ElliottRoot>\Data
  • ELIDATA02             for Company 02 tables
  • ELIDATA03             for Company 03 tables
  • etc.

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:

  • [DatabaseName]:
  • Server=TS4
  • Root=XXXROOT
  • Company01=XXXDATA
  • Company02=XXXDATA02
  • 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 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.

JEG


Feedback and Knowledge Base