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