[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