Figure 21-2 shows the relationships between the host and server for a HiRDB single server configuration, and Figure 21-3 shows the relationships among hosts and servers for a HiRDB parallel server configuration.

Figure 21-2 Configuration for a HiRDB single server configuration

Figure 21-3 Configuration for a HiRDB parallel server configuration

There is a Japanese version (containing single-byte kana characters) and an English version of the sample files for table definitions and data loading. Unless Shift JIS is being used as the character encoding set, the English version should be used.

Table 21-5 lists the tables that are to be defined, Table 21-6 shows the English version of the column attributes and indexes.

All the tables presented here have the FIX attribute.

Table 21-5 Contents of tables to be defined

Table name	Contents	Number of rows
CUSTOM	Customer master	100#1
GOODS	Product master	100#1
VENDOR	Vendor master	50#1
TAKEODR	Orders received	--#2
STOCK	Stock	100
WAREHUS	Warehousing	--#2
SHIPMNT	Shipments	--#2
SENDODR	Orders placed	--#2
LAYIN	Purchasing	--#2

Legend:

--: Not applicable

#1: Data loading is not applicable in the English version.

#2: Data loading is not applicable in either the Japanese or the English version.

Table 21-6 Column attributes and indexes (English version)

Table name	Column name	Column attribute	Index name
CUSTOM	CUSTOM_CD	CHAR(5)	UNIQUE CLUSTER KEY CUSTOMX
	CUSTOM_NAME	CHAR(30)
	TELNO	CHAR(12)
	ZIPCD	CHAR(3)
	ADDRESS	CHAR(30)
GOODS	PRODUCT_CD	CHAR(6)	UNIQUE CLUSTER KEY GOODSX
	PRODUCT_NAME	CHAR(30)
	PRICE	DECIMAL(7,0)
	VENDOR_CD	CHAR(5)
VENDOR	VENDOR_CD	CHAR(5)	UNIQUE CLUSTER KEY VENDORX
	VENDOR_NAME	CHAR(30)
	TELNO	CHAR(12)
	ZIPCD	CHAR(3)
	ADDRESS	CHAR(30)
TAKEODR	ORDER_ACCEPTED_CD	CHAR(7)	CLUSTER KEY
	CUSTOM_CD	CHAR(5)
	PRODUCT_CD	CHAR(6)
	QUANTITY	DECIMAL(7,0)
	RESERVED_QUANTITY	DECIMAL(7,0)
	SURPLUS	DECIMAL(7,0)
	ORDER_ACCEPTED_DATE	CHAR(6)
	DELIVERY_DATE	CHAR(6)
STOCK	PRODUCT_CD	CHAR(6)
	STOCK	DECIMAL(7,0)
	RESERVED_QUANTITY	DECIMAL(7,0)
	ORDER	DECIMAL(7,0)
	VENDOR_CD	CHAR(5)
WAREHUS	PRODUCT_CD	CHAR(6)
	WAREHOUSE	DECIMAL(7,0)
	LAY_IN_NO	INTEGER
	WAREHOUSE_DATE	CHAR(6)
SHIPMNT	PRODUCT_CD	CHAR(6)
	SHIPMENT	DECIMAL(7,0)
	ORDER_ACCEPTED_CD	CHAR(7)
	ORDER_ACCEPTED_DATE	CHAR(6)
SENDODR	ORDER_NO	INTEGER	CLUSTER KEY SENDODRX
	VENDOR_CD	CHAR(5)
	PRODUCT_CD	CHAR(6)
	ORDER_QUANTITY	DECIMAL(7,0)
	ORDER_DATE	CHAR(6)
	DELIVERY_DATE	CHAR(6)
LAYIN	LAY_IN_NO	INTEGER	CLUSTER KEY LAYINX
	VENDOR_CD	CHAR(5)
	PRODUCT_CD	CHAR(6)
	LAY_IN_QUANTITY	DECIMAL(7,0)
	LAY_IN_DATE	CHAR(6)

Notes

The name of the table storage RDAREA is RDDATA10.

The name of the index storage RDAREA is RDINDX10.