24.2 System configuration and table definition information

Organization of this section
(1) System configuration
(2) Table definition information

(1) System configuration

Figure 24-2 shows the relationships between host and server for the HiRDB/Single Server, and Figure 24-3 shows the relationships among hosts and servers for the HiRDB/Parallel Server.

Figure 24-2 Configuration for HiRDB/Single Server

[Figure]

Figure 24-3 Configuration for HiRDB/Parallel Server

[Figure]

(2) Table definition information

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 24-4 lists the tables that are to be defined, Table 24-5 shows the English version of the column attributes and indexes.

All the tables presented here have the FIX attribute.

Table 24-4 Contents of tables to be defined

Table nameContentsNumber of rows
CUSTOMCustomer master1001
GOODSProduct master1001
VENDORVendor master501
TAKEODROrders received[Figure]2
STOCKStock100
WAREHUSWarehousing[Figure]2
SHIPMNTShipments[Figure]2
SENDODROrders placed[Figure]2
LAYINPurchasing[Figure]2
Legend:
[Figure]: 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 24-5 Column attributes and indexes (English version)

Table nameColumn nameColumn attributeIndex name
CUSTOMCUSTOM_CDCHAR(5)UNIQUE CLUSTER
KEY CUSTOMX
CUSTOM_NAMECHAR(30)
TELNOCHAR(12)
ZIPCDCHAR(3)
ADDRESSCHAR(30)
GOODSPRODUCT_CDCHAR(6)UNIQUE CLUSTER
KEY GOODSX
PRODUCT_NAMECHAR(30)
PRICEDECIMAL(7,0)
VENDOR_CDCHAR(5)
VENDORVENDOR_CDCHAR(5)UNIQUE CLUSTER
KEY VENDORX
VENDOR_NAMECHAR(30)
TELNOCHAR(12)
ZIPCDCHAR(3)
ADDRESSCHAR(30)
TAKEODRORDER_ACCEPTED_CDCHAR(7)CLUSTER KEY
CUSTOM_CDCHAR(5)
PRODUCT_CDCHAR(6)
QUANTITYDECIMAL(7,0)
RESERVED_QUANTITYDECIMAL(7,0)
SURPLUSDECIMAL(7,0)
ORDER_ACCEPTED_DATECHAR(6)
DELIVERY_DATECHAR(6)
STOCKPRODUCT_CDCHAR(6)
STOCKDECIMAL(7,0)
RESERVED_QUANTITYDECIMAL(7,0)
ORDERDECIMAL(7,0)
VENDOR_CDCHAR(5)
WAREHUSPRODUCT_CDCHAR(6)
WAREHOUSEDECIMAL(7,0)
LAY_IN_NOINTEGER
WAREHOUSE_DATECHAR(6)
SHIPMNTPRODUCT_CDCHAR(6)
SHIPMENTDECIMAL(7,0)
ORDER_ACCEPTED_CDCHAR(7)
ORDER_ACCEPTED_DATECHAR(6)
SENDODRORDER_NOINTEGERCLUSTER KEY
SENDODRX
VENDOR_CDCHAR(5)
PRODUCT_CDCHAR(6)
ORDER_QUANTITYDECIMAL(7,0)
ORDER_DATECHAR(6)
DELIVERY_DATECHAR(6)
LAYINLAY_IN_NOINTEGERCLUSTER KEY
LAYINX
VENDOR_CDCHAR(5)
PRODUCT_CDCHAR(6)
LAY_IN_QUANTITYDECIMAL(7,0)
LAY_IN_DATECHAR(6)
Notes
The name of the table storage RDAREA is RDDATA10.
The name of the index storage RDAREA is RDINDX10.