Skip to Content.
Sympa Menu

freetds - Re: need some help with freebcp

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Wilson, John" <John.Wilson AT Savvis.net>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: need some help with freebcp
  • Date: Wed, 23 Oct 2002 10:21:53 -0500


Bill,
Thanks...I have replicated the problem and have verified
that freebcp is not accepting NULL fields. BTW, I had
forgotten to put that info in the last email, the
varchar(255) and three floats allow NULL.


-----Original Message-----
From: Thompson, Bill D (London) [mailto:ThompBil AT exchange.uk.ml.com]
Sent: Wednesday, October 23, 2002 1:47 AM
To: TDS Development Group
Subject: [freetds] Re: need some help with freebcp


Hi John,

I have managed to reproduce your problem.

I defined the table you describe:

create table xxbcp
( col1 numeric(10,0),
col2 datetime,
col3 varchar(255),
col4 float,
col5 float,
col6 float,
col7 int)

I created a file of data using cut'n'paste from your mail.
I used <tab> column separators (as that is what is required with the -c
format of bcp) .
I noticed the data for the varchar(255) column was missing so I put 2 <tab>s
between the datetime value and the 1st float value (to indicate an empty
field).

Hey Presto! I got the same results.

I thought it might be the datetime format you used, so I changed it to one I
know works, but that made no difference.

Next I put a value into the varchar(255) column data, and It started
working!

So, It looks like we have a problem with empty column data.

Can you reproduce my results, and confirm I'm on the right track ?

I'll look into it in the meantime





Archive powered by MHonArc 2.6.24.

Top of Page