The Tutorial uses the following four data files and six indices:
Data File |
Symbolic Index Name |
Key Segment(s) |
Unique |
---|---|---|---|
custmast.dat |
cm_custnumb_idx |
cm_custnumb |
yes |
itemmast.dat |
im_itemnumb_idx |
im_itemnumb |
yes |
custordr.dat |
co_ordrnumb_idx |
co_ordrnumb |
yes |
custordr.dat |
co_custnumb_idx |
co_custnumb |
no |
ordritem.dat |
oi_ordrnumb_idx |
oi_ordrnumb, oi_seqnumb |
yes |
ordritem.dat |
oi_itemnumb_idx |
oi_itemnumb |
no |
Note: The unique column indicates if the index accepts duplicate data values.
custmast.dat, the Customer Master File, contains the table CUSTOMERS made up of the fields shown below:
Symbolic Name |
Field Description |
Field Type |
Field Length |
---|---|---|---|
cm_custnumb |
Customer number |
CT_STRING |
5 |
cm_custzipc |
Customer zip code |
CT_STRING |
10 |
cm_custstat |
Customer state |
CT_STRING |
3 |
cm_custratg |
Customer rating |
CT_STRING |
2 |
cm_custname |
Customer name |
CT_STRING |
48 |
cm_custadrs |
Customer address |
CT_STRING |
48 |
cm_custcity |
Customer city |
CT_STRING |
48 |
itemmast.dat, the Item Master File, contains the table ITEMS made up of the fields shown below:
Symbolic Name |
Field Description |
Field Type |
Field Length |
---|---|---|---|
im_itemwght |
Item weight |
CT_INT4 |
4 |
im_itempric |
Item price |
CT_MONEY |
4 |
im_itemnumb |
Item number |
CT_STRING |
6 |
im_itemdesc |
Item description |
CT_STRING |
48 |
custordr.dat, the Customer Order File, contains the table ORDERS made up of the fields shown below:
Symbolic Name |
Field Description |
Field Type |
Field Length |
---|---|---|---|
_o_delflag |
Order delete flag |
CT_INT4 |
4 |
co_ordrdate |
Order date |
CT_DATE |
4 |
co_promdate |
Order promise date |
CT_DATE |
4 |
co_ordrnumb |
Order number |
CT_STRING |
7 |
co_custnumb |
Customer number |
CT_STRING |
5 |
ordritem.dat, the Order Item File, contains the table ORDER_DETAIL made up of the fields shown below:
Symbolic Name |
Field Description |
Field Type |
Field Length |
---|---|---|---|
_i_delflag |
Order item delete flag |
CT_INT2 |
2 |
oi_seqnumb |
Order item stock number |
CT_INT2 |
2 |
oi_quantity |
Order item quantity |
CT_INT2 |
2 |
oi_ordrnumb |
Order item number |
CT_STRING |
7 |
oi_itemnumb |
Item number |
CT_STRING |
6 |
Note: The fields beginning with “_”, _o_delflag and _i_delflag, are hidden fields and will not be displayed. Developers looking for more information on other field options should refer to Section 1.5 Field Options in c-tree Driver Developer’s Guide.