-
Notifications
You must be signed in to change notification settings - Fork 0
DMSFile
DAT files are ASCII encoded files that contain the exported contents of PeopleSoft records.
The files use a unique encoding scheme in certain sections of the file.
This encoding can be found in generally 2 situations:
- Binary blobs
- Row data that is non-ascii
Throughout this wiki the use of the encoding scheme on a given element will be denoted by the use of an asterisk (*)
The DataMover DAT file format consists of 5 broad sections
- File Header
- TableSpace List
- Default DDLs*
- Export Blocks
- File Footer
This is a plain ascii section that consists of 7 lines which denote:
- DataMover Version
- System Endianess (LE or BE)
- PeopleSoft Base Language
- Database Name
- Export Start Time
Here is an example of this header:
SET VERSION_DAM 8.5:1:0
SET ENDIAN LE
SET BASE_LANGUAGE ENG
REM Database: DMODB
REM Started: Tue Feb 14 12:31:55 2016
EXPORT RECORD/SPACE.x
Immediately following the File Header is 1 to many tablespace entries. Each entry is a list of 3 values separated by commas. The 3 values denote the following:
- Table Space
- Database Name
- Unknown
This is a sample of what these look like:
EOEIAPP,PSPADMOO, EOECWRK,PSPADMO1, EOLARGE,PSPADMOC, PTRPTS,PSPTDMO, PTTREE,PSPTDMO, PTAUDIT,, EOIUAPP,PSPADMOO, PAPILRG,PSPADMOC, PTPRC,PSPTDMOT,
Bundled along side the exported data, is a copy of every DDL defined in the system. This information is stored in a binary block that is encoded. The format of this section is quite advanced and has been fully documented here
After the Default DDLs section comes the actual exported data. This occurs as zero to many Export Blocks. An export block is a mixture between ASCII markers and comma separated encoded blocks.
The format of these Export Blocks is documented here
The footer consists of a single line stating the end time of the export process.
REM Ended: Tue Feb 14 12:31:55 2016