Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Wink Unanswered: import problem--SQL3017N

    i have some data like this:
    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 .

  2. #2
    Join Date
    Nov 2004


    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
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts