Filter
Top Products
Partial-width insertions
200
NULL 3 28 NULL 3
NULL 4 13 NULL 4
NULL 5 9 NULL 5
190 NULL NULL 19 6
215 NULL NULL 2127 7
29 NULL NULL 1376 8
200 NULL NULL 119 9
59 NULL NULL 4 10
(10 rows affected)
Example 2
The following example shows the correct way to do this operation. Note the
START ROW ID option in the second LOAD TABLE statement.
LOAD TABLE lineitem
(l_partkey ASCII(4),
l_suppkey ASCII(4),
FILLER(13))
FROM ’/d1/MILL1/tt.t’
PREVIEW ON
NOTIFY 1000
SELECT *, rowid(lineitem) FROM lineitem
l_orderkey l_partkey l_suppkey l_quantity rowid(lineitem)
---------- --------- --------- ---------- ---------------
NULL 1 12 NULL 1
NULL 2 37 NULL 2
NULL 3 28 NULL 3
NULL 4 13 NULL 4
NULL 5 9 NULL 5
(5 rows affected)
LOAD TABLE lineitem
(FILLER(8),
l_quantity ASCII(6),
l_orderkey ASCII(6),
FILLER(1))
FROM ’/d1/MILL1/tt.t’
PREVIEW ON
NOTIFY 1000
START ROW ID 1
SELECT *, rowid(lineitem) FROM lineitem
l_orderkey l_partkey l_suppkey l_quantity rowid(lineitem)
---------- ---------- ---------- ----------- ---------------
190 1 12 19 1
215 2 37 2127 2