DB2 import

[Ricardo]

Hi!
I'm new in DB2 and I was trying to import some data to a table from an
ASCII file, just to practise. This file has only ttwo columns, and
they are separated by tabs. The syntax I'm using is the following:

"db2 import from languages.TXT of DEL INSERT into OPTLANGUAGES"

And this is the response fron DB2:

--SQL3109N The utility is beginning to load data from file
"languages.TXT".

--SQL3120W The field value in row "1" and column "1" cannot be
converted to an
--INTEGER value, but the target column is not nullable. The row was
not loaded.

--SQL3120W The field value in row "2" and column "1" cannot be
converted to an
--INTEGER value, but the target column is not nullable. The row was
not loaded.

--SQL3120W The field value in row "3" and column "1" cannot be
converted to an
--INTEGER value, but the target column is not nullable. The row was
not loaded.

--SQL3120W The field value in row "4" and column "1" cannot be
converted to an
--INTEGER value, but the target column is not nullable. The row was
not loaded.

--SQL3120W The field value in row "5" and column "1" cannot be
converted to an
--INTEGER value, but the target column is not nullable. The row was
not loaded.

--SQL3110N The utility has completed processing. "5" rows were read
from the
--input file.

--SQL3221W ...Begin COMMIT WORK. Input Record Count = "5".

--SQL3222W ...COMMIT of any database changes was successful.

--SQL3149N "5" rows were processed from the input file. "0" rows
were
--successfully inserted into the table. "5" rows were rejected.

--Number of rows read = 5
--Number of rows skipped = 0
--Number of rows inserted = 0
--Number of rows updated = 0
--Number of rows rejected = 5
--Number of rows committed = 5

Does anybody knows what I'm doing wrong???
Thank you very much in advance!!!!

[Gert van der Kooij]

In article <c28bcaa1.02112...@posting.google.com>,
rga...@parsec.es says...

> Hi!
> I'm new in DB2 and I was trying to import some data to a table from an
> ASCII file, just to practise. This file has only ttwo columns, and
> they are separated by tabs. The syntax I'm using is the following:
>
> "db2 import from languages.TXT of DEL INSERT into OPTLANGUAGES"
>

Adding the option 'modified bu coldelx09' might help, check the
Command Reference for a full description.

[Mairhtin O'Feannag]

What does the data in the file look like? If it's only 5 rows of two
columns, perhaps you can cut and paste it here?

Basically, the data SHOULD look like 5 tab 'some value if alpha'

if the second column is alphanumeric data.

Mairhtin

rga...@parsec.es (Ricardo) wrote in news:c28bcaa1.0211250133.1f2513e0
@posting.google.com: