Example 1: OFS table with a PRIMARY INDEX clause
CREATE MULTISET TABLE Orders, STORAGE=TD_OFSSTORAGE, NO Fallback, MAP=TD_MAP1
( StoreNo SMALLINT
, OrderId INTEGER
, OrderDate DATE FORMAT 'YYYY-MM-DD’
, OrderTotal INTEGER
) PRIMARY INDEX (StoreNo, OrderId);
Example 2: OFS table with a PRIMARY INDEX and an ORDER BY clause
CREATE MULTISET TABLE Orders, STORAGE=TD_OFSSTORAGE, NO Fallback, MAP=TD_MAP1
( StoreNo SMALLINT
, OrderId INTEGER
, OrderDate DATE FORMAT 'YYYY-MM-DD’
, OrderTotal INTEGER
)
ORDER BY (OrderDate)
PRIMARY INDEX (StoreNo, OrderId);