Sybase 12.4.2 User Manual

Page 219

Advertising

CHAPTER 5 Moving Data In and Out of Databases

199

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

Advertising