Very Computer

On linux command line, bcp is ok.

Quote:> bcp ndb..mytable in /tmp/nw.txt -c -t  '='  -Uuser -Ppassword

1006 rows copied.
Clock Time (ms.): total = 1000  Avg = 0 (1006.00 rows per sec.)

but failed inside perl progarm when using

system("bcp ndb..mytable in /tmp/nw.txt -c -t  '='  -Uuser
-Ppassword").  Here is the message:

bcp ndb..mytable in /tmp/nw.txt -c -t '='  -Uuser -Ppassword

Starting copy...
Unexpected EOF encountered in BCP data-file.
Unexpected EOF encountered in BCP data-file.
bcp copy in partially failed

Any idea would be very much appreciated.

David

Hi,

if you don't have blobs in your database you should try to skip the '-t' flag. Otherwise you should try to create a format file.

Frank

  On linux command line, bcp is ok.
  > bcp ndb..mytable in /tmp/nw.txt -c -t  '='  -Uuser -Ppassword

  Starting copy...
  1000 rows sent to SQL Server.

  1006 rows copied.
  Clock Time (ms.): total = 1000  Avg = 0 (1006.00 rows per sec.)

  but failed inside perl progarm when using

  system("bcp ndb..mytable in /tmp/nw.txt -c -t  '='  -Uuser -Ppassword").  Here is the message:

  bcp ndb..mytable in /tmp/nw.txt -c -t '='  -Uuser -Ppassword

  Starting copy...
  Unexpected EOF encountered in BCP data-file.
  Unexpected EOF encountered in BCP data-file.
  bcp copy in partially failed

  Any idea would be very much appreciated.

  David