Product Documentation

ODBC - c-tree Plus Edition

Previous Topic

Next Topic

Tutorial File Layout

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.

TOCIndex