Skip to content

Instantly share code, notes, and snippets.

@amcintyre99
Created April 30, 2013 16:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amcintyre99/5489891 to your computer and use it in GitHub Desktop.
Save amcintyre99/5489891 to your computer and use it in GitHub Desktop.
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
@amcintyre99
Copy link
Author

bind may not have worked - i'm actually logging the "str"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment