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