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-
