db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tom Deering <tomdeeri...@gmail.com>
Subject Custom Bulk Import from CSV
Date Mon, 05 Nov 2012 15:19:53 GMT
I have a table that has the following columns:

INTEGER A, INTEGER B, DATE C, FLOAT D, FLOAT E, FLOAT F, FLOAT G, INTEGER
H, FLOAT I
A is my primary, auto-generated key
B is a foreign key referencing the primary key of another table.

I have a csv file containing many rows of data for columns C - I that I
would like to import with "CALL SYSCS_UTIL.SYSCS_IMPORT_DATA". All rows of
the csv file correspond to the same value for B. If be is left unspecified,
then I get:

Column 'B'  cannot accept a NULL value.

QUESTION: How can I bulk-import the data for columns C - I while specifying
the use of the same value for column B?

Thanks in advance.

-Tom-

Mime
View raw message