Skip to content

Instantly share code, notes, and snippets.

@amcintyre99

amcintyre99/gist:5490123

Created April 30, 2013 17:02
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/5490123 to your computer and use it in GitHub Desktop.
Save amcintyre99/5490123 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
ODBC::New
ODBC::CreateConnection
ODBC::UV_CreateConnection
ODBC::UV_AfterCreateConnection
ODBCConnection::New
ODBCConnection::Open
ODBCConnection::UV_Open
ODBCConnection::UV_AfterOpen
ODBCConnection::CreateStatementSync
ODBCStatement::PrepareSync
ODBCStatement::Bind
ODBCStatement::Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBC::GetParametersFromArray
ODBC::GetParametersFromArray - &param[0].length = 1659040
ODBC::GetParametersFromArray - IsString(): params[0] c_type=1 type=12 buffer_length=36 size=36 length=-3 value=<qt><status>connected</status></qt>
ODBC::GetParametersFromArray - &param[1].length = 1659070
ODBC::GetParametersFromArray - IsString(): params[1] c_type=1 type=12 buffer_length=17 size=17 length=-3 value=1367341236738872
ODBCStatement::UV_Bind
ODBCStatement::UV_Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBCStatement::UV_Bind - param[0]: c_type=1 type=12 buffer_length=36 size=36 length=-3 &length=1659040 decimals=0 value=<qt><status>connected</status></qt>
ODBCStatement::UV_Bind - param[1]: c_type=1 type=12 buffer_length=17 size=17 length=-3 &length=1659070 decimals=0 value=1367341236738872
ODBCStatement::UV_AfterBind
ODBCStatement::Execute
ODBCStatement::UV_Execute
ODBCStatement::UV_AfterExecute
ODBCResult::New
ODBCResult::New m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0 canFreeHandle=0
1 13:00:36.738872 1 59195 59195 35 35 0
ODBCResult::CloseSync
ODBCResult::CloseSync closeOption=9999 m_canFreeHandle=0
ODBCStatement::Bind
ODBCStatement::Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBC::GetParametersFromArray
ODBC::GetParametersFromArray - &param[0].length = 1659040
ODBC::GetParametersFromArray - IsString(): params[0] c_type=1 type=12 buffer_length=195 size=195 length=-3 value=<qt><quote><ask>37.56</ask><asksz>73</asksz><bid>37.55</bid><bidsz>195</bidsz><exch>NASDAQ Intermarket</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>T</symbol></quote></qt>
ODBC::GetParametersFromArray - &param[1].length = 1659070
ODBC::GetParametersFromArray - IsString(): params[1] c_type=1 type=12 buffer_length=17 size=17 length=-3 value=1367341237007070
ODBCStatement::UV_Bind
ODBCStatement::UV_Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBCStatement::UV_Bind - param[0]: c_type=1 type=12 buffer_length=195 size=195 length=-3 &length=1659040 decimals=0 value=<qt><quote><ask>37.56</ask><asksz>73</asksz><bid>37.55</bid><bidsz>195</bidsz><exch>NASDAQ Intermarket</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>T</symbol></quote></qt>
ODBCStatement::UV_Bind - param[1]: c_type=1 type=12 buffer_length=17 size=17 length=-3 &length=1659070 decimals=0 value=1367341237007070
ODBCStatement::UV_AfterBind
ODBCStatement::Execute
ODBCStatement::UV_Execute
ODBCStatement::UV_AfterExecute
ODBCResult::New
ODBCResult::New m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0 canFreeHandle=0
1 13:00:37.007070 2 14989 37092 194 115 0
ODBCResult::CloseSync
ODBCResult::CloseSync closeOption=9999 m_canFreeHandle=0
ODBCStatement::Bind
ODBCStatement::Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBC::GetParametersFromArray
ODBC::GetParametersFromArray - &param[0].length = 164E320
ODBC::GetParametersFromArray - IsString(): params[0] c_type=1 type=12 buffer_length=223 size=223 length=-3 value=<qt><trade><cvol>12315636</cvol><datetime>2013-04-30T13:00:36-04:00</datetime><exch>NASD 3rd Market</exch><last>13.6949</last><symbol>F</symbol><timestamp>1367341236</timestamp><vl>122</vl><vwap>13.6319</vwap></trade></qt>
ODBC::GetParametersFromArray - &param[1].length = 164E350
ODBC::GetParametersFromArray - IsString(): params[1] c_type=1 type=12 buffer_length=17 size=17 length=-3 value=1367341237036253
ODBCStatement::UV_Bind
ODBCStatement::UV_Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBCStatement::UV_Bind - param[0]: c_type=1 type=12 buffer_length=223 size=223 length=-3 &length=164E320 decimals=0 value=<qt><trade><cvol>12315636</cvol><datetime>2013-04-30T13:00:36-04:00</datetime><exch>NASD 3rd Market</exch><last>13.6949</last><symbol>F</symbol><timestamp>1367341236</timestamp><vl>122</vl><vwap>13.6319</vwap></trade></qt>
ODBCStatement::UV_Bind - param[1]: c_type=1 type=12 buffer_length=17 size=17 length=-3 &length=164E350 decimals=0 value=1367341237036253
ODBCStatement::UV_AfterBind
ODBCStatement::Bind
ODBCStatement::Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBC::GetParametersFromArray
ODBC::GetParametersFromArray - &param[0].length = 1659040
ODBC::GetParametersFromArray - IsString(): params[0] c_type=1 type=12 buffer_length=195 size=195 length=-3 value=<qt><quote><ask>52.91</ask><asksz>6</asksz><bid>52.9</bid><bidsz>8</bidsz><exch>NASDAQ Regional/CTS</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>EBAY</symbol></quote></qt>
ODBC::GetParametersFromArray - &param[1].length = 1659070
ODBC::GetParametersFromArray - IsString(): params[1] c_type=1 type=12 buffer_length=17 size=17 length=-3 value=1367341237036377
ODBCStatement::UV_Bind
ODBCStatement::UV_Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBCStatement::UV_Bind - param[0]: c_type=1 type=12 buffer_length=195 size=195 length=-3 &length=1659040 decimals=0 value=<qt><quote><ask>52.91</ask><asksz>6</asksz><bid>52.9</bid><bidsz>8</bidsz><exch>NASDAQ Regional/CTS</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>EBAY</symbol></quote></qt>
ODBCStatement::UV_Bind - param[1]: c_type=1 type=12 buffer_length=17 size=17 length=-3 &length=1659070 decimals=0 value=1367341237036377
ODBCStatement::UV_AfterBind
ODBCStatement::Bind
ODBCStatement::Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBC::GetParametersFromArray
ODBC::GetParametersFromArray - &param[0].length = 163EC10
ODBC::GetParametersFromArray - IsString(): params[0] c_type=1 type=12 buffer_length=184 size=184 length=-3 value=<qt><quote><ask>253.7</ask><asksz>1</asksz><bid>253.6</bid><bidsz>2</bidsz><exch>Pacific</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>AMZN</symbol></quote></qt>
ODBC::GetParametersFromArray - &param[1].length = 163EC40
ODBC::GetParametersFromArray - IsString(): params[1] c_type=1 type=12 buffer_length=17 size=17 length=-3 value=1367341237036397
ODBCStatement::UV_Bind
ODBCStatement::UV_Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBCStatement::UV_Bind - param[0]: c_type=1 type=12 buffer_length=184 size=184 length=-3 &length=163EC10 decimals=0 value=<qt><quote><ask>253.7</ask><asksz>1</asksz><bid>253.6</bid><bidsz>2</bidsz><exch>Pacific</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>AMZN</symbol></quote></qt>
ODBCStatement::UV_Bind - param[1]: c_type=1 type=12 buffer_length=17 size=17 length=-3 &length=163EC40 decimals=0 value=1367341237036397
ODBCStatement::UV_AfterBind
ODBCStatement::Bind
ODBCStatement::Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBC::GetParametersFromArray
ODBC::GetParametersFromArray - &param[0].length = 164E390
ODBC::GetParametersFromArray - IsString(): params[0] c_type=1 type=12 buffer_length=249 size=249 length=-3 value=<qt><trade><cvol>2731322</cvol><datetime>2013-04-30T13:00:36-04:00</datetime><exch>NASDAQ Regional/CTS</exch><last>253.69</last><symbol>AMZN</symbol><tcond>57,16</tcond><timestamp>1367341236</timestamp><vl>300</vl><vwap>252.7394</vwap></trade></qt>
ODBC::GetParametersFromArray - &param[1].length = 164E3C0
ODBC::GetParametersFromArray - IsString(): params[1] c_type=1 type=12 buffer_length=17 size=17 length=-3 value=1367341237036408
ODBCStatement::UV_Bind
ODBCStatement::UV_Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBCStatement::UV_Bind - param[0]: c_type=1 type=12 buffer_length=249 size=249 length=-3 &length=164E390 decimals=0 value=<qt><trade><cvol>2731322</cvol><datetime>2013-04-30T13:00:36-04:00</datetime><exch>NASDAQ Regional/CTS</exch><last>253.69</last><symbol>AMZN</symbol><tcond>57,16</tcond><timestamp>1367341236</timestamp><vl>300</vl><vwap>252.7394</vwap></trade></qt>
ODBCStatement::UV_Bind - param[1]: c_type=1 type=12 buffer_length=17 size=17 length=-3 &length=164E3C0 decimals=0 value=1367341237036408
ODBCStatement::UV_AfterBind
ODBCStatement::Bind
ODBCStatement::Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBC::GetParametersFromArray
ODBC::GetParametersFromArray - &param[0].length = 164E240
ODBC::GetParametersFromArray - IsString(): params[0] c_type=1 type=12 buffer_length=262 size=262 length=-3 value=<qt><quote><ask>91.73</ask><asksz>5</asksz><bid>91.72</bid><bidsz>1</bidsz><datetime>2013-04-30T13:00:36-04:00</datetime><exch>New York</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>BA</symbol><timestamp>1367341236</timestamp></quote></qt>
ODBC::GetParametersFromArray - &param[1].length = 164E270
ODBC::GetParametersFromArray - IsString(): params[1] c_type=1 type=12 buffer_length=17 size=17 length=-3 value=1367341237036420
ODBCStatement::UV_Bind
ODBCStatement::UV_Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBCStatement::UV_Bind - param[0]: c_type=1 type=12 buffer_length=262 size=262 length=-3 &length=164E240 decimals=0 value=<qt><quote><ask>91.73</ask><asksz>5</asksz><bid>91.72</bid><bidsz>1</bidsz><datetime>2013-04-30T13:00:36-04:00</datetime><exch>New York</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>BA</symbol><timestamp>1367341236</timestamp></quote></qt>
ODBCStatement::UV_Bind - param[1]: c_type=1 type=12 buffer_length=17 size=17 length=-3 &length=164E270 decimals=0 value=1367341237036420
ODBCStatement::UV_AfterBind
ODBCStatement::Bind
ODBCStatement::Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBC::GetParametersFromArray
ODBC::GetParametersFromArray - &param[0].length = 164E2B0
ODBC::GetParametersFromArray - IsString(): params[0] c_type=1 type=12 buffer_length=185 size=185 length=-3 value=<qt><quote><ask>108.2</ask><asksz>1</asksz><bid>108.19</bid><bidsz>3</bidsz><exch>Pacific</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>COST</symbol></quote></qt>
ODBC::GetParametersFromArray - &param[1].length = 164E2E0
ODBC::GetParametersFromArray - IsString(): params[1] c_type=1 type=12 buffer_length=17 size=17 length=-3 value=1367341237036439
ODBCStatement::UV_Bind
ODBCStatement::UV_Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBCStatement::UV_Bind - param[0]: c_type=1 type=12 buffer_length=185 size=185 length=-3 &length=164E2B0 decimals=0 value=<qt><quote><ask>108.2</ask><asksz>1</asksz><bid>108.19</bid><bidsz>3</bidsz><exch>Pacific</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>COST</symbol></quote></qt>
ODBCStatement::UV_Bind - param[1]: c_type=1 type=12 buffer_length=17 size=17 length=-3 &length=164E2E0 decimals=0 value=1367341237036439
ODBCStatement::UV_AfterBind
ODBCStatement::Bind
ODBCStatement::Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBC::GetParametersFromArray
ODBC::GetParametersFromArray - &param[0].length = 164E660
ODBC::GetParametersFromArray - IsString(): params[0] c_type=1 type=12 buffer_length=184 size=184 length=-3 value=<qt><quote><ask>84.46</ask><asksz>9</asksz><bid>84.44</bid><bidsz>6</bidsz><exch>New York</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>APC</symbol></quote></qt>
ODBC::GetParametersFromArray - &param[1].length = 164E690
ODBC::GetParametersFromArray - IsString(): params[1] c_type=1 type=12 buffer_length=17 size=17 length=-3 value=1367341237036451
ODBCStatement::UV_Bind
ODBCStatement::UV_Bind m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0
ODBCStatement::UV_Bind - param[0]: c_type=1 type=12 buffer_length=184 size=184 length=-3 &length=164E660 decimals=0 value=<qt><quote><ask>84.46</ask><asksz>9</asksz><bid>84.44</bid><bidsz>6</bidsz><exch>New York</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>APC</symbol></quote></qt>
ODBCStatement::UV_Bind - param[1]: c_type=1 type=12 buffer_length=17 size=17 length=-3 &length=164E690 decimals=0 value=1367341237036451
ODBCStatement::UV_AfterBind
ODBCStatement::Execute
ODBCStatement::UV_Execute
ODBCStatement::UV_AfterExecute
ODBCResult::New
ODBCResult::New m_hDBC=14C9780 m_hDBC=440008C0 m_hSTMT=14C90E0 canFreeHandle=0
1 13:00:37.036253 3 9798 27994 222 150 0
ODBCResult::CloseSync
ODBCResult::CloseSync closeOption=9999 m_canFreeHandle=0
ODBCStatement::Execute
ODBCStatement::UV_Execute
ODBCStatement::UV_AfterExecute
1 13:00:37.036377 4 10945 23732 194 161 0
1 { 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' }
1 1 194 <qt><quote><ask>52.91</ask><asksz>6</asksz><bid>52.9</bid><bidsz>8</bidsz><exch>NASDAQ Regional/CTS</exch><qcond>Regular, two-sided open quote automated</qcond><symbol>EBAY</symbol></quote></qt>
1 00000000: 3c71 743e 3c71 756f 7465 3e3c 6173 6b3e <qt><quote><ask>
00000010: 3532 2e39 313c 2f61 736b 3e3c 6173 6b73 52.91</ask><asks
00000020: 7a3e 363c 2f61 736b 737a 3e3c 6269 643e z>6</asksz><bid>
00000030: 3532 2e39 3c2f 6269 643e 3c62 6964 737a 52.9</bid><bidsz
00000040: 3e38 3c2f 6269 6473 7a3e 3c65 7863 683e >8</bidsz><exch>
00000050: 4e41 5344 4151 2052 6567 696f 6e61 6c2f NASDAQ.Regional/
00000060: 4354 533c 2f65 7863 683e 3c71 636f 6e64 CTS</exch><qcond
00000070: 3e52 6567 756c 6172 2c20 7477 6f2d 7369 >Regular,.two-si
00000080: 6465 6420 6f70 656e 2071 756f 7465 2061 ded.open.quote.a
00000090: 7574 6f6d 6174 6564 3c2f 7163 6f6e 643e utomated</qcond>
000000a0: 3c73 796d 626f 6c3e 4542 4159 3c2f 7379 <symbol>EBAY</sy
000000b0: 6d62 6f6c 3e3c 2f71 756f 7465 3e3c 2f71 mbol></quote></q
000000c0: 743e t>
/home/andrew/dma/prd/p1srunp.js:2784: Uncaught TypeError: Cannot call method 'closeSync' of undefined
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment