Skip to Content.
Sympa Menu

freetds - Re: [freetds] Data porting homegrown tools and techniques(wasRE:freebcp: add support for escaping characters?)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Data porting homegrown tools and techniques(wasRE:freebcp: add support for escaping characters?)
  • Date: Mon, 3 Apr 2006 16:09:32 +0100

Roger,

> select foo, bar, baz from ThisTable t, OtherTable o
> where t.bar = o.bar and baz = BAZ;

whats the issue with that ?
is that a case sensitivity thing, where baz and BAZ are both column
names ?

Let me know if you have any issues with datacopy.
I've got a later version I haven't had time to submit that sorts some of
the glitches.

Bill

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Roger L. Reid
Sent: 03 April 2006 15:57
To: FreeTDS Development Group
Subject: Re: [freetds] Data porting homegrown tools and
techniques(wasRE:freebcp: add support for escaping characters?)


Aha! So you're the man, Bill. So often after hacking these things you
think "it would be great to clean this up enough to let other people use
it" and you don't get the chance. Thanks for helping to keep my life
sane.

But somehow I've missed "datacopy". Guess I better go rummage around in
the freetds directories some more!
Especially knowing it came from a Sybase->SQL Server port.

SP's are mostly a non issue because a great deal of this was originally
on a Britton Lee system (Bob Epstien, who is the father of Sybase (which
is the father of all software based RDB servers) left BL to create
Sybase ); and BL did not have stored procedures per se. No NULLs,
either. [Nor SQL; it used QUEL, a superior language]. Since much of
this stuff was ported off there, we have always had a cultural bias
against SPs.

Actually it's one of the tasks these days - encouraging the developers
to embrace SPs ("don't do as I do, do as I say")

Wish we had stuck with the "no NULLs" thing. But I think I recall being
excited to learn NULLs would be supported in
Sybase "three value logic? How exotic!" (foolish youth!)

I do hit some interesting snags - like this bit that worked on Sybase,
not on SQL Server:

select foo, bar, baz from ThisTable t, OtherTable o
where t.bar = o.bar and baz = BAZ;

> -----Original Message-----
> From: Thompson, Bill D (London) [mailto:bill_d_thompson AT ml.com]
> To: FreeTDS Development Group
> Subject: Re: [freetds] Data porting homegrown tools and
> techniques (wasRE:freebcp: add support for escaping characters?)
>
> Hi Roger,
>
> My Client code used dblib, but made great use of the
> dblibrary bcp api,
> which at the time wasn't implemented in freeTDS.
> I did a lot of work on getting those functions to work, and
> freebcp just
> came as a natural consequence.
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------



  • Re: [freetds] Data porting homegrown tools and techniques(wasRE:freebcp: add support for escaping characters?), Thompson, Bill D (London), 04/03/2006

Archive powered by MHonArc 2.6.24.

Top of Page