File functions enable an application to use predefined report scripts, data files and calculation scripts against the active database. There are also functions for importing and exporting data to and from both text and binary files.
| Function | Description |
|---|---|
| EssArchiveBegin | Prepares database for archive by setting READ-ONLY status. |
| EssArchiveEnd | After archive, returns database status to READ-WRITE. |
| EssCalcFile | Executes a calc script against the active database from a file. |
| EssExport | Exports data from the current database to a text file. |
| EssImport | Imports data from text files and other sources to the current database. |
| EssImportASO | Imports data from different sources to an aggregate storage database. |
| EssListDbFiles | Retrieves information on specified index and data files |
| EssReportFile | Sends a report specification to the active database from a file. |
| EssSetDefaultCalcFile | Sets the default calc script for the active database from a calc script file. |
| EssUpdateFile | Sends an update specification to the active database from a file. |
| EssUpdateFileEx | Sends an update specification to the active database from a file, capturing any data load errors. |
| EssUpdateFileASO | Sends an update specification to the active aggregate storage database from a file. |
| EssUpdateFileASOEx | Sends an update specification to the active aggregate storage database from a file, capturing any data load errors. |
| EssUpdateFileUTF8ASO | Sends an update specification to the active aggregate storage database from a UTF-8-encoded file. |
| EssUpdateFileUTF8ASOEx | Sends an update specification to the active aggregate storage database from a UTF-8-encoded file, capturing any data load errors. |
| EssUpdateFileUtf8Ex | Sends an update specification to the active database from a UTF-8-encoded file, capturing any data load errors |
| EssDisplayTriggers | Returns a list of all triggers associated with a database. |
| EssMdxTrig | Manipulates triggers based on the operations contained in an MDX language file. |
| EssListSpoolFiles | Returns a list of all the spool files associated with a database. |
| EssGetSpoolFile | Returns a specific spool file associated with a database. |
| EssDeleteAllSplFiles | Deletes all the spool files associated with a database. |
| EssDeleteSplFile | Deletes a specific spool file. |