Displaying the File Directory Table

How to:

Reference:

The ? FDT command displays the file directory table, which lists the physical characteristics of a FOCUS data source.

Each segment and index (those fields designated by the keyword FIELDTYPE=I in the Master File) occupies an integral number of pages. The file directory table shows the amount of space occupied by each segment instance in a page, the starting and ending page numbers, and the number of pages in between for each segment and index.

Syntax: How to Display a File Directory Table

? FDT filename

where:

filename

Is the name of the data source.

Example: Displaying a File Directory Table

Issuing the command

? FDT EMPLOYEE

produces the following information:

   DIRECTORY:C:\ibi\WEBFOCUS\...\employee.foc ON 09/25/2006 AT 09.50.28 DATE/TIME OF LAST CHANGE: 03/30/2005 16.19.22 SEGNAME LENGTH PARENT START END PAGES LINKS TYPE 1 EMPINFO 22 1 1 1 6 2 FUNDTRAN 10 1 2 2 1 2 3 PAYINFO 8 1 3 3 1 3 4 JOBSEG 11 3 4 5 SECSEG 4 4 2 6 SKILLSEG 11 4 2 7 ADDRESS 19 1 4 4 1 2 8 SALINFO 6 1 5 5 1 3 9 DEDUCT 5 8 6 8 3 2 10 ATTNDSEG 7 1 3 11 COURSEG 11 10 2

Reference: ? FDT Query Information

The following information is listed in the file directory table:

SEGNAME

Is the name of each segment in the file. The segments are also numbered consecutively down the left of the table. Unnumbered entries at the foot of the table are indexes, which belong to fields having the attribute FIELDTYPE=I in the Master File.

LENGTH

Is the length in words (units of four bytes) of each segment instance. Divide this number into 992 to get the number of instances that fit on a page.

PARENT

Is the parent segment. Each number refers to a segment name in the SEGNAME column.

START

Is the page number on which the segment or index begins.

END

Is the page number on which the segment or index ends.

PAGES

Is the number of pages occupied by the segment or index.

LINKS

Is the length, in words, of the pointer portion in each segment instance. Every segment instance consists of two parts, data and pointers. Pointers are internal numbers used to find other instances.

TYPE

Is the type of index. NEW indicates a binary index. OLD indicates a hash index. Segments of type KU, LM, DKU, DKM, KL, and KLU are not physically in this file. Therefore, this information is omitted from the table.