dbeaver登錄informix報文分析-hex

《dbeaver登錄informix報文分析-hex》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在工程資料-天天文庫。

1、000001B3000001C3000001D3000001E3SelectDebeaver作為客戶端一自動下載驅(qū)動:?A?H..E.mdbmd41,2,3,9.f.2#...orderby*.?1??7?c.?b?ISELEnerFROM春?參1?.088oal5004C5O7d08c814ooa8854a9f053c9eo50SQL長度ul-3t>2a6oi1o!:oo1o24r*pCO2Obo8o803084205f281838e2d47398d86o35604011dooo-26?????#???rf.

2、??攀088oal5004C500028481400253454c4500OcSQL長度73004c728006co2o-dbo8o8o3od842065d41118cb6edc3o972cc27do6d356fd40001000000001000200030004000500060000000100020003000400050Select語川（六個字節(jié)開始）（六/七個字節(jié)結(jié)束）以00020000開始，緊跟兩個字節(jié)select語句長度（不包含包頭和乜尾），最后以00160031000c—-SQL長度為偶數(shù)或0

3、000160031000cSQL長度為奇數(shù)保-證報文整體為偶數(shù)字節(jié)，結(jié)束。通過報文尖00020000以及報文尾00160031000c判斷報文為select語川報文。（冇的以00020000開頭,不以00160031000c結(jié)尾的報文不是selcet語句報文）。WinSQL作為客戶端一IBMinformixclient4.10驅(qū)動:0000015100000161000001710000018100000191000001A1000001B1包頭<^0100:736d616c6c666c6f696e666f72

4、6d697865732077686572652031006f003100037572736f72000006000cSQL長度登錄第二條報文select標識不為00020003c73656c65637420313a3a…"

5、ursor.-Kt的selei?HiJ規(guī)則勹Dbeaver登求一樣00020000002d73656c65637420646973-selectdis74696e6374206f776e65722066726f6dtinctownerfrom20696e666f726d69782e737973746162informix.systab6c65730000160031000cles....l..包尾Inser、create、dropDebeaver作為客戶端：（An為偶以（六個字節(jié)開始，五六位為語句長度n）n個

6、字節(jié)語句數(shù)/九n為奇數(shù)，個字節(jié)結(jié)朿）。包頭SQL長度Drop語句000038A100010000001164726f70207461626c65......droptable000038B12064626d6431380000160007000b000cdbmdl8KInsert語句包尾000004E700010000002c696e7365727420696e74..^insertint000004F76f2064626d6431352076616c75657328odbmdl5values(00000507

7、202027696e666f726d6978272c275427?inforrnix'/T'00000517202900160007000b000c)????????Create語句0000038500000395000003A5000003B5000003C5000003D5000003E50001000000596372656174652074656d..…Ycreatetem70207461626c652064626d6431352820ptabledbmdl5(20205441424c455f53434

8、8454d202020TABLESCHEM7661726368617228616274797065202020292077697468200016000700Ob000c3835292c20202074varcharf85),t2063686172283129abtypechar⑴6e6f206c6f673b00)withnolog;.登錄Debeaver作為客戶端:olJnfohdL