DBHTML Sample Output

This is a sample output page from DBHTML. The entire page (after the first horizontal line below) was generated automatically by DBHTML. The majority of the information is extracted from an IMAGE database root file, and the rest comes from an optional documentation file specified by the user (e.g., the sections labelled "Documentation").
(Back to DBHTML product page)

---

IMAGE/SQL Database

DBSAMP

• Datasets Summary (Datasets Documentation)
• Passwords
• Items (Items Documentation)
• Datasets
• Miscellaneous Documentation

---

Root file information:

• Root version: C2; status = FW.
  
• $control blockmax = 1151

---

Datasets Summary:

Dataset	Doc	Set Type	# Fields	# Paths	Media bytes	Entry bytes	Capacity	#Entries	% Full	# Sectors	BlkFac	Flags
MISC	(doc)	Detail	4	-	22	22	208	23	11%	32	104
CUSTOMER-NUMBERS	(doc)	Auto	1	1	30	8	101	8	7%	32	76
SALES	-	Detail	3	1	64	56	80,011	76,149	95%	20,656	31

(top, Datasets Summary, Datasets, Datasets Documentation , Items, Items Documentation, Passwords, Miscellaneous Documentation)

---

Passwords:

• 1 PASS...;
• 2 MIRIAM;
• 63 VITALINO;

(top, Datasets Summary, Datasets, Datasets Documentation, Items, Items Documentation, Passwords, Miscellaneous Documentation)

---

Items:

Item Name	Doc	Item Type	Item Security	Sets Using Item
QUANTITY	(doc)	I1	(63 / 1, 2 )	SALES
CLERK	(doc)	X4	(63 / 1, 2 )	MISC
SALE-LOCATION	-	X46	( / 1, 2 )	SALES
CLERK#	-	X8	(63 / 1, 2 )	MISC
DESCRIPTION	-	X8	(63 / 1, 2 )	MISC
DOLLARS	-	I1	(63 / 1, 2 )	MISC
CUSTOMER#	-	X8	( / 1, 2 )	CUSTOMER-NUMBERS (key), SALES (search)

(top, Datasets Summary, Datasets, Datasets Documentation, Items, Items Documentation, Passwords, Miscellaneous Documentation)

---

Datasets:

---

• name: MISC, Detail (63 / 1, 2 ); (doc)
  entry:
  

  Item	Item Type	Byte Offset	# Bytes
  CLERK#	X8	0	8
  DESCRIPTION	X8	8	8
  DOLLARS	I1	16	2
  CLERK	X4	18	4

  
  capacity: 208 entries; block factor: 104; entry size: 22; 11% full.
  

(top, Datasets Summary, Datasets, Datasets Documentation, Items, Items Documentation, Passwords, Miscellaneous Documentation)

---

• name: CUSTOMER-NUMBERS, Automatic ( / 1, 2 ); (doc)
  entry:
  

  Item	Item Type	Byte Offset	# Bytes
  CUSTOMER# (1)	X8	0	8

  
  paths:
  
  • path #1 to SALES.CUSTOMER#
  
  capacity: 101 entries; block factor: 76; entry size: 8; 7% full.
  

(top, Datasets Summary, Datasets, Datasets Documentation, Items, Items Documentation, Passwords, Miscellaneous Documentation)

---

• name: SALES, Detail ( / 1, 2 );
  entry:
  

  Item	Item Type	Byte Offset	# Bytes
  QUANTITY	I1	0	2
  CUSTOMER# ( CUSTOMER-NUMBERS)	X8	2	8
  SALE-LOCATION	X46	10	46

  
  paths:
  
  • path #1 to CUSTOMER-NUMBERS from CUSTOMER#
  
  capacity: 80,011 entries; block factor: 31; entry size: 56; 95% full.
  

(top, Datasets Summary, Datasets, Datasets Documentation, Items, Items Documentation, Passwords, Miscellaneous Documentation)

---

Datasets Documentation:

---

MISC
this is set MISC, a set of no particular value.

---

CUSTOMER-NUMBERS
this is set CUSTOMER-NUMBERS, a BOLD set.
this is more text
this is the last line of text for CUSTOMER-NUMBERS

---

SALES
(no documentation available for set)
(top, Datasets Summary, Datasets, Datasets Documentation, Items, Items Documentation, Passwords, Miscellaneous Documentation)

---

Items Documentation:

---

QUANTITY
this is QUANTITY, an I1 item. this is the last line of text for item I1

---

CLERK
this is CLERK, of which we know nothing

---

SALE-LOCATION
(no documentation available for item)

---

CLERK#
(no documentation available for item)

---

DESCRIPTION
(no documentation available for item)

---

DOLLARS
(no documentation available for item)

---

CUSTOMER#
(no documentation available for item)
(top, Datasets Summary, Datasets, Datasets Documentation, Items, Items Documentation, Passwords, Miscellaneous Documentation)

---

Miscellaneous Documentation:

this is where you might put database general comments.

this is a link to Allegro.
(top, Datasets Summary, Datasets, Datasets Documentation, Items, Items Documentation, Passwords, Miscellaneous Documentation)

---

HTML generated 2003-03-19 14:49:57.3 by DBHTML from Allegro Consultants, Inc.

---

/* dataset: MISC, Detail */
struct {                                           /* offset  #bytes */
   char                 CLERK_number          [ 8];    /*  0 :  8 */
   char                 DESCRIPTION           [ 8];    /*  8 :  8 */
   int16                DOLLARS;                       /* 16 :  2 */
   char                 CLERK                 [ 4];    /* 18 :  4 */
   } set_MISC;   /* #bytes: 22 */
/*********************************************/

---

/* dataset: CUSTOMER-NUMBERS, Automatic */
struct {                                           /* offset  #bytes */
   syn_chain_type       synchain;                      /*  0 : 10 */
   path_header_type     path_1;                        /* 10 : 12 */
   char                 CUSTOMER_number       [ 8];    /* 22 :  8 */
   } set_CUSTOMER_NUMBERS;   /* #bytes: 30 */
/*********************************************/

---

/* dataset: SALES, Detail */
struct {                                           /* offset  #bytes */
   path_ptrs_type       path_1;                        /*  0 :  8 */
   int16                QUANTITY;                      /*  8 :  2 */
   char                 CUSTOMER_number       [ 8];    /* 10 :  8 */
   char                 SALE_LOCATION         [46];    /* 18 : 46 */
   } set_SALES;   /* #bytes: 64 */
/*********************************************/