Skip to Content.
Sympa Menu

freetds - RE: [freetds] timestamps and bcp

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] timestamps and bcp
  • Date: Tue, 24 Feb 2004 08:22:37 -0000

That's interesting.

I have recently looked at what happens when a column has a DEFAULT
constraint defined against a column.
This is similar I believe. It shouldn't take much to get it working. I'll
incorporate this when I (finally) get the chance to finish the bcp work I'm
doing.

Bill

> -----Original Message-----
> From: Lowden, James K [SMTP:LowdenJK AT bernstein.com]
> Sent: Monday, February 23, 2004 10:59 PM
> To: TDS Development Group
> Subject: [freetds] timestamps and bcp
>
> 17:34:57.846249 client.2636 > server.2500: P 870:938(68) ack 916 win 7845
> (DF)
> 0x0000 4500 006c f53f 4000 8006 91a7 0a51 2428
> E..l.?@......Q$(
> 0x0010 0a50 3adc 0a4c 09c4 0119 3a5b 5049 c5e9
> .P:..L....:[PI..
> 0x0020 5018 1ea5 c637 0000 0101 0044 0000 0100
> P....7.....D....
> 0x0030 6900 6e00 7300 6500 7200 7400 2000 6200
> i.n.s.e.r.t...b.
> 0x0040 7500 6c00 6b00 2000 7400 6500 7300 7400
> u.l.k...t.e.s.t.
> 0x0050 6400 6200 2e00 2e00 7400 7300 2800 7400
> d.b.....t.s.(.t.
> 0x0060 7300 2000 6900 6e00 7400 2900 s...i.n.t.).
> 17:34:57.846864 server.2500 > client.2636: P 916:933(17) ack 938 win 63303
> (DF)
> 0x0000 4500 0039 fe3d 4000 7d06 8bdc 0a50 3adc
> E..9.=@.}....P:.
> 0x0010 0a51 2428 09c4 0a4c 5049 c5e9 0119 3a9f
> .Q$(...LPI....:.
> 0x0020 5018 f747 dbc4 0000 0401 0011 0037 0100
> P..G.........7..
> 0x0030 fd00 00c3 0002 0000 00 .........
> 17:34:57.847210 client.2636 > server.2500: P 938:981(43) ack 933 win 7828
> (DF)
> 0x0000 4500 0053 f63f 4000 8006 90c0 0a51 2428
> E..S.?@......Q$(
> 0x0010 0a50 3adc 0a4c 09c4 0119 3a9f 5049 c5fa
> .P:..L....:.PI..
> 0x0020 5018 1e94 9cf3 0000 0701 002b 0000 0100
> P..........+....
> 0x0030 8101 0000 0008 0026 0402 7400 7300 d104
> .......&..t.s...
> 0x0040 0300 0000 d104 0400 0000 fd00 0000 0000
> ................
> 0x0050 0000 00 ...
>
> The above tcpdump(8) log shows a bulk insert into this table:
>
> create table ts (ts int, cc timestamp)
>
> Here are the data in the file:
>
> $ type E:\website\sql2k\ts.txt
> 3 000000000015F195
> 4 000000000015F196
>
> Here are the resulting data in the table:
>
> 1> select * from ts where ts > 2
> 2> go
> ts cc
> ----------- ------------------
> 3 0x00000000001610da
> 4 0x00000000001610db
>
> (2 rows affected)
>
> Microsoft's BCP utility detects the timestamp column, and automatically
> snips it from the "bulk insert" statement. It then skips the timestamp
> data, inserting a NULL value instead, allowing the server to accept the
> row and assign its own timestamp value.
>
> FreeTDS cannot load data into tables with timestamp columns. It simply
> fails.
>
> --jkl
>
>
> -----------------------------------------
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above. If you are not the intended recipient, or an employee or
> agent responsible for delivering this message to the intended recipient,
> any review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the intended
> recipient, please contact the sender immediately by reply e-mail and
> destroy all copies of the original message. Please note that we do not
> accept account orders and/or instructions by e-mail, and therefore will
> not be responsible for carrying out such orders and/or instructions.
> If you, as the intended recipient of this message, the purpose of which is
> to inform and update our clients, prospects and consultants of
> developments relating to our services and products, would not like to
> receive further e-mail correspondence from the sender, please "reply" to
> the sender indicating your wishes. In the U.S.: 1345 Avenue of the
> Americas, New York, NY 10105.
>
>
> _______________________________________________
> 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/>

==============================================================================




  • [freetds] timestamps and bcp, Lowden, James K, 02/23/2004
    • <Possible follow-up(s)>
    • RE: [freetds] timestamps and bcp, Thompson, Bill D (London), 02/24/2004

Archive powered by MHonArc 2.6.24.

Top of Page