[freetds] Problem with freebcp and fixed text output [NC]
Konrad J Hambrick
konrad at payplus.com
Thu Aug 6 17:56:33 EDT 2009
oops.
sorry for the self-followup ..
I believe it also needs at least an empty ("") Column Name
in the FORMAT File, column 7.
Starting with Version 8.0, I believe BCP.EXE also requires
a collation in column 8. Again an empty string is OK ...
-- kjh
Konrad J Hambrick wrote:
> Hmmm ...
>
> Does the FORMAT file not need an explicit 0 (zero)
> in Column 6 of the 2nd row of the FORMAT file to
> skip DB Table Column 2 ?
>
> I believe this is so in MS SQLServer.
>
> -- kjh
>
>
> Cedric ROUVRAIS wrote:
>> Hi,
>>
>> Say you have a file with 100 columns and a table with 10 colums (case for
>> one of our apps), how do you selectively bcp in the file? With Sybase you
>> simply do not specify TAB_COLNUM and that column in the file is ignored.
>>
>> Sample format file (incomplete)
>>
>> 10.0
>> 182
>> 1 SYBCHAR 0 20 ";" 1 id
>> 2 SYBCHAR 0 20 ";"
>> 3 SYBCHAR 0 20 ";" 2 gop
>>
>> freebcp chokes on the second column (2 SYBCHAR 0 20 ";") and exits whereas
>> Sybase knows that it just needs to ignore this data, so I am modifying
>> bcp.c to accomodate this behaviour.
>>
>> If I understand what you mean
>>
>> 2 SYBCHAR 0 20 ";" 0
>>
>> would be the appropriate format file and then freebcp would ignore this
>> field but still bcp the file in?
>>
>> a++ Cedric
>>
>>
>>
>> |------------------------------
>> | "James K. Lowden"
>> | <jklowden at freetds
>> | .org>
>> | Sent by:
>> | freetds-bounces at l
>> | ists.ibiblio.org
>> |
>> |
>> | 08/06/2009 05:39
>> | PM
>> |
>> |
>> | Please respond to
>> | FreeTDS
>> | Development Group
>> | <freetds at lists.ib
>> | iblio.org>
>> |
>> |
>>
>>
>> To
>> FreeTDS Development Group
>> <freetds at lists.ibiblio.org>
>> cc
>>
>> Subject
>> Re: [freetds] Problem with
>> freebcp and fixed text
>> output [NC]
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Cedric ROUVRAIS wrote:
>>> The issue one of my teams reported is that if there is a column in the
>>> file that does not get imported into the table, then it fails. The
>>> faulty procedure is _bcp_readfmt_colinfo which fails because TAB_COLNUM
>>> is not present in that case.
>>>
>>> Any ideas before I start implementing a fix?
>> I don't know what you mean by "not present", Cedric. It's an integer; it
>> has to be present.
>>
>> It looks OK to me. The dbproc->hostfileinfo->host_columns array points to
>> a memory allocated with calloc(3) in bcp_columns(). By default, then,
>> ci->tab_colnum should be zero, meaning the field in the file is ignored.
>>
>> HTH.
>>
>> --jkl
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>>
>>
>> *************************************************************************
>> This message and any attachments (the "message") are confidential, intended
>> solely for the addressee(s), and may contain legally privileged information.
>> Any unauthorised use or dissemination is prohibited. E-mails are susceptible
>> to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or
>> affiliates shall be liable for the message if altered, changed or falsified.
>> *************************************************************************
>>
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
More information about the FreeTDS
mailing list