SY0DD2 SQL Data Dictionary Build Specifications (SY0DD2_DataDictionaryBuildSpecsLevel: 4.40
        Record Type: A    SQL Table Name and Information                         08/28/2009
 
 File Type: Direct   Key Size: 7    Rec Len: 8000    Min Len: 0      Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 MAS90 File Name . . . . . . . . . . . . FileName. . . . . . . . . . . String      *(1,6)
 Record Flag "A"                   A2KEY$RecordFlag. . . . . . . . . . String      *(7,1)
 SQL Table Name                    A2NAM$. . . . . . . . . . . . . . . String      (1,64)
 Table Description                 A2DSC$. . . . . . . . . . . . . . . String      (1,40)
 File Type                         A2TYP$. . . . . . . . . . . . . . . String      (1,1)
 Define File?                      A2DEF$. . . . . . . . . . . . . . . Yes/No      (1,1)
 Create Table in SYSTEM DB?        A2SYS$. . . . . . . . . . . . . . . Yes/No      (1,1)
 Header File: Linked File Name     A2HNM$. . . . . . . . . . . . . . . String      (1,6)
 Header File: Linked Field Index   A2HID$. . . . . . . . . . . . . . . String      (1,6)
 Multikey Structure (Pvx Format)   A2MKY$. . . . . . . . . . . . . . . String      (1,320)
 Key Size                           A2KSZ. . . . . . . . . . . . . . . Number      [0]       2.0
 Record Size                        A2RSZ. . . . . . . . . . . . . . . Number      [1]       4.0
 Minimum Record Size                A2RMN. . . . . . . . . . . . . . . Number      [2]       4.0
                                                                                   ________
                                                                      Total Bytes  475
 

 SY0DD2 SQL Data Dictionary Build Specifications (SY0DD2_DataDictionaryBuildSpecsLevel: 4.40
        Record Type: B    SQL Create Table Command                               08/28/2009
 
 File Type: Direct   Key Size: 7    Rec Len: 8000    Min Len: 0      Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 MAS90 File Name . . . . . . . . . . . . FileName. . . . . . . . . . . String      *(1,6)
 Record Flag "B" (EFG)             B2KEY$RecordFlag. . . . . . . . . . String      *(7,1)
 SQL Create Table Command          B2TBL$. . . . . . . . . . . . . . . String      (1,7980)
   NOTE:  If needed, keys E/F/G are used . . . . . . . . . . . . . . . Memo
   store more of the create table stateme. . . . . . . . . . . . . . . Memo
                                                                                   ________
                                                                      Total Bytes  7990
 

 SY0DD2 SQL Data Dictionary Build Specifications (SY0DD2_DataDictionaryBuildSpecsLevel: 4.40
        Record Type: C    SQL Create Index Commands                              08/28/2009
 
 File Type: Direct   Key Size: 7    Rec Len: 8000    Min Len: 0      Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 MAS90 File Name . . . . . . . . . . . . FileName. . . . . . . . . . . String      *(1,6)
 Record Flag "C" (HIJ)             C2KEY$RecordFlag. . . . . . . . . . String      *(7,1)
 SQL Create Index Command          C2IDX$. . . . . . . . . . . . . . . String      (1,7980)
   NOTE:  Multiple indices may exist in. . . . . . . . . . . . . . . . Memo
   the C2IDX$ string, separated by tildes. . . . . . . . . . . . . . . Memo
   NOTE:  If needed, keys H/I/J are used . . . . . . . . . . . . . . . Memo
   store more of the create index stateme. . . . . . . . . . . . . . . Memo
                                                                                   ________
                                                                      Total Bytes  7990
 

 SY0DD2 SQL Data Dictionary Build Specifications (SY0DD2_DataDictionaryBuildSpecsLevel: 4.40
        Record Type: D    Prefix String                                          08/28/2009
 
 File Type: Direct   Key Size: 7    Rec Len: 8000    Min Len: 0      Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 MAS90 File Name . . . . . . . . . . . . FileName. . . . . . . . . . . String      *(1,6)
 Record Flag "D" (KLM)             D2KEY$RecordFlag. . . . . . . . . . String      *(7,1)
 PREFIX String                     D2PFX$. . . . . . . . . . . . . . . String      (1,7980)
   NOTE:  If needed, keys K/L/M are used . . . . . . . . . . . . . . . Memo
   to store more of the prefix string. . . . . . . . . . . . . . . . . Memo
                                                                                   ________
                                                                      Total Bytes  7990