Sybase 12.4.2 manual Start ROW ID option in the second Load Table statement, 200

Partial-width insertions

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

200