FreeTDS Development Group

[ananthbv AT gmail.com]

Thanks for the suggestions James.

Here is the hexdump of the freebcp out datafile. The '!#' you see is
the field separator I have used.

$ hexdump -C tmpreq.txt

00000000 31 31 39 31 35 35 37 21 23 80 34 34 2e 33 30 0a |1191557!#.44.30.|

00000010


I have attached the file for the freebcp out+in session
(freetds_varchar.log.txt)


The table definition is:

CREATE TABLE dbo.tmpreq
(
  request_id       int           NOT NULL,
  buy_price    varchar(20)   NULL
)


For testing purposes, the table on sybase has only one row. The
'buy_price' column has the euro symbol. (exact value: euro44.30).

Should I add the 'client charset' fields in the freetds.conf for both
the sybase and sql server databases (currently it does not have this
field for both the sybase and sql server)? Also please tell me what
those fields should have.

I also did a 'datacopy' for the same table, which worked. I have
attached the tdsdump for that session too (freetds_datacopy.log.txt).
I saw some encodings in the file, but dont know where exactly to use
it for freebcp, please advise.

One more question: I read in the sybase manuals that iso_1 does not
have euro symbol. But when I did a sybase bcp out with -J iso_1, I
could see the euro symbol in the output file. How does this happen?


