i have some data like this:
1|2|3
a|b|c
---------------
db2 => create table test (field1 char(1),field2 char(1),field3 char(1))
db2 => import from test.txt of del modified by coldel| insert into test
---------------
but ,i got messages:
--------------------------------
SQL3109N The utility is beginning to load data from file "test.txt".

SQL3017N A delimiter is not valid or is used more than once.

SQL3110N The utility has completed processing. "0" rows were read from the
input file.
--------------------------------
who can help to solve this .
thanks.

I tested the scenario, both from command interface and input file = ok
check the input file - try to put the commands in a file and execute with
db2 -tvf infile