The RDAREA storage unit depends on the data type of the columns that constitute the table. The explanations below are based on the example of a STAFF_TABLE table that consists of EMPLOYEE_NUMBER, DOCUMENT_DATA (LOB data), and abstract data type t_EMPLOYEE. For a table containing abstract data type columns, the portion without the abstract data type columns is called the abstract data type column structure base table.
Specification of storage conditions:
CREATE TABLE STAFF_TABLE
(EMPLOYEE_NUMBER CHAR(6),
DOCUMENT_DATA BLOB(64K) IN ((LOBAREA01),(LOBAREA02)),
EMPLOYEE t_EMPLOYEE ALLOCATE(ID_PHOTO
IN ((LOBAREA03),(LOBAREA04)))
)IN ((RDAREA01)EMPLOYEE_NUMBER<=700000,(RDAREA02));
Specification of boundary value:
CREATE TABLE STAFF_TABLE
(EMPLOYEE_NUMBER CHAR(6),
DOCUMENT_DATA BLOB(64K) IN ((LOBAREA01),(LOBAREA02)),
EMPLOYEE t_EMPLOYEE ALLOCATE(ID_PHOTO
IN ((LOBAREA03),(LOBAREA04)))
)PARTITIONED BY EMPLOYEE_NUMBER
IN ((RDAREA01)800000,(RDAREA02));
CREATE TABLE STAFF_TABLE
(EMPLOYEE_NUMBER CHAR(6),
DOCUMENT_DATA BLOB(64K) IN ((LOBAREA01),(LOBAREA02)),
EMPLOYEE t_EMPLOYEE ALLOCATE(ID_PHOTO
IN ((LOBAREA03),(LOBAREA04)))
)[FIX]# HASH HASH6 BY EMPLOYEE_NUMBER
IN (RDAREA01,RDAREA02);