Goldstar Logo
Your Source for PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
+ Actian Zen v13
+ Actian PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve v12
+ Btrieve 6.15

+ Data Protection Products

+ Goldstar Software Services

+ Goldstar Software Tools

+ Other Solutions

AMS Users: Click Me Fix My PSQL License Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

Application Support for Descartes/IES



Software Vendor: Descartes / IES
Application Name: Several
Application Version: Air, Import, Export, etc.

The various applications from IES (now owned by Descartes) work on PSQL, and will properly function on versions up through and including PSQL v12.

Due to the use of the Clarion database development environment, and that environment's poor choice of using the record position to keep track of memo fields, issues can arise if the base tables (for any of the various MEMO fields) need to be rebuilt or recovered. A complete list of tables as of 2015 includes the following:

  • AII_IMEM.DAT (Base Table Unknown)
  • AII_PMEM.DAT (Base Table Unknown)
  • BODYMEM.DAT (Base Table BODY.DAT)
  • DENIEMEM.DAT (Base Table Unknown)
  • DOC_NMEM.DAT (Base Table Unknown)
  • EDI_TMEM.DAT (Base Table Unknown)
  • IMG_NMEM.DAT (Base Table Unknown)
  • INLANMEM.DAT (Base Table INLAND.DAT)
  • MISCMEM.DAT (Base Table MISC.DAT)
  • NONCLMEM.DAT (Base Table Unknown)
  • PO_SOMEM.DAT (Base Table Unknown)
  • SSLAYMEM.DAT (Base Table Unknown)

If you have a need to rebuild any of these base tables, please see the Goldstar tool FixMemo which can modify the record address pointers in the Memo file to point to the new base table record positions.

Important: IES users who are using the SQL/ODBC interface for reporting should ALSO be setting the UseBtrieveExcludeNullKey registry flag so that indices are not ignored. This String Value should be created in the location HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Relational Engine with a value of YES. The engine should then be restarted to ensure that it takes effect for all subsequent usage.

Important: We have seen some REALLY bad combinations of IES database files and DDF's. If you are using SQL and optimization is not working as expected, please use the DDF Builder to confirm that the DDF's you are using match your database files. If they do not, contact Descartes to obtain the latest DDF's that match your software version.

If you are a software vendor or user of this application and would like to add, remove, or modify the information on these pages, we'll be happy to oblige. Simply contact us directly!

  Copyright © 1997-2017, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 3007 Carmel Dr | Flossmoor IL 60422 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us