Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 219 / 536

CHAPTER 5 Moving Data In and Out of Databases
199
2 For the second and any subsequent partial-width inserts for the same set of
rows, use the
START ROW ID
option to specify the row where the insert
started. This number is the record number at the beginning of the insert
message log, as in this example:
In table ’department’, the full width insert of 3
columns
will begin at record 1.
You can also use the ROWID function to display the row ID, as in the following
query:
SELECT *, ROWID( table_name) FROM table_name
Example 1 The UNIX example below shows an incorrect insertion of four columns from
the file tt.t into the indexes on the
lineitem
table. It inserts the first two columns
with one
LOAD TABLE
statement and the second two columns with another
LOAD TABLE
statement, but does not use the
START ROW ID
option to align the
additional columns.
LOAD TABLE lineitem
(l_partkey ASCII(4),
l_suppkey ASCII(4),
FILLER(13))
FROM ’/d1/MILL1/tt.t’
PREVIEW ON
NOTIFY 1000
LOAD TABLE lineitem
(FILLER(8),
l_quantity ASCII(6),
l_orderkey ASCII(6),
FILLER(1))
FROM ’/d1/MILL1/tt.t’
PREVIEW ON
NOTIFY 1000
The result of the
SELECT
statement below shows that 10 rows are stored
instead of the correct number of 5.
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