On Thu, Dec 30, 2010 at 10:11 PM, James K. Lowden <jklowden AT freetds.org> 
wrote:
> ananthbv AT gmail.com wrote:
>> Hi,
>>
>> I am trying to freebcp out data from a table Sybase and freebcp it in
>> to a SQL Server table. The FreeTDS installed is on a Linux box
>>
>> Some of the data contain a euro symbol. The output file of freebcp
>> shows the euro symbol as '~@'. When that data is loaded into the table
>> with freebcp in, it is failing with the error
>>
>> Starting copy...
>> Msg 20088, Level 3
>> I/O error while writing bcp error file
>>
>> The error file (passed as -e parameter to the freebcp in command shows
>> the row (and mentions the column number) which has the euro symbol.
> ...
>> FreeTDS version: 0.82-1
>> Sybase: 12.5
>> SQL Server: 2008 R2
>
> Boy, have you got a doozie.  Sybase, Microsoft, character encoding, and
> bcp all in one message.  It's the toughest question I've seen here in
> quite a while.
>
> I think it can be made to work, but it's tricky because we have to get all
> the encodings right.  To make it more interesting, Sybase and Microsoft
> servers have different client character encoding policies: Sybase tries to
> use the client's encoding, whereas Microsoft simply describes the encoding
> and leaves the rest up to you.  I'm not completely sure how well FreeTDS's
> character encoding works with TDS 5.0, and I don't have an easy way to
> test it.
>
> First things first:
>
> 1.  What is the encoding for the column on the Sybase server?
> 2.  What is the encoding for the column on the Microsoft server?
> 3.  What encoding are you using on your client?
>
> Let's look at the Sybase side first.
>
>> The output file of freebcp shows the euro symbol as '~@'.
>
> I don't doubt you saw those characters on your screen, but I can't
> interpret them.
>
> We're going to need a TDSDUMP log of the session.  We need to know the
> bytes the server sent, what conversion (if any) FreeTDS tried to apply,
> and what bytes were written to your file.  The log should show all that.
>
> At the top of the TDSDUMP log you should also see the client and server
> encodings in use for the session.  (When we get to the Microsoft side,
> it's important to remember that individual columns can use distinct
> encodings.)
>
> To verify the bytes written to the file, we need a hex dump.  Something
> like this might do the trick:
>
>        grep '@' datafile | hexdump -C
>
> Once we establish the encoding of the data as received from Sybase, we
> have a fighting chance of uploading it on the Microsoft server.  The
> target column can use any encoding that supports the Euro symbol.  Unicode
> (UCS-2) will work, so will Code Page 1252.
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
log.c:190:Starting log file for FreeTDS 0.82
        on 2010-12-31 20:49:15 with debug flags 0x4fff.
iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "ISO-8859-1" character 
set
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:836:tds7_get_instance_port(10.60.166.133, NF3_MAIN1_DEV)
net.c:936:instance info
0000 05 60 00 53 65 72 76 65-72 4e 61 6d 65 3b 4e 59 |.`.Serve rName;NY|
0010 4b 44 53 4d 30 35 35 37-34 3b 49 6e 73 74 61 6e |KDSM0557 4;Instan|
0020 63 65 4e 61 6d 65 3b 4e-46 33 5f 4d 41 49 4e 31 |ceName;N F3_MAIN1|
0030 5f 44 45 56 3b 49 73 43-6c 75 73 74 65 72 65 64 |_DEV;IsC lustered|
0040 3b 4e 6f 3b 56 65 72 73-69 6f 6e 3b 31 30 2e 30 |;No;Vers ion;10.0|
0050 2e 32 35 33 31 2e 30 3b-74 63 70 3b 31 30 35 30 |.2531.0; tcp;1050|
0060 31 3b 3b               -                        |1;;|

net.c:974:instance port is 10501
net.c:210:Connecting to 10.60.166.133 port 10501 (TDS version 8.0)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:303:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:735:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
net.c:592:Received header
0000 04 01 01 bd 00 a1 01 00-                        |........|

net.c:671:Received packet
0000 e3 1b 00 01 06 6d 00 61-00 73 00 74 00 65 00 72 |.....m.a .s.t.e.r|
0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 88 |..m.a.s. t.e.r...|
0020 00 45 16 00 00 02 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|
0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d.  .d.a.t.a|
0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0060 00 27 00 6d 00 61 00 73-00 74 00 65 00 72 00 27 |.'.m.a.s .t.e.r.'|
0070 00 2e 00 19 4e 00 59 00-4b 00 44 00 53 00 4d 00 |....N.Y. K.D.S.M.|
0080 30 00 35 00 35 00 37 00-34 00 5c 00 4e 00 46 00 |0.5.5.7. 4.\.N.F.|
0090 33 00 5f 00 4d 00 41 00-49 00 4e 00 31 00 5f 00 |3._.M.A. I.N.1._.|
00a0 44 00 45 00 56 00 00 01-00 e3 08 00 07 05 09 04 |D.E.V... ........|
00b0 c0 00 00 00 e3 17 00 02-0a 75 00 73 00 5f 00 65 |........ .u.s._.e|
00c0 00 6e 00 67 00 6c 00 69-00 73 00 68 00 00 ab 8c |.n.g.l.i .s.h....|
00d0 00 47 16 00 00 01 00 27-00 43 00 68 00 61 00 6e |.G.....' .C.h.a.n|
00e0 00 67 00 65 00 64 00 20-00 6c 00 61 00 6e 00 67 |.g.e.d.  .l.a.n.g|
00f0 00 75 00 61 00 67 00 65-00 20 00 73 00 65 00 74 |.u.a.g.e . .s.e.t|
0100 00 74 00 69 00 6e 00 67-00 20 00 74 00 6f 00 20 |.t.i.n.g . .t.o. |
0110 00 75 00 73 00 5f 00 65-00 6e 00 67 00 6c 00 69 |.u.s._.e .n.g.l.i|
0120 00 73 00 68 00 2e 00 19-4e 00 59 00 4b 00 44 00 |.s.h.... N.Y.K.D.|
0130 53 00 4d 00 30 00 35 00-35 00 37 00 34 00 5c 00 |S.M.0.5. 5.7.4.\.|
0140 4e 00 46 00 33 00 5f 00-4d 00 41 00 49 00 4e 00 |N.F.3._. M.A.I.N.|
0150 31 00 5f 00 44 00 45 00-56 00 00 01 00 ad 36 00 |1._.D.E. V.....6.|
0160 01 71 00 00 01 16 4d 00-69 00 63 00 72 00 6f 00 |.q....M. i.c.r.o.|
0170 73 00 6f 00 66 00 74 00-20 00 53 00 51 00 4c 00 |s.o.f.t.  .S.Q.L.|
0180 20 00 53 00 65 00 72 00-76 00 65 00 72 00 00 00 | .S.e.r. v.e.r...|
0190 00 00 0a 00 0a b4 e3 13-00 04 04 34 00 30 00 39 |........ ...4.0.9|
01a0 00 36 00 04 34 00 30 00-39 00 36 00 fd 00 00 00 |.6..4.0. 9.6.....|
01b0 00 00 00 00 00         -                        |.....|

token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(0x11590da0, 1, master, master)
token.c:316:looking for login token, got  ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
dbutil.c:86:_dblib_handle_info_message(0x11590120, 0x11590da0, 0x7fff98e82b80)
dbutil.c:87:msgno 5701: "Changed database context to 'master'."
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 00 00 00 00 00         -                        |.....|

iconv.c:985:setting server single-byte charset to "CP1252"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"
token.c:2292:tds->collation now
0000 09 04 c0 00 00         -                        |.....|

token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(0x11590da0, 2, , us_english)
token.c:316:looking for login token, got  ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
dbutil.c:86:_dblib_handle_info_message(0x11590120, 0x11590da0, 0x7fff98e82b80)
dbutil.c:87:msgno 5703: "Changed language setting to us_english."
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got  ad(LOGINACK)
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(0x11590da0, 4, 4096, 4096)
token.c:316:looking for login token, got  fd(DONE)
token.c:108:tds_process_default_tokens() marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
token.c:2232:                rows_affected = 0
token.c:393:leaving tds_process_login_tokens() returning 1
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 19 bytes of "set textsize 64512 "
write.c:164:tds_put_string wrote 38 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 2e 00 00 00 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00       | .6.4.5. 1.2. .|

token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e82c74, 0x7fff98e82c70, 
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 a1 01 00-                        |........|

net.c:671:Received packet
0000 fd 00 00 be 00 00 00 00-00                      |........ .|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e82c74, 0x7fff98e82c70, 
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:237:dblib_add_connection(0x2b9011e7f060, 0x11590da0)
dblib.c:1205:dbfcmd(0x11590380, set textsize %d , ...)
dblib.c:1243:dbcmd(0x11590380, set textsize 4096 )
dblib.c:1250:dbcmd() bufsz = 0
dblib.c:1298:dbsqlexec(0x11590380)
dblib.c:6722:dbsqlsend(0x11590380)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 18 bytes of "set textsize 4096 "
write.c:164:tds_put_string wrote 36 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 2c 00 00 01 00-73 00 65 00 74 00 20 00 |...,.... s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 34 00 30 00 39 00-36 00 20 00             | .4.0.9. 6. .|

dblib.c:4532:dbsqlok(0x11590380)
net.c:592:Received header
0000 04 01 00 11 00 a1 01 00-                        |........|

net.c:671:Received packet
0000 fd 00 00 be 00 00 00 00-00                      |........ .|

dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e83010, 0x7fff98e83014, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
dblib.c:4601:dbsqlok() end status was success
dblib.c:1599:dbresults(0x11590380)
dblib.c:1608:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:1948:dbnextrow(0x11590380)
dblib.c:1961:dbnextrow() dbresults_state = 3 (_DB_RES_NEXT_RESULT)
dblib.c:1966:leaving dbnextrow() returning -2 (NO_MORE_ROWS)
dblib.c:1599:dbresults(0x11590380)
dblib.c:1608:dbresults: dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e82ff4, 0x7fff98e82ff0, 
0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:1630:dbresults() tds_process_tokens returned 2 (TDS_NO_MORE_RESULTS),
                        result_type TDS_DONE_RESULT
dblib.c:1587:dbresults returning 2 (NO_MORE_RESULTS)
dblib.c:1205:dbfcmd(0x11590380, SET FMTONLY ON select * from %s SET FMTONLY 
OFF, ...)
dblib.c:1243:dbcmd(0x11590380, SET FMTONLY ON select * from 
aspire_global.dbo.tmpreq SET FMTONLY OFF)
dblib.c:1250:dbcmd() bufsz = 19
dblib.c:5727:dbfreebuf(0x11590380)
dblib.c:1298:dbsqlexec(0x11590380)
dblib.c:6722:dbsqlsend(0x11590380)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 69 bytes of "SET FMTONLY ON select * 
from aspire_global.dbo.tmpreq SET FMTONLY OFF"
write.c:164:tds_put_string wrote 138 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 92 00 00 01 00-53 00 45 00 54 00 20 00 |........ S.E.T. .|
0010 46 00 4d 00 54 00 4f 00-4e 00 4c 00 59 00 20 00 |F.M.T.O. N.L.Y. .|
0020 4f 00 4e 00 20 00 73 00-65 00 6c 00 65 00 63 00 |O.N. .s. e.l.e.c.|
0030 74 00 20 00 2a 00 20 00-66 00 72 00 6f 00 6d 00 |t. .*. . f.r.o.m.|
0040 20 00 61 00 73 00 70 00-69 00 72 00 65 00 5f 00 | .a.s.p. i.r.e._.|
0050 67 00 6c 00 6f 00 62 00-61 00 6c 00 2e 00 64 00 |g.l.o.b. a.l...d.|
0060 62 00 6f 00 2e 00 74 00-6d 00 70 00 72 00 65 00 |b.o...t. m.p.r.e.|
0070 71 00 20 00 53 00 45 00-54 00 20 00 46 00 4d 00 |q. .S.E. T. .F.M.|
0080 54 00 4f 00 4e 00 4c 00-59 00 20 00 4f 00 46 00 |T.O.N.L. Y. .O.F.|
0090 46 00                  -                        |F.|

dblib.c:4532:dbsqlok(0x11590380)
net.c:592:Received header
0000 04 01 00 5f 00 a1 01 00-                        |..._....|

net.c:671:Received packet
0000 fd 01 00 b9 00 00 00 00-00 81 02 00 00 00 08 00 |........ ........|
0010 38 0a 72 00 65 00 71 00-75 00 65 00 73 00 74 00 |8.r.e.q. u.e.s.t.|
0020 5f 00 69 00 64 00 00 00-0b 00 a7 14 00 09 04 c0 |_.i.d... ........|
0030 00 00 09 62 00 75 00 79-00 5f 00 70 00 72 00 69 |...b.u.y ._.p.r.i|
0040 00 63 00 65 00 fd 11 00-c1 00 00 00 00 00 fd 00 |.c.e.... ........|
0050 00 ba 00 00 00 00 00   -                        |.......|

dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e830f0, 0x7fff98e830f4, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
dblib.c:4601:dbsqlok() end status was success
dblib.c:1599:dbresults(0x11590380)
dblib.c:1608:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:1745:dbnumcols(0x11590380)
dblib.c:1599:dbresults(0x11590380)
dblib.c:1608:dbresults: dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e830d4, 0x7fff98e830d0, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (2 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info: 
        colname = request_id (10 bytes)
        type = 56 (int)
        server's type = 56 (int)
        column_varint_size = 0
        column_size = 4 (4 on server)
token.c:1555:setting up column 1
token.c:3294:adjust_character_column_size:
        Server charset: CP1252
        Server column_size: 20
        Client charset: ISO-8859-1
        Client column_size: 20
token.c:1490:tds7_get_data_info: 
        colname = buy_price (9 bytes)
        type = 39 (varchar)
        server's type = 167 (xvarchar)
        column_varint_size = 2
        column_size = 20 (20 on server)
util.c:162:Changed query state from READING to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_ROWFMT_RESULT
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e830d4, 0x7fff98e830d0, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 1
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_DONE_RESULT
dblib.c:1657:dbresults(): dbresults_state is 1 (_DB_RES_RESULTSET_EMPTY)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:1745:dbnumcols(0x11590380)
dblib.c:1599:dbresults(0x11590380)
dblib.c:1608:dbresults: dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e830d4, 0x7fff98e830d0, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_DONE_RESULT
dblib.c:1657:dbresults(): dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e830d4, 0x7fff98e830d0, 
0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:1630:dbresults() tds_process_tokens returned 2 (TDS_NO_MORE_RESULTS),
                        result_type TDS_DONE_RESULT
dblib.c:1587:dbresults returning 2 (NO_MORE_RESULTS)
bcp.c:138:bcp_init(0x11590380, aspire_global.dbo.tmpreq, tmpreq.txt, 
tmpreq_err.txt, 1)
bcp.c:3584:_bcp_free_storage(0x11590380)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 69 bytes of "SET FMTONLY ON select * 
from aspire_global.dbo.tmpreq SET FMTONLY OFF"
write.c:164:tds_put_string wrote 138 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 92 00 00 01 00-53 00 45 00 54 00 20 00 |........ S.E.T. .|
0010 46 00 4d 00 54 00 4f 00-4e 00 4c 00 59 00 20 00 |F.M.T.O. N.L.Y. .|
0020 4f 00 4e 00 20 00 73 00-65 00 6c 00 65 00 63 00 |O.N. .s. e.l.e.c.|
0030 74 00 20 00 2a 00 20 00-66 00 72 00 6f 00 6d 00 |t. .*. . f.r.o.m.|
0040 20 00 61 00 73 00 70 00-69 00 72 00 65 00 5f 00 | .a.s.p. i.r.e._.|
0050 67 00 6c 00 6f 00 62 00-61 00 6c 00 2e 00 64 00 |g.l.o.b. a.l...d.|
0060 62 00 6f 00 2e 00 74 00-6d 00 70 00 72 00 65 00 |b.o...t. m.p.r.e.|
0070 71 00 20 00 53 00 45 00-54 00 20 00 46 00 4d 00 |q. .S.E. T. .F.M.|
0080 54 00 4f 00 4e 00 4c 00-59 00 20 00 4f 00 46 00 |T.O.N.L. Y. .O.F.|
0090 46 00                  -                        |F.|

token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e830d4, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 5f 00 a1 01 00-                        |..._....|

net.c:671:Received packet
0000 fd 01 00 b9 00 00 00 00-00 81 02 00 00 00 08 00 |........ ........|
0010 38 0a 72 00 65 00 71 00-75 00 65 00 73 00 74 00 |8.r.e.q. u.e.s.t.|
0020 5f 00 69 00 64 00 00 00-0b 00 a7 14 00 09 04 c0 |_.i.d... ........|
0030 00 00 09 62 00 75 00 79-00 5f 00 70 00 72 00 69 |...b.u.y ._.p.r.i|
0040 00 63 00 65 00 fd 11 00-c1 00 00 00 00 00 fd 00 |.c.e.... ........|
0050 00 ba 00 00 00 00 00   -                        |.......|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e830d4, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (2 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info: 
        colname = request_id (10 bytes)
        type = 56 (int)
        server's type = 56 (int)
        column_varint_size = 0
        column_size = 4 (4 on server)
token.c:1555:setting up column 1
token.c:3294:adjust_character_column_size:
        Server charset: CP1252
        Server column_size: 20
        Client charset: ISO-8859-1
        Client column_size: 20
token.c:1490:tds7_get_data_info: 
        colname = buy_price (9 bytes)
        type = 39 (varchar)
        server's type = 167 (xvarchar)
        column_varint_size = 2
        column_size = 20 (20 on server)
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e830d4, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 1
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e830d4, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e830d4, (nil), 0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
bcp.c:578:bcp_control(0x11590380, 2, 0)
bcp.c:578:bcp_control(0x11590380, 3, 2147483647)
bcp.c:578:bcp_control(0x11590380, 1, 10)
bcp.c:350:bcp_columns(0x11590380, 2)
bcp.c:3558:_bcp_free_columns(0x11590380)
bcp.c:428:bcp_colfmt(0x11590380, 1, 47, 0, -1, 0x11588040)
bcp.c:428:bcp_colfmt(0x11590380, 2, 47, 0, -1, 0x4028a4)
bcp.c:578:bcp_control(0x11590380, 4, 1000)
bcp.c:2072:bcp_exec(0x11590380, 0x7fff98e8312c)
bcp.c:1890:_bcp_exec_in(0x11590380, 0x7fff98e8312c)
bcp.c:2119:_bcp_start_copy_in(0x11590380)
bcp.c:2319:_bcp_build_bulk_insert_stmt(0x11590da0, 0x7fff98e82ef0, 
0x115c4fe0, 1)
bcp.c:2319:_bcp_build_bulk_insert_stmt(0x11590da0, 0x7fff98e82ef0, 
0x115c5480, 0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 77 bytes of "insert bulk 
aspire_global.dbo.tmpreq (request_id int, buy_price varchar(20)) "
write.c:164:tds_put_string wrote 154 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 a2 00 00 01 00-69 00 6e 00 73 00 65 00 |........ i.n.s.e.|
0010 72 00 74 00 20 00 62 00-75 00 6c 00 6b 00 20 00 |r.t. .b. u.l.k. .|
0020 61 00 73 00 70 00 69 00-72 00 65 00 5f 00 67 00 |a.s.p.i. r.e._.g.|
0030 6c 00 6f 00 62 00 61 00-6c 00 2e 00 64 00 62 00 |l.o.b.a. l...d.b.|
0040 6f 00 2e 00 74 00 6d 00-70 00 72 00 65 00 71 00 |o...t.m. p.r.e.q.|
0050 20 00 28 00 72 00 65 00-71 00 75 00 65 00 73 00 | .(.r.e. q.u.e.s.|
0060 74 00 5f 00 69 00 64 00-20 00 69 00 6e 00 74 00 |t._.i.d.  .i.n.t.|
0070 2c 00 20 00 62 00 75 00-79 00 5f 00 70 00 72 00 |,. .b.u. y._.p.r.|
0080 69 00 63 00 65 00 20 00-76 00 61 00 72 00 63 00 |i.c.e. . v.a.r.c.|
0090 68 00 61 00 72 00 28 00-32 00 30 00 29 00 29 00 |h.a.r.(. 2.0.).).|
00a0 20 00                  -                        | .|

token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e81ec4, 0x7fff98e81ec0, 
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 a1 01 00-                        |........|

net.c:671:Received packet
0000 fd 00 00 fd 00 00 00 00-00                      |........ .|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e81ec4, 0x7fff98e81ec0, 
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
bcp.c:2284:current_record_size = 32
bcp.c:2285:bcp_record_size     = 26
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
bcp.c:2529:_bcp_send_colmetadata(0x11590380)
write.c:136:tds_put_string converting 10 bytes of "request_id"
write.c:164:tds_put_string wrote 20 bytes
write.c:136:tds_put_string converting 9 bytes of "buy_price"
write.c:164:tds_put_string wrote 18 bytes
bcp.c:1161:_bcp_read_hostfile(0x11590380, 0x115c5940, 0x7fff98e82fe0)
bcp.c:1169:parsing host column 1
bcp.c:1237:prefix_len = 0 collen = 0 
bcp.c:1501:_bcp_measure_terminated_field(0x115c5940, 0x11591400, 2)
bcp.c:1268:_bcp_measure_terminated_field returned 7
bcp.c:1398:Data read from hostfile: collen is now 7, data_is_null is 0
dblib.c:2141:dbconvert(0x11590380, SYBCHAR, 0x11591570, 7, SYBINT4, 
0x11591270, 4)
dblib.c:2283:dbconvert() calling tds_convert
dblib.c:2286:dbconvert() called tds_convert returned 4
bcp.c:1169:parsing host column 2
bcp.c:1237:prefix_len = 0 collen = 0 
bcp.c:1501:_bcp_measure_terminated_field(0x115c5940, 0x115c5920, 1)
bcp.c:1268:_bcp_measure_terminated_field returned 6
bcp.c:1277:Adjusted collen is 6.
iconv.c:882:tds_iconv_fread: read 6 of 6 bytes; outbuf has 6 left.
iconv.c:899:tds_iconv_fread: error 84: Invalid or incomplete multibyte or 
wide character.
bcp.c:1398:Data read from hostfile: collen is now 0, data_is_null is 0
dblib.c:2141:dbconvert(0x11590380, SYBCHAR, 0x11591570, 0, SYBVARCHAR, 
0x11591310, 20)
dblib.c:532:dbgetnull(0x11590380, 2, -1, 0x11591310)
bcp.c:1446:_bcp_read_hostfile failed to convert 0 bytes at offset 0x10 in the 
data file.
dblib.c:7782:dbperror(0x11590380, 20088, 84)
dblib.c:7835:20088: "I/O error while writing bcp error file"
dblib.c:7856:"I/O error while writing bcp error file", client returns 2 
(INT_CANCEL)
bcp.c:1161:_bcp_read_hostfile(0x11590380, 0x115c5940, 0x7fff98e82fe0)
bcp.c:1169:parsing host column 1
bcp.c:1237:prefix_len = 0 collen = 0 
bcp.c:1501:_bcp_measure_terminated_field(0x115c5940, 0x11591400, 2)
bcp.c:1268:_bcp_measure_terminated_field returned 0
bcp.c:1391:Normal end-of-file reached while loading bcp data file.
net.c:779:Sending packet
0000 07 01 00 44 00 00 01 00-81 02 00 00 00 08 00 38 |...D.... .......8|
0010 0a 72 00 65 00 71 00 75-00 65 00 73 00 74 00 5f |.r.e.q.u .e.s.t._|
0020 00 69 00 64 00 00 00 0b-00 a7 14 00 09 04 c0 00 |.i.d.... ........|
0030 00 09 62 00 75 00 79 00-5f 00 70 00 72 00 69 00 |..b.u.y. _.p.r.i.|
0040 63 00 65 00            -                        |c.e.|

util.c:162:Changed query state from QUERYING to PENDING
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e82f14, 0x7fff98e82f10, 
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 a1 01 00-                        |........|

net.c:671:Received packet
0000 fd 10 00 f0 00 00 00 00-00                      |........ .|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 1
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x11590da0, 0x7fff98e82f14, 0x7fff98e82f10, 
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
bcp.c:3584:_bcp_free_storage(0x11590380)
bcp.c:3558:_bcp_free_columns(0x11590380)log.c:190:Starting log file for FreeTDS 0.82
        on 2010-12-31 20:53:10 with debug flags 0x4fff.
iconv.c:363:iconv to convert client-side data to the "ISO-8859-1" character 
set
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:836:tds7_get_instance_port(10.60.166.133, NF3_MAIN1_DEV)
net.c:936:instance info
0000 05 60 00 53 65 72 76 65-72 4e 61 6d 65 3b 4e 59 |.`.Serve rName;NY|
0010 4b 44 53 4d 30 35 35 37-34 3b 49 6e 73 74 61 6e |KDSM0557 4;Instan|
0020 63 65 4e 61 6d 65 3b 4e-46 33 5f 4d 41 49 4e 31 |ceName;N F3_MAIN1|
0030 5f 44 45 56 3b 49 73 43-6c 75 73 74 65 72 65 64 |_DEV;IsC lustered|
0040 3b 4e 6f 3b 56 65 72 73-69 6f 6e 3b 31 30 2e 30 |;No;Vers ion;10.0|
0050 2e 32 35 33 31 2e 30 3b-74 63 70 3b 31 30 35 30 |.2531.0; tcp;1050|
0060 31 3b 3b               -                        |1;;|

net.c:974:instance port is 10501
net.c:210:Connecting to 10.60.166.133 port 10501 (TDS version 8.0)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:303:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:735:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
net.c:592:Received header
0000 04 01 01 bd 00 a6 01 00-                        |........|

net.c:671:Received packet
0000 e3 1b 00 01 06 6d 00 61-00 73 00 74 00 65 00 72 |.....m.a .s.t.e.r|
0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 88 |..m.a.s. t.e.r...|
0020 00 45 16 00 00 02 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|
0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d.  .d.a.t.a|
0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0060 00 27 00 6d 00 61 00 73-00 74 00 65 00 72 00 27 |.'.m.a.s .t.e.r.'|
0070 00 2e 00 19 4e 00 59 00-4b 00 44 00 53 00 4d 00 |....N.Y. K.D.S.M.|
0080 30 00 35 00 35 00 37 00-34 00 5c 00 4e 00 46 00 |0.5.5.7. 4.\.N.F.|
0090 33 00 5f 00 4d 00 41 00-49 00 4e 00 31 00 5f 00 |3._.M.A. I.N.1._.|
00a0 44 00 45 00 56 00 00 01-00 e3 08 00 07 05 09 04 |D.E.V... ........|
00b0 c0 00 00 00 e3 17 00 02-0a 75 00 73 00 5f 00 65 |........ .u.s._.e|
00c0 00 6e 00 67 00 6c 00 69-00 73 00 68 00 00 ab 8c |.n.g.l.i .s.h....|
00d0 00 47 16 00 00 01 00 27-00 43 00 68 00 61 00 6e |.G.....' .C.h.a.n|
00e0 00 67 00 65 00 64 00 20-00 6c 00 61 00 6e 00 67 |.g.e.d.  .l.a.n.g|
00f0 00 75 00 61 00 67 00 65-00 20 00 73 00 65 00 74 |.u.a.g.e . .s.e.t|
0100 00 74 00 69 00 6e 00 67-00 20 00 74 00 6f 00 20 |.t.i.n.g . .t.o. |
0110 00 75 00 73 00 5f 00 65-00 6e 00 67 00 6c 00 69 |.u.s._.e .n.g.l.i|
0120 00 73 00 68 00 2e 00 19-4e 00 59 00 4b 00 44 00 |.s.h.... N.Y.K.D.|
0130 53 00 4d 00 30 00 35 00-35 00 37 00 34 00 5c 00 |S.M.0.5. 5.7.4.\.|
0140 4e 00 46 00 33 00 5f 00-4d 00 41 00 49 00 4e 00 |N.F.3._. M.A.I.N.|
0150 31 00 5f 00 44 00 45 00-56 00 00 01 00 ad 36 00 |1._.D.E. V.....6.|
0160 01 71 00 00 01 16 4d 00-69 00 63 00 72 00 6f 00 |.q....M. i.c.r.o.|
0170 73 00 6f 00 66 00 74 00-20 00 53 00 51 00 4c 00 |s.o.f.t.  .S.Q.L.|
0180 20 00 53 00 65 00 72 00-76 00 65 00 72 00 00 00 | .S.e.r. v.e.r...|
0190 00 00 0a 00 0a b4 e3 13-00 04 04 34 00 30 00 39 |........ ...4.0.9|
01a0 00 36 00 04 34 00 30 00-39 00 36 00 fd 00 00 00 |.6..4.0. 9.6.....|
01b0 00 00 00 00 00         -                        |.....|

token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(0xfbae5c0, 1, master, master)
token.c:316:looking for login token, got  ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
dbutil.c:86:_dblib_handle_info_message(0xfb9b190, 0xfbae5c0, 0x7fffa99fddc0)
dbutil.c:87:msgno 5701: "Changed database context to 'master'."
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 00 00 00 00 00         -                        |.....|

iconv.c:985:setting server single-byte charset to "CP1252"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"
token.c:2292:tds->collation now
0000 09 04 c0 00 00         -                        |.....|

token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(0xfbae5c0, 2, , us_english)
token.c:316:looking for login token, got  ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
dbutil.c:86:_dblib_handle_info_message(0xfb9b190, 0xfbae5c0, 0x7fffa99fddc0)
dbutil.c:87:msgno 5703: "Changed language setting to us_english."
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got  ad(LOGINACK)
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(0xfbae5c0, 4, 4096, 4096)
token.c:316:looking for login token, got  fd(DONE)
token.c:108:tds_process_default_tokens() marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
token.c:2232:                rows_affected = 0
token.c:393:leaving tds_process_login_tokens() returning 1
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 19 bytes of "set textsize 64512 "
write.c:164:tds_put_string wrote 38 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 2e 00 00 00 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00       | .6.4.5. 1.2. .|

token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fdeb4, 0x7fffa99fdeb0, 
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 a6 01 00-                        |........|

net.c:671:Received packet
0000 fd 00 00 be 00 00 00 00-00                      |........ .|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fdeb4, 0x7fffa99fdeb0, 
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:237:dblib_add_connection(0x2b8901306060, 0xfbae5c0)
dblib.c:1327:dbuse(0xfbadcc0, aspire_global)
dblib.c:1243:dbcmd(0xfbadcc0, use aspire_global)
dblib.c:1250:dbcmd() bufsz = 0
dblib.c:1298:dbsqlexec(0xfbadcc0)
dblib.c:6722:dbsqlsend(0xfbadcc0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 17 bytes of "use aspire_global"
write.c:164:tds_put_string wrote 34 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 2a 00 00 01 00-75 00 73 00 65 00 20 00 |...*.... u.s.e. .|
0010 61 00 73 00 70 00 69 00-72 00 65 00 5f 00 67 00 |a.s.p.i. r.e._.g.|
0020 6c 00 6f 00 62 00 61 00-6c 00                   |l.o.b.a. l.|

dblib.c:4532:dbsqlok(0xfbadcc0)
net.c:592:Received header
0000 04 01 00 e1 00 a6 01 00-                        |........|

net.c:671:Received packet
0000 e3 29 00 01 0d 61 00 73-00 70 00 69 00 72 00 65 |.)...a.s .p.i.r.e|
0010 00 5f 00 67 00 6c 00 6f-00 62 00 61 00 6c 00 06 |._.g.l.o .b.a.l..|
0020 6d 00 61 00 73 00 74 00-65 00 72 00 ab 96 00 45 |m.a.s.t. e.r....E|
0030 16 00 00 01 00 2c 00 43-00 68 00 61 00 6e 00 67 |.....,.C .h.a.n.g|
0040 00 65 00 64 00 20 00 64-00 61 00 74 00 61 00 62 |.e.d. .d .a.t.a.b|
0050 00 61 00 73 00 65 00 20-00 63 00 6f 00 6e 00 74 |.a.s.e.  .c.o.n.t|
0060 00 65 00 78 00 74 00 20-00 74 00 6f 00 20 00 27 |.e.x.t.  .t.o. .'|
0070 00 61 00 73 00 70 00 69-00 72 00 65 00 5f 00 67 |.a.s.p.i .r.e._.g|
0080 00 6c 00 6f 00 62 00 61-00 6c 00 27 00 2e 00 19 |.l.o.b.a .l.'....|
0090 4e 00 59 00 4b 00 44 00-53 00 4d 00 30 00 35 00 |N.Y.K.D. S.M.0.5.|
00a0 35 00 37 00 34 00 5c 00-4e 00 46 00 33 00 5f 00 |5.7.4.\. N.F.3._.|
00b0 4d 00 41 00 49 00 4e 00-31 00 5f 00 44 00 45 00 |M.A.I.N. 1._.D.E.|
00c0 56 00 00 01 00 e3 08 00-07 05 09 04 c0 00 00 00 |V....... ........|
00d0 fd 00 00 e2 00 00 00 00-00                      |........ .|

dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe330, 0x7fffa99fe334, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(0xfbae5c0, 1, master, aspire_global)
token.c:510:processing result tokens.  marker is  ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
dbutil.c:86:_dblib_handle_info_message(0xfb9b190, 0xfbae5c0, 0x7fffa99fe170)
dbutil.c:87:msgno 5701: "Changed database context to 'aspire_global'."
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:510:processing result tokens.  marker is  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 09 04 c0 00 00         -                        |.....|

iconv.c:985:setting server single-byte charset to "CP1252"
token.c:2292:tds->collation now
0000 09 04 c0 00 00         -                        |.....|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
dblib.c:4601:dbsqlok() end status was success
dblib.c:1599:dbresults(0xfbadcc0)
dblib.c:1608:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:5699:dbcanquery(0xfbadcc0)
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe33c, (nil), 0x108)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:1243:dbcmd(0xfb9b3f0, SET FMTONLY ON select * from tmpreq SET FMTONLY 
OFF)
dblib.c:1250:dbcmd() bufsz = 11
dblib.c:5727:dbfreebuf(0xfb9b3f0)
dblib.c:1298:dbsqlexec(0xfb9b3f0)
dblib.c:6722:dbsqlsend(0xfb9b3f0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 0f 01 00 41 00 00 00 00-21 34 00 00 00 00 53 45 |...A.... !4....SE|
0010 54 20 46 4d 54 4f 4e 4c-59 20 4f 4e 20 73 65 6c |T FMTONL Y ON sel|
0020 65 63 74 20 2a 20 66 72-6f 6d 20 74 6d 70 72 65 |ect * fr om tmpre|
0030 71 20 53 45 54 20 46 4d-54 4f 4e 4c 59 20 4f 46 |q SET FM TONLY OF|
0040 46                     -                        |F|

dblib.c:4532:dbsqlok(0xfb9b3f0)
net.c:592:Received header
0000 04 01 00 7f 00 00 00 00-                        |........|

net.c:671:Received packet
0000 fd 01 00 02 00 00 00 00-00 61 52 00 00 00 02 00 |........ .aR.....|
0010 00 06 61 73 70 69 72 65-03 64 62 6f 06 74 6d 70 |..aspire .dbo.tmp|
0020 72 65 71 0a 72 65 71 75-65 73 74 5f 69 64 10 00 |req.requ est_id..|
0030 00 00 07 00 00 00 38 00-00 06 61 73 70 69 72 65 |......8. ..aspire|
0040 03 64 62 6f 06 74 6d 70-72 65 71 09 62 75 79 5f |.dbo.tmp req.buy_|
0050 70 72 69 63 65 30 00 00-00 02 00 00 00 27 14 00 |price0.. .....'..|
0060 ae 02 00 00 00 fd 11 00-02 00 00 00 00 00 fd 00 |........ ........|
0070 00 02 00 00 00 00 00   -                        |.......|

dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(0xfb9be10, 0x7fffa99fe200, 0x7fffa99fe204, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
dblib.c:4601:dbsqlok() end status was success
dblib.c:1599:dbresults(0xfb9b3f0)
dblib.c:1608:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:1599:dbresults(0xfb9b3f0)
dblib.c:1608:dbresults: dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(0xfb9be10, 0x7fffa99fe1e4, 0x7fffa99fe1e0, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  61(ROWFMT2)
token.c:1713:tds5_process_result
mem.c:563:tds_free_all_results()
token.c:1737:num_cols=2
token.c:1840:col 0:
token.c:1841:   column_name=[request_id]
token.c:1847:   flags=10 utype=7 type=56 varint=0
token.c:1850:   colsize=4 prec=0 scale=0
token.c:1840:col 1:
token.c:1841:   column_name=[buy_price]
token.c:1847:   flags=30 utype=2 type=39 varint=1
token.c:1850:   colsize=20 prec=0 scale=0
util.c:162:Changed query state from READING to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_ROWFMT_RESULT
token.c:495:tds_process_tokens(0xfb9be10, 0x7fffa99fe1e4, 0x7fffa99fe1e0, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  ae(CONTROL)
token.c:108:tds_process_default_tokens() marker is ae(CONTROL)
token.c:223:Eating CONTROL token
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 1
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_DONE_RESULT
dblib.c:1657:dbresults(): dbresults_state is 1 (_DB_RES_RESULTSET_EMPTY)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:1599:dbresults(0xfb9b3f0)
dblib.c:1608:dbresults: dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(0xfb9be10, 0x7fffa99fe1e4, 0x7fffa99fe1e0, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_DONE_RESULT
dblib.c:1657:dbresults(): dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(0xfb9be10, 0x7fffa99fe1e4, 0x7fffa99fe1e0, 
0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:1630:dbresults() tds_process_tokens returned 2 (TDS_NO_MORE_RESULTS),
                        result_type TDS_DONE_RESULT
dblib.c:1587:dbresults returning 2 (NO_MORE_RESULTS)
dblib.c:1745:dbnumcols(0xfb9b3f0)
dblib.c:1243:dbcmd(0xfbadcc0, SET FMTONLY ON select * from tmpreq SET FMTONLY 
OFF)
dblib.c:1250:dbcmd() bufsz = 18
dblib.c:5727:dbfreebuf(0xfbadcc0)
dblib.c:1298:dbsqlexec(0xfbadcc0)
dblib.c:6722:dbsqlsend(0xfbadcc0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 51 bytes of "SET FMTONLY ON select * 
from tmpreq SET FMTONLY OFF"
write.c:164:tds_put_string wrote 102 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 6e 00 00 01 00-53 00 45 00 54 00 20 00 |...n.... S.E.T. .|
0010 46 00 4d 00 54 00 4f 00-4e 00 4c 00 59 00 20 00 |F.M.T.O. N.L.Y. .|
0020 4f 00 4e 00 20 00 73 00-65 00 6c 00 65 00 63 00 |O.N. .s. e.l.e.c.|
0030 74 00 20 00 2a 00 20 00-66 00 72 00 6f 00 6d 00 |t. .*. . f.r.o.m.|
0040 20 00 74 00 6d 00 70 00-72 00 65 00 71 00 20 00 | .t.m.p. r.e.q. .|
0050 53 00 45 00 54 00 20 00-46 00 4d 00 54 00 4f 00 |S.E.T. . F.M.T.O.|
0060 4e 00 4c 00 59 00 20 00-4f 00 46 00 46 00       |N.L.Y. . O.F.F.|

dblib.c:4532:dbsqlok(0xfbadcc0)
net.c:592:Received header
0000 04 01 00 5f 00 a6 01 00-                        |..._....|

net.c:671:Received packet
0000 fd 01 00 b9 00 00 00 00-00 81 02 00 00 00 08 00 |........ ........|
0010 38 0a 72 00 65 00 71 00-75 00 65 00 73 00 74 00 |8.r.e.q. u.e.s.t.|
0020 5f 00 69 00 64 00 00 00-0b 00 a7 14 00 09 04 c0 |_.i.d... ........|
0030 00 00 09 62 00 75 00 79-00 5f 00 70 00 72 00 69 |...b.u.y ._.p.r.i|
0040 00 63 00 65 00 fd 11 00-c1 00 00 00 00 00 fd 00 |.c.e.... ........|
0050 00 ba 00 00 00 00 00   -                        |.......|

dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe200, 0x7fffa99fe204, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
dblib.c:4601:dbsqlok() end status was success
dblib.c:1599:dbresults(0xfbadcc0)
dblib.c:1608:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:1599:dbresults(0xfbadcc0)
dblib.c:1608:dbresults: dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe1e4, 0x7fffa99fe1e0, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (2 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info: 
        colname = request_id (10 bytes)
        type = 56 (int)
        server's type = 56 (int)
        column_varint_size = 0
        column_size = 4 (4 on server)
token.c:1555:setting up column 1
token.c:3294:adjust_character_column_size:
        Server charset: CP1252
        Server column_size: 20
        Client charset: ISO-8859-1
        Client column_size: 20
token.c:1490:tds7_get_data_info: 
        colname = buy_price (9 bytes)
        type = 39 (varchar)
        server's type = 167 (xvarchar)
        column_varint_size = 2
        column_size = 20 (20 on server)
util.c:162:Changed query state from READING to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_ROWFMT_RESULT
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe1e4, 0x7fffa99fe1e0, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 1
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_DONE_RESULT
dblib.c:1657:dbresults(): dbresults_state is 1 (_DB_RES_RESULTSET_EMPTY)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:1599:dbresults(0xfbadcc0)
dblib.c:1608:dbresults: dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe1e4, 0x7fffa99fe1e0, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_DONE_RESULT
dblib.c:1657:dbresults(): dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe1e4, 0x7fffa99fe1e0, 
0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:1630:dbresults() tds_process_tokens returned 2 (TDS_NO_MORE_RESULTS),
                        result_type TDS_DONE_RESULT
dblib.c:1587:dbresults returning 2 (NO_MORE_RESULTS)
dblib.c:1745:dbnumcols(0xfbadcc0)
dblib.c:2741:dbcoltype(0xfb9b3f0, 1)
dblib.c:2957:dbcollen(0xfb9b3f0, 1)
dblib.c:2741:dbcoltype(0xfbadcc0, 1)
dblib.c:2957:dbcollen(0xfbadcc0, 1)
dblib.c:2741:dbcoltype(0xfb9b3f0, 2)
dblib.c:2957:dbcollen(0xfb9b3f0, 2)
dblib.c:2741:dbcoltype(0xfbadcc0, 2)
dblib.c:2957:dbcollen(0xfbadcc0, 2)
dblib.c:1243:dbcmd(0xfbadcc0, truncate table tmpreq)
dblib.c:1250:dbcmd() bufsz = 52
dblib.c:5727:dbfreebuf(0xfbadcc0)
dblib.c:1298:dbsqlexec(0xfbadcc0)
dblib.c:6722:dbsqlsend(0xfbadcc0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 21 bytes of "truncate table tmpreq"
write.c:164:tds_put_string wrote 42 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 32 00 00 01 00-74 00 72 00 75 00 6e 00 |...2.... t.r.u.n.|
0010 63 00 61 00 74 00 65 00-20 00 74 00 61 00 62 00 |c.a.t.e.  .t.a.b.|
0020 6c 00 65 00 20 00 74 00-6d 00 70 00 72 00 65 00 |l.e. .t. m.p.r.e.|
0030 71 00                  -                        |q.|

dblib.c:4532:dbsqlok(0xfbadcc0)
net.c:592:Received header
0000 04 01 00 11 00 a6 01 00-                        |........|

net.c:671:Received packet
0000 fd 00 00 ea 00 00 00 00-00                      |........ .|

dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe350, 0x7fffa99fe354, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
dblib.c:4601:dbsqlok() end status was success
dblib.c:1599:dbresults(0xfbadcc0)
dblib.c:1608:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:1243:dbcmd(0xfb9b3f0, select * from tmpreq)
dblib.c:1250:dbcmd() bufsz = 52
dblib.c:5727:dbfreebuf(0xfb9b3f0)
dblib.c:1298:dbsqlexec(0xfb9b3f0)
dblib.c:6722:dbsqlsend(0xfb9b3f0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 0f 01 00 22 00 00 00 00-21 15 00 00 00 00 73 65 |...".... !.....se|
0010 6c 65 63 74 20 2a 20 66-72 6f 6d 20 74 6d 70 72 |lect * f rom tmpr|
0020 65 71                  -                        |eq|

dblib.c:4532:dbsqlok(0xfb9b3f0)
net.c:592:Received header
0000 04 01 00 79 00 00 00 00-                        |...y....|

net.c:671:Received packet
0000 61 52 00 00 00 02 00 00-06 61 73 70 69 72 65 03 |aR...... .aspire.|
0010 64 62 6f 06 74 6d 70 72-65 71 0a 72 65 71 75 65 |dbo.tmpr eq.reque|
0020 73 74 5f 69 64 10 00 00-00 07 00 00 00 38 00 00 |st_id... .....8..|
0030 06 61 73 70 69 72 65 03-64 62 6f 06 74 6d 70 72 |.aspire. dbo.tmpr|
0040 65 71 09 62 75 79 5f 70-72 69 63 65 30 00 00 00 |eq.buy_p rice0...|
0050 02 00 00 00 27 14 00 ae-02 00 00 00 d1 85 2e 12 |....'... ........|
0060 00 06 80 34 34 2e 33 30-fd 10 00 02 00 01 00 00 |...44.30 ........|
0070 00                     -                        |.|

dblib.c:4556:dbsqlok() exits on result token 0x61
dblib.c:1599:dbresults(0xfb9b3f0)
dblib.c:1608:dbresults: dbresults_state is 0 (_DB_RES_INIT)
token.c:495:tds_process_tokens(0xfb9be10, 0x7fffa99fe334, 0x7fffa99fe330, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  61(ROWFMT2)
token.c:1713:tds5_process_result
mem.c:563:tds_free_all_results()
token.c:1737:num_cols=2
token.c:1840:col 0:
token.c:1841:   column_name=[request_id]
token.c:1847:   flags=10 utype=7 type=56 varint=0
token.c:1850:   colsize=4 prec=0 scale=0
token.c:1840:col 1:
token.c:1841:   column_name=[buy_price]
token.c:1847:   flags=30 utype=2 type=39 varint=1
token.c:1850:   colsize=20 prec=0 scale=0
util.c:162:Changed query state from READING to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_ROWFMT_RESULT
token.c:495:tds_process_tokens(0xfb9be10, 0x7fffa99fe334, 0x7fffa99fe330, 
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  ae(CONTROL)
token.c:108:tds_process_default_tokens() marker is ae(CONTROL)
token.c:223:Eating CONTROL token
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:621:tds_process_tokens::SET_RETURN stopping on current token
util.c:162:Changed query state from READING to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
                        result_type TDS_ROW_RESULT
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:1745:dbnumcols(0xfb9b3f0)
bcp.c:138:bcp_init(0xfbadcc0, tmpreq, NULL, NULL, 1)
bcp.c:3584:_bcp_free_storage(0xfbadcc0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 51 bytes of "SET FMTONLY ON select * 
from tmpreq SET FMTONLY OFF"
write.c:164:tds_put_string wrote 102 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 6e 00 00 01 00-53 00 45 00 54 00 20 00 |...n.... S.E.T. .|
0010 46 00 4d 00 54 00 4f 00-4e 00 4c 00 59 00 20 00 |F.M.T.O. N.L.Y. .|
0020 4f 00 4e 00 20 00 73 00-65 00 6c 00 65 00 63 00 |O.N. .s. e.l.e.c.|
0030 74 00 20 00 2a 00 20 00-66 00 72 00 6f 00 6d 00 |t. .*. . f.r.o.m.|
0040 20 00 74 00 6d 00 70 00-72 00 65 00 71 00 20 00 | .t.m.p. r.e.q. .|
0050 53 00 45 00 54 00 20 00-46 00 4d 00 54 00 4f 00 |S.E.T. . F.M.T.O.|
0060 4e 00 4c 00 59 00 20 00-4f 00 46 00 46 00       |N.L.Y. . O.F.F.|

token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe334, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 5f 00 a6 01 00-                        |..._....|

net.c:671:Received packet
0000 fd 01 00 b9 00 00 00 00-00 81 02 00 00 00 08 00 |........ ........|
0010 38 0a 72 00 65 00 71 00-75 00 65 00 73 00 74 00 |8.r.e.q. u.e.s.t.|
0020 5f 00 69 00 64 00 00 00-0b 00 a7 14 00 09 04 c0 |_.i.d... ........|
0030 00 00 09 62 00 75 00 79-00 5f 00 70 00 72 00 69 |...b.u.y ._.p.r.i|
0040 00 63 00 65 00 fd 11 00-c1 00 00 00 00 00 fd 00 |.c.e.... ........|
0050 00 ba 00 00 00 00 00   -                        |.......|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe334, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (2 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info: 
        colname = request_id (10 bytes)
        type = 56 (int)
        server's type = 56 (int)
        column_varint_size = 0
        column_size = 4 (4 on server)
token.c:1555:setting up column 1
token.c:3294:adjust_character_column_size:
        Server charset: CP1252
        Server column_size: 20
        Client charset: ISO-8859-1
        Client column_size: 20
token.c:1490:tds7_get_data_info: 
        colname = buy_price (9 bytes)
        type = 39 (varchar)
        server's type = 167 (xvarchar)
        column_varint_size = 2
        column_size = 20 (20 on server)
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe334, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 1
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe334, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe334, (nil), 0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:2741:dbcoltype(0xfb9b3f0, 1)
dblib.c:2957:dbcollen(0xfb9b3f0, 1)
dblib.c:2509:dbbind(0xfb9b3f0, 1, 8, 4, 0xfbe26c0)
dblib.c:2722:dbwillconvert(56, 56)
convert.c:2845:tds_willconvert()
convert.c:2849:tds_willconvert() 56 56 1
dblib.c:2613:dbnullbind(0xfb9b3f0, 1, 0xfbaebe8)
dblib.c:6103:dbprtype(56)
bcp.c:3076:bcp_bind(0xfbadcc0, 0xfbe26c0, 0, -1 -- (nil), 0, int, 1)
dblib.c:2741:dbcoltype(0xfb9b3f0, 2)
dblib.c:2957:dbcollen(0xfb9b3f0, 2)
dblib.c:2509:dbbind(0xfb9b3f0, 2, 2, 21, 0xfbe2720)
dblib.c:2722:dbwillconvert(39, 47)
convert.c:2845:tds_willconvert()
convert.c:2849:tds_willconvert() 39 47 1
dblib.c:2613:dbnullbind(0xfb9b3f0, 2, 0xfbe2708)
dblib.c:6103:dbprtype(47)
bcp.c:3076:bcp_bind(0xfbadcc0, 0xfbe2720, 0, -1 -- (nil), 0, char, 2)
dblib.c:1948:dbnextrow(0xfb9b3f0)
dblib.c:1961:dbnextrow() dbresults_state = 2 (_DB_RES_RESULTSET_ROWS)
token.c:495:tds_process_tokens(0xfb9be10, 0x7fffa99fe33c, (nil), 0x1508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:2166:tds_process_row(): reading column 0 
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4 
token.c:2166:tds_process_row(): reading column 1 
token.c:1915:tds_get_data: type 39, varint size 1
token.c:1975:tds_get_data(): wire column size is 6 
util.c:162:Changed query state from READING to PENDING
buffering.h:231:buffer_transfer_bound_data(0xfb9b400 4040 -1 0xfb9b3f0 0)
dblib.c:7083:copy_data_to_host_var(56 [SYBINT4] len 4 => 56 [SYBINT4] len 4)
dblib.c:7100:copy_data_to_host_var() srctype == desttype
dblib.c:7083:copy_data_to_host_var(39 [SYBVARCHAR] len 6 => 47 [SYBCHAR] len 
21)
dblib.c:7100:copy_data_to_host_var() srctype == desttype
dblib.c:2030:leaving dbnextrow() returning REG_ROW/MORE_ROWS
bcp.c:315:bcp_collen(0xfbadcc0, -1, 1)
bcp.c:315:bcp_collen(0xfbadcc0, 6, 2)
bcp.c:1821:bcp_sendrow(0xfbadcc0)
bcp.c:2119:_bcp_start_copy_in(0xfbadcc0)
bcp.c:2319:_bcp_build_bulk_insert_stmt(0xfbae5c0, 0x7fffa99fe300, 0xfbe1d80, 
1)
bcp.c:2319:_bcp_build_bulk_insert_stmt(0xfbae5c0, 0x7fffa99fe300, 0xfbe2220, 
0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 59 bytes of "insert bulk tmpreq 
(request_id int, buy_price varchar(20)) "
write.c:164:tds_put_string wrote 118 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 7e 00 00 01 00-69 00 6e 00 73 00 65 00 |...~.... i.n.s.e.|
0010 72 00 74 00 20 00 62 00-75 00 6c 00 6b 00 20 00 |r.t. .b. u.l.k. .|
0020 74 00 6d 00 70 00 72 00-65 00 71 00 20 00 28 00 |t.m.p.r. e.q. .(.|
0030 72 00 65 00 71 00 75 00-65 00 73 00 74 00 5f 00 |r.e.q.u. e.s.t._.|
0040 69 00 64 00 20 00 69 00-6e 00 74 00 2c 00 20 00 |i.d. .i. n.t.,. .|
0050 62 00 75 00 79 00 5f 00-70 00 72 00 69 00 63 00 |b.u.y._. p.r.i.c.|
0060 65 00 20 00 76 00 61 00-72 00 63 00 68 00 61 00 |e. .v.a. r.c.h.a.|
0070 72 00 28 00 32 00 30 00-29 00 29 00 20 00       |r.(.2.0. ).). .|

token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fd2d4, 0x7fffa99fd2d0, 
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 a6 01 00-                        |........|

net.c:671:Received packet
0000 fd 00 00 fd 00 00 00 00-00                      |........ .|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fd2d4, 0x7fffa99fd2d0, 
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
bcp.c:2284:current_record_size = 32
bcp.c:2285:bcp_record_size     = 26
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
bcp.c:2529:_bcp_send_colmetadata(0xfbadcc0)
write.c:136:tds_put_string converting 10 bytes of "request_id"
write.c:164:tds_put_string wrote 20 bytes
write.c:136:tds_put_string converting 9 bytes of "buy_price"
write.c:164:tds_put_string wrote 18 bytes
bcp.c:3189:_bcp_send_bcp_record(0xfbadcc0, 1)
bcp.c:3403:_bcp_get_col_data(0xfbadcc0, 0xfbe1d80)
dblib.c:2141:dbconvert(0xfbadcc0, SYBINT4, 0xfbe26c0, 4, SYBINT4, 0xfbaeab0, 
4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3219:parsed column 1, length 4 (not null)
bcp.c:3285:new_record_size = 0 datalen = 4 
bcp.c:3309:old_record_size = 32 new size = 4 
bcp.c:3403:_bcp_get_col_data(0xfbadcc0, 0xfbe2220)
dblib.c:2141:dbconvert(0xfbadcc0, SYBCHAR, 0xfbe2720, 6, SYBVARCHAR, 
0xfbaeb70, 20)
bcp.c:3219:parsed column 2, length 6 (not null)
bcp.c:3285:new_record_size = 6 datalen = 6 
bcp.c:3309:old_record_size = 32 new size = 12 
dblib.c:1948:dbnextrow(0xfb9b3f0)
dblib.c:1961:dbnextrow() dbresults_state = 2 (_DB_RES_RESULTSET_ROWS)
token.c:495:tds_process_tokens(0xfb9be10, 0x7fffa99fe33c, (nil), 0x1508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 1
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 1
util.c:110:logic error: cannot change query state from IDLE to PENDING
dblib.c:2030:leaving dbnextrow() returning NO_MORE_ROWS
bcp.c:3025:bcp_done(0xfbadcc0)
net.c:779:Sending packet
0000 07 01 00 51 00 00 01 00-81 02 00 00 00 08 00 38 |...Q.... .......8|
0010 0a 72 00 65 00 71 00 75-00 65 00 73 00 74 00 5f |.r.e.q.u .e.s.t._|
0020 00 69 00 64 00 00 00 0b-00 a7 14 00 09 04 c0 00 |.i.d.... ........|
0030 00 09 62 00 75 00 79 00-5f 00 70 00 72 00 69 00 |..b.u.y. _.p.r.i.|
0040 63 00 65 00 d1 85 2e 12-00 06 00 80 34 34 2e 33 |c.e..... ....44.3|
0050 30                     -                        |0|

util.c:162:Changed query state from QUERYING to PENDING
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe324, 0x7fffa99fe320, 
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 a6 01 00-                        |........|

net.c:671:Received packet
0000 fd 10 00 f0 00 01 00 00-00                      |........ .|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 1
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 1
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xfbae5c0, 0x7fffa99fe324, 0x7fffa99fe320, 
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
bcp.c:3584:_bcp_free_storage(0xfbadcc0)
dblib.c:1372:dbclose(0xfb9b3f0)
dblib.c:256:dblib_del_connection(0x2b8901306060, 0xfb9be10)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
dblib.c:303:dblib_release_tds_ctx(1)
dblib.c:5727:dbfreebuf(0xfb9b3f0)
dblib.c:1372:dbclose(0xfbadcc0)
dblib.c:256:dblib_del_connection(0x2b8901306060, 0xfbae5c0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
dblib.c:303:dblib_release_tds_ctx(1)
dblib.c:5727:dbfreebuf(0xfbadcc0)