FreeTDS Development Group

[Panos Stavroulis <pstavroulis AT yahoo.co.uk>]

Hi Bill,

I've added some more debugging. See below. It looks like the bytes read are 0:

bcp.c:3463:_bcp_get_col_data bytes_read: 0, 

I hope the below gives you more clues why it goes wrong. This specific 
problem is indirectly related to a date field, if I include a date field in 
the bcp table then the next field fails sometimes.

I think bcp does SET FMTONLY to read the table definition. If I define my 
column 10 as char and not as date then it doesn't fail the conversion for 
next field. I am pretty happy that the data passed to the bcp are valid. Hope 
that gives you some clues why it goes wrong but if you need more debug 
statements etc then let me know.

Thanks very much.

Panos

token.c:495:tds_process_tokens(47c68, ffbfb47c, ffbfb478, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 3b 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(47c68, ffbfb47c, ffbfb478, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
bcp.c:2282:current_record_size = 192
bcp.c:2283:bcp_record_size     = 205
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
bcp.c:2527:_bcp_send_colmetadata(45c80)
write.c:136:tds_put_string converting 11 bytes of "proc_number"
write.c:164:tds_put_string wrote 22 bytes
write.c:136:tds_put_string converting 10 bytes of "journal_no"
write.c:164:tds_put_string wrote 20 bytes
write.c:136:tds_put_string converting 11 bytes of "journal_pos"
write.c:164:tds_put_string wrote 22 bytes
write.c:136:tds_put_string converting 15 bytes of "ledger_code_wil"
write.c:164:tds_put_string wrote 30 bytes
write.c:136:tds_put_string converting 6 bytes of "source"
write.c:164:tds_put_string wrote 12 bytes
write.c:136:tds_put_string converting 3 bytes of "ccy"
write.c:164:tds_put_string wrote 6 bytes
write.c:136:tds_put_string converting 12 bytes of "account_code"
write.c:164:tds_put_string wrote 24 bytes
write.c:136:tds_put_string converting 5 bytes of "cat_1"
write.c:164:tds_put_string wrote 10 bytes
write.c:136:tds_put_string converting 5 bytes of "cat_2"
write.c:164:tds_put_string wrote 10 bytes
write.c:136:tds_put_string converting 16 bytes of "transaction_date"
write.c:164:tds_put_string wrote 32 bytes
write.c:136:tds_put_string converting 9 bytes of "reference"
write.c:164:tds_put_string wrote 18 bytes
write.c:136:tds_put_string converting 9 bytes of "narrative"
write.c:164:tds_put_string wrote 18 bytes
write.c:136:tds_put_string converting 12 bytes of "db_ccy_value"
write.c:164:tds_put_string wrote 24 bytes
write.c:136:tds_put_string converting 13 bytes of "db_base_value"
write.c:164:tds_put_string wrote 26 bytes
write.c:136:tds_put_string converting 4 bytes of "rate"
write.c:164:tds_put_string wrote 8 bytes
write.c:136:tds_put_string converting 11 bytes of "calc_method"
write.c:164:tds_put_string wrote 22 bytes
write.c:136:tds_put_string converting 6 bytes of "period"
write.c:164:tds_put_string wrote 12 bytes
write.c:136:tds_put_string converting 11 bytes of "proc_action"
write.c:164:tds_put_string wrote 22 bytes
bcp.c:3190:_bcp_send_bcp_record(45c80, 1)
bcp.c:3404:_bcp_get_col_data(45c80, 591118)
dblib.c:2144:dbconvert(45c80, SYBINT4, fd2a4fd0, 4, SYBINT4, 49590, 4)
dblib.c:2177:dbconvert() srctype == desttype
bcp.c:3220:parsed column 1, length 4 (not null)
bcp.c:3286:new_record_size = 0 datalen = 4 
bcp.c:3310:old_record_size = 205 new size = 4 
bcp.c:3404:_bcp_get_col_data(45c80, 591590)
dblib.c:2144:dbconvert(45c80, SYBINT4, fd2a4fd4, 4, SYBINT4, 495b0, 4)
dblib.c:2177:dbconvert() srctype == desttype
bcp.c:3220:parsed column 2, length 4 (not null)
bcp.c:3286:new_record_size = 4 datalen = 4 
bcp.c:3310:old_record_size = 205 new size = 8 
bcp.c:3404:_bcp_get_col_data(45c80, 591a08)
dblib.c:2144:dbconvert(45c80, SYBINT4, fd2a4fd8, 4, SYBINT4, 2da58, 4)
dblib.c:2177:dbconvert() srctype == desttype
bcp.c:3220:parsed column 3, length 4 (not null)
bcp.c:3286:new_record_size = 8 datalen = 4 
bcp.c:3310:old_record_size = 205 new size = 12 
bcp.c:3404:_bcp_get_col_data(45c80, 591e80)
bcp.c:3521:bufpos = 0 , value =>T< 
bcp.c:3521:bufpos = 1 , value =>D< 
bcp.c:3521:bufpos = 2 , value =>1< 
bcp.c:3463:_bcp_get_col_data bytes_read: 3, terminator>à< 
bcp.c:3469:_bcp_get_col_data collen: -1, 
dblib.c:2144:dbconvert(45c80, SYBCHAR, fd2a4fdc, -1, SYBCHAR, 589c60, 4)
dblib.c:2177:dbconvert() srctype == desttype
bcp.c:3220:parsed column 4, length 3 (not null)
bcp.c:3286:new_record_size = 14 datalen = 3 
bcp.c:3310:old_record_size = 205 new size = 17 
bcp.c:3404:_bcp_get_col_data(45c80, 5922f8)
bcp.c:3521:bufpos = 0 , value =>V< 
bcp.c:3521:bufpos = 1 , value =>D< 
bcp.c:3521:bufpos = 2 , value =>A< 
bcp.c:3521:bufpos = 3 , value =>C< 
bcp.c:3463:_bcp_get_col_data bytes_read: 4, terminator>0< 
bcp.c:3469:_bcp_get_col_data collen: -1, 
dblib.c:2144:dbconvert(45c80, SYBCHAR, fd2a4fe1, -1, SYBCHAR, 589d70, 4)
dblib.c:2177:dbconvert() srctype == desttype
bcp.c:3220:parsed column 5, length 4 (not null)
bcp.c:3286:new_record_size = 19 datalen = 4 
bcp.c:3310:old_record_size = 205 new size = 23 
bcp.c:3404:_bcp_get_col_data(45c80, 592770)
bcp.c:3521:bufpos = 0 , value =>G< 
bcp.c:3521:bufpos = 1 , value =>B< 
bcp.c:3521:bufpos = 2 , value =>P< 
bcp.c:3463:_bcp_get_col_data bytes_read: 3, terminator>À< 
bcp.c:3469:_bcp_get_col_data collen: -1, 
dblib.c:2144:dbconvert(45c80, SYBCHAR, fd2a4fe6, -1, SYBCHAR, 589d00, 3)
dblib.c:2177:dbconvert() srctype == desttype
bcp.c:3220:parsed column 6, length 3 (not null)
bcp.c:3286:new_record_size = 25 datalen = 3 
bcp.c:3310:old_record_size = 205 new size = 28 
bcp.c:3404:_bcp_get_col_data(45c80, 592be8)
bcp.c:3521:bufpos = 0 , value =>2< 
bcp.c:3521:bufpos = 1 , value =>1< 
bcp.c:3521:bufpos = 2 , value =>1< 
bcp.c:3521:bufpos = 3 , value =>0< 
bcp.c:3521:bufpos = 4 , value =>0< 
bcp.c:3521:bufpos = 5 , value =>0< 
bcp.c:3463:_bcp_get_col_data bytes_read: 6, terminator>€< 
bcp.c:3469:_bcp_get_col_data collen: -1, 
dblib.c:2144:dbconvert(45c80, SYBCHAR, fd2a4fea, -1, SYBCHAR, 4aa68, 16)
dblib.c:2177:dbconvert() srctype == desttype
bcp.c:3220:parsed column 7, length 6 (not null)
bcp.c:3286:new_record_size = 30 datalen = 6 
bcp.c:3310:old_record_size = 205 new size = 36 
bcp.c:3404:_bcp_get_col_data(45c80, 593060)
bcp.c:3521:bufpos = 0 , value =>B< 
bcp.c:3521:bufpos = 1 , value =>O< 
bcp.c:3521:bufpos = 2 , value =>O< 
bcp.c:3521:bufpos = 3 , value =>K< 
bcp.c:3521:bufpos = 4 , value =>1< 
bcp.c:3463:_bcp_get_col_data bytes_read: 5, terminator>P< 
bcp.c:3469:_bcp_get_col_data collen: -1, 
dblib.c:2144:dbconvert(45c80, SYBCHAR, fd2a4ffb, -1, SYBCHAR, 4a990, 12)
dblib.c:2177:dbconvert() srctype == desttype
bcp.c:3220:parsed column 8, length 5 (not null)
bcp.c:3286:new_record_size = 38 datalen = 5 
bcp.c:3310:old_record_size = 205 new size = 43 
bcp.c:3404:_bcp_get_col_data(45c80, 5934d8)
bcp.c:3521:bufpos = 0 , value =>G< 
bcp.c:3521:bufpos = 1 , value =>O< 
bcp.c:3521:bufpos = 2 , value =>L< 
bcp.c:3521:bufpos = 3 , value =>D< 
bcp.c:3521:bufpos = 4 , value =>M< 
bcp.c:3521:bufpos = 5 , value =>A< 
bcp.c:3521:bufpos = 6 , value =>N< 
bcp.c:3521:bufpos = 7 , value =>R< 
bcp.c:3521:bufpos = 8 , value =>T< 
bcp.c:3521:bufpos = 9 , value =>S< 
bcp.c:3521:bufpos = 10 , value =>T< 
bcp.c:3463:_bcp_get_col_data bytes_read: 11, terminator>Ð< 
bcp.c:3469:_bcp_get_col_data collen: -1, 
dblib.c:2144:dbconvert(45c80, SYBCHAR, fd2a5008, -1, SYBCHAR, 4a648, 12)
dblib.c:2177:dbconvert() srctype == desttype
bcp.c:3220:parsed column 9, length 11 (not null)
bcp.c:3286:new_record_size = 45 datalen = 11 
bcp.c:3310:old_record_size = 205 new size = 56 
bcp.c:3404:_bcp_get_col_data(45c80, 593950)
bcp.c:3521:bufpos = 0 , value =>2< 
bcp.c:3521:bufpos = 1 , value =>8< 
bcp.c:3521:bufpos = 2 , value => < 
bcp.c:3521:bufpos = 3 , value =>A< 
bcp.c:3521:bufpos = 4 , value =>p< 
bcp.c:3521:bufpos = 5 , value =>r< 
bcp.c:3521:bufpos = 6 , value => < 
bcp.c:3521:bufpos = 7 , value =>2< 
bcp.c:3521:bufpos = 8 , value =>0< 
bcp.c:3521:bufpos = 9 , value =>1< 
bcp.c:3521:bufpos = 10 , value =>1< 
bcp.c:3463:_bcp_get_col_data bytes_read: 11, terminator> < 
bcp.c:3469:_bcp_get_col_data collen: -1, 
dblib.c:2144:dbconvert(45c80, SYBTEXT, fd2a5015, -1, SYBDATETIME, 589cf0, 8)
dblib.c:2286:dbconvert() calling tds_convert
convert.c:1780:string_to_datetime: current_state = 0
convert.c:1801:string_to_datetime: is_numeric
convert.c:1780:string_to_datetime: current_state = 1
convert.c:2500:store_monthname: 3 Apr
convert.c:1780:string_to_datetime: current_state = 2
dblib.c:2289:dbconvert() called tds_convert returned 8
bcp.c:3220:parsed column 10, length 8 (not null)
bcp.c:3286:new_record_size = 56 datalen = 8 
bcp.c:3310:old_record_size = 205 new size = 64 
bcp.c:3404:_bcp_get_col_data(45c80, 593dc8)
bcp.c:3463:_bcp_get_col_data bytes_read: 0, terminator>à< 
bcp.c:3469:_bcp_get_col_data collen: -1, 
dblib.c:2144:dbconvert(45c80, SYBCHAR, fd2a5029, -1, SYBCHAR, 32510, 20)
dblib.c:2177:dbconvert() srctype == desttype
bcp.c:3216:_bcp_get_col_data (column 11) failed
bcp.c:3023:bcp_done(45c80)
net.c:779:Sending packet
0000 07 01 02 16 00 00 01 00-81 12 00 00 00 08 00 38 |........ .......8|
0010 0b 70 00 72 00 6f 00 63-00 5f 00 6e 00 75 00 6d |.p.r.o.c ._.n.u.m|
0020 00 62 00 65 00 72 00 00-00 08 00 38 0a 6a 00 6f |.b.e.r.. ...8.j.o|
0030 00 75 00 72 00 6e 00 61-00 6c 00 5f 00 6e 00 6f |.u.r.n.a .l._.n.o|
0040 00 00 00 08 00 38 0b 6a-00 6f 00 75 00 72 00 6e |.....8.j .o.u.r.n|
0050 00 61 00 6c 00 5f 00 70-00 6f 00 73 00 00 00 0a |.a.l._.p .o.s....|
0060 00 af 04 00 09 04 c0 00-00 0f 6c 00 65 00 64 00 |........ ..l.e.d.|
0070 67 00 65 00 72 00 5f 00-63 00 6f 00 64 00 65 00 |g.e.r._. c.o.d.e.|
0080 5f 00 77 00 69 00 6c 00-00 00 0a 00 af 04 00 09 |_.w.i.l. ........|
0090 04 c0 00 00 06 73 00 6f-00 75 00 72 00 63 00 65 |.....s.o .u.r.c.e|
00a0 00 00 00 0a 00 af 03 00-09 04 c0 00 00 03 63 00 |........ ......c.|
00b0 63 00 79 00 00 00 0a 00-af 10 00 09 04 c0 00 00 |c.y..... ........|
00c0 0c 61 00 63 00 63 00 6f-00 75 00 6e 00 74 00 5f |.a.c.c.o .u.n.t._|
00d0 00 63 00 6f 00 64 00 65-00 00 00 0b 00 af 0c 00 |.c.o.d.e ........|
00e0 09 04 c0 00 00 05 63 00-61 00 74 00 5f 00 31 00 |......c. a.t._.1.|
00f0 00 00 0b 00 af 0c 00 09-04 c0 00 00 05 63 00 61 |........ .....c.a|
0100 00 74 00 5f 00 32 00 00-00 08 00 3d 10 74 00 72 |.t._.2.. ...=.t.r|
0110 00 61 00 6e 00 73 00 61-00 63 00 74 00 69 00 6f |.a.n.s.a .c.t.i.o|
0120 00 6e 00 5f 00 64 00 61-00 74 00 65 00 00 00 0a |.n._.d.a .t.e....|
0130 00 af 14 00 09 04 c0 00-00 09 72 00 65 00 66 00 |........ ..r.e.f.|
0140 65 00 72 00 65 00 6e 00-63 00 65 00 00 00 0a 00 |e.r.e.n. c.e.....|
0150 a7 3c 00 09 04 c0 00 00-09 6e 00 61 00 72 00 72 |.<...... .n.a.r.r|
0160 00 61 00 74 00 69 00 76-00 65 00 00 00 08 00 3e |.a.t.i.v .e.....>|
0170 0c 64 00 62 00 5f 00 63-00 63 00 79 00 5f 00 76 |.d.b._.c .c.y._.v|
0180 00 61 00 6c 00 75 00 65-00 00 00 08 00 3e 0d 64 |.a.l.u.e .....>.d|
0190 00 62 00 5f 00 62 00 61-00 73 00 65 00 5f 00 76 |.b._.b.a .s.e._.v|
01a0 00 61 00 6c 00 75 00 65-00 00 00 08 00 3e 04 72 |.a.l.u.e .....>.r|
01b0 00 61 00 74 00 65 00 00-00 0a 00 af 01 00 09 04 |.a.t.e.. ........|
01c0 c0 00 00 0b 63 00 61 00-6c 00 63 00 5f 00 6d 00 |....c.a. l.c._.m.|
01d0 65 00 74 00 68 00 6f 00-64 00 00 00 0a 00 af 06 |e.t.h.o. d.......|
01e0 00 09 04 c0 00 00 06 70-00 65 00 72 00 69 00 6f |.......p .e.r.i.o|
01f0 00 64 00 00 00 0a 00 af-01 00 09 04 c0 00 00 0b |.d...... ........|
0200 70 00 72 00 6f 00 63 00-5f 00 61 00 63 00 74 00 |p.r.o.c. _.a.c.t.|
0210 69 00 6f 00 6e 00      -                        |i.o.n.|

util.c:162:Changed query state from QUERYING to PENDING
token.c:495:tds_process_tokens(47c68, ffbfc494, ffbfc490, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 3b 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(47c68, ffbfc494, ffbfc490, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
bcp.c:3589:_bcp_free_storage(45c80)
dblib.c:3096:dbcancel(45c80)
query.c:1934:tds_send_cancel: not in_cancel and idle
dblib.c:3878:dbgetmaxprocs(void)
dblib.c:3878:dbgetmaxprocs(void)
dblib.c:4750:dbdead(45c80) [alive]
dblib.c:5611:dbsetuserdata(45c80, 5eaa0)
bcp.c:3023:bcp_done(45c80)
dblib.c:7785:dbperror(45c80, 20076, 0)
dblib.c:7838:20076: "bcp_init must be called before any other bcp routines"
00000092 2011/06/22 05:59:21.437 TEMP 16139 SERI                             
DATABASE ERROR:: bcp_init must be called before any other bcp routines
00000093 2011/06/22 05:59:21.437 TEMP 16139 SERI                             
DATABASE ERROR:: Error 0
dblib.c:7859:"bcp_init must be called before any other bcp routines", client 
returns 2 (INT_CANCEL)--- On Fri, 17/6/11, Panos Stavroulis 
<pstavroulis AT yahoo.co.uk> wrote:

> From: Panos Stavroulis <pstavroulis AT yahoo.co.uk>
> Subject: Re: [freetds] bcp problems
> To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
> Date: Friday, 17 June, 2011, 11:36
> Hi Bill,
> 
> Sorry was working on something else and didn't look into
> this further. The date field is a 31 char length. Then it
> fails to read the next field. It uses 11 chars to store the
> date and the rest 20 chars is \0. I am not expecting
> multiple \0 to cause a problem?
> 
> For test purposes, I've actually moved the date field to
> the end of the structure and that works better, but falls
> over later. 
> 
> I am trying to fix it for now, maybe by not using a date
> field and then once it's working will try to get to the
> bottom of this and will send some more information. Dates
> and bcp are working in other places so it's odd that it
> doesn't work here.
> 
> Thank you,
> 
> Panos
> 
> --- On Thu, 16/6/11, Thompson, William <bill.d.thompson AT baml.com>
> wrote:
> 
> > From: Thompson, William <bill.d.thompson AT baml.com>
> > Subject: Re: [freetds] bcp problems
> > To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
> > Date: Thursday, 16 June, 2011, 16:02
> > Hi Panos,
> > 
> > for the character field after the datetime field, are
> you
> > using a field terminator other than "\0" by any chance
> ?
> > This would explain the issue...and expose an obscure
> > bug...
> > 
> > Bill
> > 
> > -----Original Message-----
> > From: freetds-bounces AT lists.ibiblio.org
> > [mailto:freetds-bounces AT lists.ibiblio.org]
> > On Behalf Of Panos Stavroulis
> > Sent: 15 June 2011 12:49
> > To: freetds AT lists.ibiblio.org
> > Subject: [Warning: Retiring Address: thompbil AT exchange.uk.ml.com]
> > [freetds] bcp problems
> > 
> > 
> > Hi,
> > 
> > I have a bcp problem with around a date field. This
> is
> > probably a question for Bill but thought he should get
> a
> > rest!
> > 
> > See the below. I have a date 1 Feb 2011 followed by a
> field
> > called reference with the value 00000000000000000549.
> I've
> > put a debug statement to be able to see the data. So
> my date
> > field looks ok 1 Feb 2011, however, after this field
> is
> > processed, it fails. Column No 11 doesn't get
> processed as
> > you can see. Does anyone have any clues what might be
> wrong?
> > Bcp works normally OK but occasioanaly get problems
> with
> > date fields like now.
> > 
> > I think, you can ignore the   error
> > "bcp_init must be called before any other bcp
> routines". I
> > believe I know how to fix this. The problem is bcp
> doesn't
> > go after column 11.
> > 
> > I am using stable freetds-0.82. I've noticed few
> changes in
> > the current CVS branch for bcp but not how much it
> will help
> > and if stable enough.
> > Thanks very much.
> > 
> > Panos
> > 
> > output:
> > 
> > util.c:162:Changed query state from IDLE to QUERYING
> > write.c:136:tds_put_string converting 364 bytes of
> "insert
> > bulk #trans_bcp (proc_number int, journal_no int,
> > journal_pos int, ledger_code_wil char(4), source
> char(4),
> > ccy char(3), account_code char(16), cat_1 char(12),
> cat_2
> > char(12), transaction_date datetime, reference
> char(20),
> > narrative varchar(60), db_ccy_value float,
> db_base_value
> > float, rate float, calc_method char(1), period
> char(6),
> > proc_action char(1)) "
> > write.c:136:tds_put_string converting 236 bytes of
> > "account_code char(16), cat_1 char(12), cat_2
> char(12),
> > transaction_date datetime, reference char(20),
> narrative
> > varchar(60), db_ccy_value float, db_base_value float,
> rate
> > float, calc_method char(1), period char(6),
> proc_action
> > char(1)) "
> > write.c:136:tds_put_string converting 108 bytes of
> > "ccy_value float, db_base_value float, rate float,
> > calc_method char(1), period char(6), proc_action
> char(1)) "
> > write.c:164:tds_put_string wrote 728 bytes
> > util.c:162:Changed query state from QUERYING to
> PENDING
> > net.c:779:Sending packet
> > 0000 01 01 02 e0 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 23 00 74 00 72 00 61 00-6e 00 73 00 5f 00 62 00
> > |#.t.r.a. n.s._.b.|
> > 0030 63 00 70 00 20 00 28 00-70 00 72 00 6f 00 63 00
> |c.p.
> > .(. p.r.o.c.|
> > 0040 5f 00 6e 00 75 00 6d 00-62 00 65 00 72 00 20 00
> > |_.n.u.m. b.e.r. .|
> > 0050 69 00 6e 00 74 00 2c 00-20 00 6a 00 6f 00 75 00
> > |i.n.t.,.  .j.o.u.|
> > 0060 72 00 6e 00 61 00 6c 00-5f 00 6e 00 6f 00 20 00
> > |r.n.a.l. _.n.o. .|
> > 0070 69 00 6e 00 74 00 2c 00-20 00 6a 00 6f 00 75 00
> > |i.n.t.,.  .j.o.u.|
> > 0080 72 00 6e 00 61 00 6c 00-5f 00 70 00 6f 00 73 00
> > |r.n.a.l. _.p.o.s.|
> > 0090 20 00 69 00 6e 00 74 00-2c 00 20 00 6c 00 65 00
> |
> > .i.n.t. ,. .l.e.|
> > 00a0 64 00 67 00 65 00 72 00-5f 00 63 00 6f 00 64 00
> > |d.g.e.r. _.c.o.d.|
> > 00b0 65 00 5f 00 77 00 69 00-6c 00 20 00 63 00 68 00
> > |e._.w.i. l. .c.h.|
> > 00c0 61 00 72 00 28 00 34 00-29 00 2c 00 20 00 73 00
> > |a.r.(.4. ).,. .s.|
> > 00d0 6f 00 75 00 72 00 63 00-65 00 20 00 63 00 68 00
> > |o.u.r.c. e. .c.h.|
> > 00e0 61 00 72 00 28 00 34 00-29 00 2c 00 20 00 63 00
> > |a.r.(.4. ).,. .c.|
> > 00f0 63 00 79 00 20 00 63 00-68 00 61 00 72 00 28 00
> |c.y.
> > .c. h.a.r.(.|
> > 0100 33 00 29 00 2c 00 20 00-61 00 63 00 63 00 6f 00
> > |3.).,. . a.c.c.o.|
> > 0110 75 00 6e 00 74 00 5f 00-63 00 6f 00 64 00 65 00
> > |u.n.t._. c.o.d.e.|
> > 0120 20 00 63 00 68 00 61 00-72 00 28 00 31 00 36 00
> |
> > .c.h.a. r.(.1.6.|
> > 0130 29 00 2c 00 20 00 63 00-61 00 74 00 5f 00 31 00
> |).,.
> > .c. a.t._.1.|
> > 0140 20 00 63 00 68 00 61 00-72 00 28 00 31 00 32 00
> |
> > .c.h.a. r.(.1.2.|
> > 0150 29 00 2c 00 20 00 63 00-61 00 74 00 5f 00 32 00
> |).,.
> > .c. a.t._.2.|
> > 0160 20 00 63 00 68 00 61 00-72 00 28 00 31 00 32 00
> |
> > .c.h.a. r.(.1.2.|
> > 0170 29 00 2c 00 20 00 74 00-72 00 61 00 6e 00 73 00
> |).,.
> > .t. r.a.n.s.|
> > 0180 61 00 63 00 74 00 69 00-6f 00 6e 00 5f 00 64 00
> > |a.c.t.i. o.n._.d.|
> > 0190 61 00 74 00 65 00 20 00-64 00 61 00 74 00 65 00
> > |a.t.e. . d.a.t.e.|
> > 01a0 74 00 69 00 6d 00 65 00-2c 00 20 00 72 00 65 00
> > |t.i.m.e. ,. .r.e.|
> > 01b0 66 00 65 00 72 00 65 00-6e 00 63 00 65 00 20 00
> > |f.e.r.e. n.c.e. .|
> > 01c0 63 00 68 00 61 00 72 00-28 00 32 00 30 00 29 00
> > |c.h.a.r. (.2.0.).|
> > 01d0 2c 00 20 00 6e 00 61 00-72 00 72 00 61 00 74 00
> |,.
> > .n.a. r.r.a.t.|
> > 01e0 69 00 76 00 65 00 20 00-76 00 61 00 72 00 63 00
> > |i.v.e. . v.a.r.c.|
> > 01f0 68 00 61 00 72 00 28 00-36 00 30 00 29 00 2c 00
> > |h.a.r.(. 6.0.).,.|
> > 0200 20 00 64 00 62 00 5f 00-63 00 63 00 79 00 5f 00
> |
> > .d.b._. c.c.y._.|
> > 0210 76 00 61 00 6c 00 75 00-65 00 20 00 66 00 6c 00
> > |v.a.l.u. e. .f.l.|
> > 0220 6f 00 61 00 74 00 2c 00-20 00 64 00 62 00 5f 00
> > |o.a.t.,.  .d.b._.|
> > 0230 62 00 61 00 73 00 65 00-5f 00 76 00 61 00 6c 00
> > |b.a.s.e. _.v.a.l.|
> > 0240 75 00 65 00 20 00 66 00-6c 00 6f 00 61 00 74 00
> |u.e.
> > .f. l.o.a.t.|
> > 0250 2c 00 20 00 72 00 61 00-74 00 65 00 20 00 66 00
> |,.
> > .r.a. t.e. .f.|
> > 0260 6c 00 6f 00 61 00 74 00-2c 00 20 00 63 00 61 00
> > |l.o.a.t. ,. .c.a.|
> > 0270 6c 00 63 00 5f 00 6d 00-65 00 74 00 68 00 6f 00
> > |l.c._.m. e.t.h.o.|
> > 0280 64 00 20 00 63 00 68 00-61 00 72 00 28 00 31 00
> |d.
> > .c.h. a.r.(.1.|
> > 0290 29 00 2c 00 20 00 70 00-65 00 72 00 69 00 6f 00
> |).,.
> > .p. e.r.i.o.|
> > 02a0 64 00 20 00 63 00 68 00-61 00 72 00 28 00 36 00
> |d.
> > .c.h. a.r.(.6.|
> > 02b0 29 00 2c 00 20 00 70 00-72 00 6f 00 63 00 5f 00
> |).,.
> > .p. r.o.c._.|
> > 02c0 61 00 63 00 74 00 69 00-6f 00 6e 00 20 00 63 00
> > |a.c.t.i. o.n. .c.|
> > 02d0 68 00 61 00 72 00 28 00-31 00 29 00 29 00 20 00
> > |h.a.r.(. 1.).). .|
> > 
> > token.c:495:tds_process_tokens(45c80, ffbfb40c,
> ffbfb408,
> > 0x100)
> > util.c:162:Changed query state from PENDING to
> READING
> > net.c:592:Received header
> > 0000 04 01 00 11 00 57 01 00-       
> >                
> > |.....W..|
> > 
> > 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(45c80, ffbfb40c,
> ffbfb408,
> > 0x100)
> > token.c:498:tds_process_tokens() state is COMPLETED
> > bcp.c:2282:current_record_size = 192
> > bcp.c:2283:bcp_record_size     = 205
> > mem.c:563:tds_free_all_results()
> > util.c:162:Changed query state from IDLE to QUERYING
> > bcp.c:2527:_bcp_send_colmetadata(46eb0)
> > write.c:136:tds_put_string converting 11 bytes of
> > "proc_number"
> > write.c:164:tds_put_string wrote 22 bytes
> > write.c:136:tds_put_string converting 10 bytes of
> > "journal_no"
> > write.c:164:tds_put_string wrote 20 bytes
> > write.c:136:tds_put_string converting 11 bytes of
> > "journal_pos"
> > write.c:164:tds_put_string wrote 22 bytes
> > write.c:136:tds_put_string converting 15 bytes of
> > "ledger_code_wil"
> > write.c:164:tds_put_string wrote 30 bytes
> > write.c:136:tds_put_string converting 6 bytes of
> "source"
> > write.c:164:tds_put_string wrote 12 bytes
> > write.c:136:tds_put_string converting 3 bytes of
> "ccy"
> > write.c:164:tds_put_string wrote 6 bytes
> > write.c:136:tds_put_string converting 12 bytes of
> > "account_code"
> > write.c:164:tds_put_string wrote 24 bytes
> > write.c:136:tds_put_string converting 5 bytes of
> "cat_1"
> > write.c:164:tds_put_string wrote 10 bytes
> > write.c:136:tds_put_string converting 5 bytes of
> "cat_2"
> > write.c:164:tds_put_string wrote 10 bytes
> > write.c:136:tds_put_string converting 16 bytes of
> > "transaction_date"
> > write.c:164:tds_put_string wrote 32 bytes
> > write.c:136:tds_put_string converting 9 bytes of
> > "reference"
> > write.c:164:tds_put_string wrote 18 bytes
> > write.c:136:tds_put_string converting 9 bytes of
> > "narrative"
> > write.c:164:tds_put_string wrote 18 bytes
> > write.c:136:tds_put_string converting 12 bytes of
> > "db_ccy_value"
> > write.c:164:tds_put_string wrote 24 bytes
> > write.c:136:tds_put_string converting 13 bytes of
> > "db_base_value"
> > write.c:164:tds_put_string wrote 26 bytes
> > write.c:136:tds_put_string converting 4 bytes of
> "rate"
> > write.c:164:tds_put_string wrote 8 bytes
> > write.c:136:tds_put_string converting 11 bytes of
> > "calc_method"
> > write.c:164:tds_put_string wrote 22 bytes
> > write.c:136:tds_put_string converting 6 bytes of
> "period"
> > write.c:164:tds_put_string wrote 12 bytes
> > write.c:136:tds_put_string converting 11 bytes of
> > "proc_action"
> > write.c:164:tds_put_string wrote 22 bytes
> > bcp.c:3187:_bcp_send_bcp_record(46eb0, 1)
> > bcp.c:3401:_bcp_get_col_data(46eb0, 165158)
> > dblib.c:2144:dbconvert(46eb0, SYBINT4, fd2a5ca8, 4,
> > SYBINT4, 16a358, 4)
> > dblib.c:2177:dbconvert() srctype == desttype
> > bcp.c:3217:parsed column 1, length 4 (not null)
> > bcp.c:3283:new_record_size = 0 datalen = 4
> > bcp.c:3307:old_record_size = 205 new size = 4
> > bcp.c:3401:_bcp_get_col_data(46eb0, 1655d0)
> > dblib.c:2144:dbconvert(46eb0, SYBINT4, fd2a5cac, 4,
> > SYBINT4, 16a238, 4)
> > dblib.c:2177:dbconvert() srctype == desttype
> > bcp.c:3217:parsed column 2, length 4 (not null)
> > bcp.c:3283:new_record_size = 4 datalen = 4
> > bcp.c:3307:old_record_size = 205 new size = 8
> > bcp.c:3401:_bcp_get_col_data(46eb0, 165a48)
> > dblib.c:2144:dbconvert(46eb0, SYBINT4, fd2a5cb0, 4,
> > SYBINT4, 16a368, 4)
> > dblib.c:2177:dbconvert() srctype == desttype
> > bcp.c:3217:parsed column 3, length 4 (not null)
> > bcp.c:3283:new_record_size = 8 datalen = 4
> > bcp.c:3307:old_record_size = 205 new size = 12
> > bcp.c:3401:_bcp_get_col_data(46eb0, 165ec0)
> > bcp.c:3515:bufpos = 0 , value
> =>T<bcp.c:3515:bufpos =
> > 1 , value =>D<bcp.c:3515:bufpos = 2 , value
> > =>1<dblib.c:2144:dbconvert(46eb0, SYBCHAR,
> fd2a5cb4,
> > -1, SYBCHAR, 16a248, 4)
> > dblib.c:2177:dbconvert() srctype == desttype
> > bcp.c:3217:parsed column 4, length 3 (not null)
> > bcp.c:3283:new_record_size = 14 datalen = 3
> > bcp.c:3307:old_record_size = 205 new size = 17
> > bcp.c:3401:_bcp_get_col_data(46eb0, 166338)
> > bcp.c:3515:bufpos = 0 , value
> =>T<bcp.c:3515:bufpos =
> > 1 , value =>D<bcp.c:3515:bufpos = 2 , value
> > =>A<bcp.c:3515:bufpos = 3 , value
> > =>C<dblib.c:2144:dbconvert(46eb0, SYBCHAR,
> fd2a5cb9,
> > -1, SYBCHAR, 16a378, 4)
> > dblib.c:2177:dbconvert() srctype == desttype
> > bcp.c:3217:parsed column 5, length 4 (not null)
> > bcp.c:3283:new_record_size = 19 datalen = 4
> > bcp.c:3307:old_record_size = 205 new size = 23
> > bcp.c:3401:_bcp_get_col_data(46eb0, 1667b0)
> > bcp.c:3515:bufpos = 0 , value
> =>G<bcp.c:3515:bufpos =
> > 1 , value =>B<bcp.c:3515:bufpos = 2 , value
> > =>P<dblib.c:2144:dbconvert(46eb0, SYBCHAR,
> fd2a5cbe,
> > -1, SYBCHAR, 16a258, 3)
> > dblib.c:2177:dbconvert() srctype == desttype
> > bcp.c:3217:parsed column 6, length 3 (not null)
> > bcp.c:3283:new_record_size = 25 datalen = 3
> > bcp.c:3307:old_record_size = 205 new size = 28
> > bcp.c:3401:_bcp_get_col_data(46eb0, 166c28)
> > bcp.c:3515:bufpos = 0 , value
> =>1<bcp.c:3515:bufpos =
> > 1 , value =>4<bcp.c:3515:bufpos = 2 , value
> > =>0<bcp.c:3515:bufpos = 3 , value
> > =>0<bcp.c:3515:bufpos = 4 , value
> > =>1<bcp.c:3515:bufpos = 5 , value
> > =>1<dblib.c:2144:dbconvert(46eb0, SYBCHAR,
> fd2a5cc2,
> > -1, SYBCHAR, 4a6d0, 16)
> > dblib.c:2177:dbconvert() srctype == desttype
> > bcp.c:3217:parsed column 7, length 6 (not null)
> > bcp.c:3283:new_record_size = 30 datalen = 6
> > bcp.c:3307:old_record_size = 205 new size = 36
> > bcp.c:3401:_bcp_get_col_data(46eb0, 1670a0)
> > bcp.c:3515:bufpos = 0 , value
> =>B<bcp.c:3515:bufpos =
> > 1 , value =>O<bcp.c:3515:bufpos = 2 , value
> > =>O<bcp.c:3515:bufpos = 3 , value
> > =>K<bcp.c:3515:bufpos = 4 , value
> > =>1<dblib.c:2144:dbconvert(46eb0, SYBCHAR,
> fd2a5cd3,
> > -1, SYBCHAR, 4a6b8, 12)
> > dblib.c:2177:dbconvert() srctype == desttype
> > bcp.c:3217:parsed column 8, length 5 (not null)
> > bcp.c:3283:new_record_size = 38 datalen = 5
> > bcp.c:3307:old_record_size = 205 new size = 43
> > bcp.c:3401:_bcp_get_col_data(46eb0, 167518)
> > bcp.c:3515:bufpos = 0 , value
> =>B<bcp.c:3515:bufpos =
> > 1 , value =>A<bcp.c:3515:bufpos = 2 , value
> > =>A<bcp.c:3515:bufpos = 3 , value
> > =>S<bcp.c:3515:bufpos = 4 , value
> > =>H<bcp.c:3515:bufpos = 5 , value
> > =>R<bcp.c:3515:bufpos = 6 , value
> > =>S<bcp.c:3515:bufpos = 7 , value
> > =>R<bcp.c:3515:bufpos = 8 , value
> > =>T<bcp.c:3515:bufpos = 9 , value
> > =>S<bcp.c:3515:bufpos = 10 , value
> > =>T<dblib.c:2144:dbconvert(46eb0, SYBCHAR,
> fd2a5ce0,
> > -1, SYBCHAR, 4a370, 12)
> > dblib.c:2177:dbconvert() srctype == desttype
> > bcp.c:3217:parsed column 9, length 11 (not null)
> > bcp.c:3283:new_record_size = 45 datalen = 11
> > bcp.c:3307:old_record_size = 205 new size = 56
> > bcp.c:3401:_bcp_get_col_data(46eb0, 167990)
> > bcp.c:3515:bufpos = 0 , value
> =>0<bcp.c:3515:bufpos =
> > 1 , value =>1<bcp.c:3515:bufpos = 2 , value
> =>
> > <bcp.c:3515:bufpos = 3 , value
> > =>F<bcp.c:3515:bufpos = 4 , value
> > =>e<bcp.c:3515:bufpos = 5 , value
> > =>b<bcp.c:3515:bufpos = 6 , value =>
> > <bcp.c:3515:bufpos = 7 , value
> > =>2<bcp.c:3515:bufpos = 8 , value
> > =>0<bcp.c:3515:bufpos = 9 , value
> > =>1<bcp.c:3515:bufpos = 10 , value
> > =>1<dblib.c:2144:dbconvert(46eb0, SYBTEXT,
> fd2a5ced,
> > -1, SYBDATETIME, 16a228, 8)
> > dblib.c:2286:dbconvert() calling tds_convert
> > convert.c:1780:string_to_datetime: current_state = 0
> > convert.c:1801:string_to_datetime: is_numeric
> > convert.c:1780:string_to_datetime: current_state = 1
> > convert.c:2500:store_monthname: 3 Feb
> > convert.c:1780:string_to_datetime: current_state = 2
> > dblib.c:2289:dbconvert() called tds_convert returned
> 8
> > bcp.c:3217:parsed column 10, length 8 (not null)
> > bcp.c:3283:new_record_size = 56 datalen = 8
> > bcp.c:3307:old_record_size = 205 new size = 64
> > bcp.c:3401:_bcp_get_col_data(46eb0, 167e08)
> > dblib.c:2144:dbconvert(46eb0, SYBCHAR, fd2a5d05, -1,
> > SYBCHAR, 325b0, 20)
> > dblib.c:2177:dbconvert() srctype == desttype
> > bcp.c:3213:_bcp_get_col_data (column 11) failed
> > bcp.c:3023:bcp_done(46eb0)
> > net.c:779:Sending packet
> > 0000 07 01 02 16 00 00 01 00-81 12 00 00 00 08 00 38
> > |........ .......8|
> > 0010 0b 70 00 72 00 6f 00 63-00 5f 00 6e 00 75 00 6d
> > |.p.r.o.c ._.n.u.m|
> > 0020 00 62 00 65 00 72 00 00-00 08 00 38 0a 6a 00 6f
> > |.b.e.r.. ...8.j.o|
> > 0030 00 75 00 72 00 6e 00 61-00 6c 00 5f 00 6e 00 6f
> > |.u.r.n.a .l._.n.o|
> > 0040 00 00 00 08 00 38 0b 6a-00 6f 00 75 00 72 00 6e
> > |.....8.j .o.u.r.n|
> > 0050 00 61 00 6c 00 5f 00 70-00 6f 00 73 00 00 00 0a
> > |.a.l._.p .o.s....|
> > 0060 00 af 04 00 09 04 c0 00-00 0f 6c 00 65 00 64 00
> > |........ ..l.e.d.|
> > 0070 67 00 65 00 72 00 5f 00-63 00 6f 00 64 00 65 00
> > |g.e.r._. c.o.d.e.|
> > 0080 5f 00 77 00 69 00 6c 00-00 00 0a 00 af 04 00 09
> > |_.w.i.l. ........|
> > 0090 04 c0 00 00 06 73 00 6f-00 75 00 72 00 63 00 65
> > |.....s.o .u.r.c.e|
> > 00a0 00 00 00 0a 00 af 03 00-09 04 c0 00 00 03 63 00
> > |........ ......c.|
> > 00b0 63 00 79 00 00 00 0a 00-af 10 00 09 04 c0 00 00
> > |c.y..... ........|
> > 00c0 0c 61 00 63 00 63 00 6f-00 75 00 6e 00 74 00 5f
> > |.a.c.c.o .u.n.t._|
> > 00d0 00 63 00 6f 00 64 00 65-00 00 00 0b 00 af 0c 00
> > |.c.o.d.e ........|
> > 00e0 09 04 c0 00 00 05 63 00-61 00 74 00 5f 00 31 00
> > |......c. a.t._.1.|
> > 00f0 00 00 0b 00 af 0c 00 09-04 c0 00 00 05 63 00 61
> > |........ .....c.a|
> > 0100 00 74 00 5f 00 32 00 00-00 08 00 3d 10 74 00 72
> > |.t._.2.. ...=.t.r|
> > 0110 00 61 00 6e 00 73 00 61-00 63 00 74 00 69 00 6f
> > |.a.n.s.a .c.t.i.o|
> > 0120 00 6e 00 5f 00 64 00 61-00 74 00 65 00 00 00 0a
> > |.n._.d.a .t.e....|
> > 0130 00 af 14 00 09 04 c0 00-00 09 72 00 65 00 66 00
> > |........ ..r.e.f.|
> > 0140 65 00 72 00 65 00 6e 00-63 00 65 00 00 00 0a 00
> > |e.r.e.n. c.e.....|
> > 0150 a7 3c 00 09 04 c0 00 00-09 6e 00 61 00 72 00 72
> > |.<...... .n.a.r.r|
> > 0160 00 61 00 74 00 69 00 76-00 65 00 00 00 08 00 3e
> > |.a.t.i.v .e.....>|
> > 0170 0c 64 00 62 00 5f 00 63-00 63 00 79 00 5f 00 76
> > |.d.b._.c .c.y._.v|
> > 0180 00 61 00 6c 00 75 00 65-00 00 00 08 00 3e 0d 64
> > |.a.l.u.e .....>.d|
> > 0190 00 62 00 5f 00 62 00 61-00 73 00 65 00 5f 00 76
> > |.b._.b.a .s.e._.v|
> > 01a0 00 61 00 6c 00 75 00 65-00 00 00 08 00 3e 04 72
> > |.a.l.u.e .....>.r|
> > 01b0 00 61 00 74 00 65 00 00-00 0a 00 af 01 00 09 04
> > |.a.t.e.. ........|
> > 01c0 c0 00 00 0b 63 00 61 00-6c 00 63 00 5f 00 6d 00
> > |....c.a. l.c._.m.|
> > 01d0 65 00 74 00 68 00 6f 00-64 00 00 00 0a 00 af 06
> > |e.t.h.o. d.......|
> > 01e0 00 09 04 c0 00 00 06 70-00 65 00 72 00 69 00 6f
> > |.......p .e.r.i.o|
> > 01f0 00 64 00 00 00 0a 00 af-01 00 09 04 c0 00 00 0b
> > |.d...... ........|
> > 0200 70 00 72 00 6f 00 63 00-5f 00 61 00 63 00 74 00
> > |p.r.o.c. _.a.c.t.|
> > 0210 69 00 6f 00 6e 00      -   
> >                
> >     |i.o.n.|
> > 
> > util.c:162:Changed query state from QUERYING to
> PENDING
> > token.c:495:tds_process_tokens(45c80, ffbfc424,
> ffbfc420,
> > 0x100)
> > util.c:162:Changed query state from PENDING to
> READING
> > net.c:592:Received header
> > 0000 04 01 00 11 00 57 01 00-       
> >                
> > |.....W..|
> > 
> > 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(45c80, ffbfc424,
> ffbfc420,
> > 0x100)
> > token.c:498:tds_process_tokens() state is COMPLETED
> > bcp.c:3583:_bcp_free_storage(46eb0)
> > dblib.c:3096:dbcancel(46eb0)
> > query.c:1934:tds_send_cancel: not in_cancel and idle
> > dblib.c:3878:dbgetmaxprocs(void)
> > dblib.c:3878:dbgetmaxprocs(void)
> > dblib.c:4750:dbdead(46eb0) [alive]
> > dblib.c:5611:dbsetuserdata(46eb0, 48610)
> > bcp.c:3023:bcp_done(46eb0)
> > dblib.c:7785:dbperror(46eb0, 20076, 0)
> > dblib.c:7838:20076: "bcp_init must be called before
> any
> > other bcp routines"
> > 00000059 2011/06/15 07:07:13.565 TEMP 16139 SERI 
> >                
> >            DATABASE
> > ERROR:: bcp_init must be called before any other bcp
> > routines
> > 00000060 2011/06/15 07:07:13.565 TEMP 16139 SERI 
> >                
> >            DATABASE
> > ERROR:: Error 0
> > dblib.c:7859:"bcp_init must be called before any other
> bcp
> > routines", client returns 2 (INT_CANCEL)
> > dblib.c:3878:dbgetmaxprocs(void)
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > 
> >
> ----------------------------------------------------------------------
> > This message w/attachments (message) is intended
> solely for
> > the use of the intended recipient(s) and may contain
> > information that is privileged, confidential or
> proprietary.
> > If you are not an intended recipient, please notify
> the
> > sender, and then please delete and destroy all copies
> and
> > attachments, and be advised that any review or
> dissemination
> > of, or the taking of any action in reliance on, the
> > information contained in or attached to this message
> is
> > prohibited. 
> > Unless specifically indicated, this message is not an
> offer
> > to sell or a solicitation of any investment products
> or
> > other financial product or service, an official
> confirmation
> > of any transaction, or an official statement of
> Sender.
> > Subject to applicable law, Sender may intercept,
> monitor,
> > review and retain e-communications (EC) traveling
> through
> > its networks/systems and may produce any such EC to
> > regulators, law enforcement, in litigation and as
> required
> > by law. 
> > The laws of the country of each sender/recipient may
> impact
> > the handling of EC, and EC may be archived, supervised
> and
> > produced in countries other than the country in which
> you
> > are located. This message cannot be guaranteed to be
> secure
> > or free of errors or viruses. 
> > 
> > References to "Sender" are references to any
> subsidiary of
> > Bank of America Corporation. Securities and Insurance
> > Products: * Are Not FDIC Insured * Are Not Bank
> Guaranteed *
> > May Lose Value * Are Not a Bank Deposit * Are Not a
> > Condition to Any Banking Service or Activity * Are
> Not
> > Insured by Any Federal Government Agency. Attachments
> that
> > are part of this EC may have additional important
> > disclosures and disclaimers, which you should read.
> This
> > message is subject to terms available at the following
> link:
> > 
> > http://www.bankofamerica.com/emaildisclaimer. By
> > messaging with Sender you consent to the foregoing.
> > _______________________________________________
> > 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
>