In each case, for z/OS and UNIX client systems, the example presumes that a table named TranLogTable has been created on Teradata Database as follows:
CREATE TABLE TranLogTable
(TranDate Date,
Region Char(3),
CustNo Char(12),
OrderNo Char(6),
ProdCode Char(8),
Quantity Integer,
Price Integer)
Unique Primary Index(OrderNo, ProdCode);
The Windows examples are presented differently.