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 24-3 Configuration for HiRDB/Parallel Server
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 name | Contents | Number of rows |
---|---|---|
CUSTOM | Customer master | 1001 |
GOODS | Product master | 1001 |
VENDOR | Vendor master | 501 |
TAKEODR | Orders received | ![]() |
STOCK | Stock | 100 |
WAREHUS | Warehousing | ![]() |
SHIPMNT | Shipments | ![]() |
SENDODR | Orders placed | ![]() |
LAYIN | Purchasing | ![]() |
Table 24-5 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) |