Created
April 30, 2013 16:31
-
-
Save amcintyre99/5489891 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
17 { state: '22005', | |
error: '[node-odbc] Error in some module', | |
message: '[unixODBC][IBM][CLI Driver][DB2/LINUXX8664] SQL0420N Invalid character found in a character string argument of the function "DECFLOAT". SQLSTATE=22018\n' } | |
17 1 240 <qt><trade><cvol>29922533</cvol><datetime>2013-04-30T12:27:19-04:00</datetime><exch>The Trade Reporting Facility LLC</exch><last>32.82</last><symbol>MSFT</symbol><timestamp>1367339239</timestamp><vl>100</vl><vwap>32.5603</vwap></trade></qt> | |
17 00000000: 3c71 743e 3c74 7261 6465 3e3c 6376 6f6c <qt><trade><cvol | |
00000010: 3e32 3939 3232 3533 333c 2f63 766f 6c3e >29922533</cvol> | |
00000020: 3c64 6174 6574 696d 653e 3230 3133 2d30 <datetime>2013-0 | |
00000030: 342d 3330 5431 323a 3237 3a31 392d 3034 4-30T12:27:19-04 | |
00000040: 3a30 303c 2f64 6174 6574 696d 653e 3c65 :00</datetime><e | |
00000050: 7863 683e 5468 6520 5472 6164 6520 5265 xch>The.Trade.Re | |
00000060: 706f 7274 696e 6720 4661 6369 6c69 7479 porting.Facility | |
00000070: 204c 4c43 3c2f 6578 6368 3e3c 6c61 7374 .LLC</exch><last | |
00000080: 3e33 322e 3832 3c2f 6c61 7374 3e3c 7379 >32.82</last><sy | |
00000090: 6d62 6f6c 3e4d 5346 543c 2f73 796d 626f mbol>MSFT</symbo | |
000000a0: 6c3e 3c74 696d 6573 7461 6d70 3e31 3336 l><timestamp>136 | |
000000b0: 3733 3339 3233 393c 2f74 696d 6573 7461 7339239</timesta | |
000000c0: 6d70 3e3c 766c 3e31 3030 3c2f 766c 3e3c mp><vl>100</vl>< | |
000000d0: 7677 6170 3e33 322e 3536 3033 3c2f 7677 vwap>32.5603</vw | |
000000e0: 6170 3e3c 2f74 7261 6465 3e3c 2f71 743e ap></trade></qt> | |
the 17 is node child number | |
the 1 is sql error count | |
the 240 is the length of the xml packet | |
there is nothing wrong with the xml packet which I think indicates that the bind worked ok | |
remember this err is coming from the execute |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
bind may not have worked - i'm actually logging the "str"