Re: Sniffer Decode for Informix

Thanks, This might help. I was not able to get that SQLIDEBUG=2:/tmp/test to work with sqliprint so I set SQLIDEBUG=1:/tmp/test and used this awk file to kind of get an idea of what was being returned. awk -f <awkfile> /tmp/test_* ---begin awk---- BEGIN{ {RS=" "} {arrasc["0"]=""} {arrasc["1"]=""} {arrasc["2"]="\\n"} {arrasc["3"]="\\n"} {arrasc["4"]="\\n"} {arrasc["5"]="\\n"} {arrasc["6"]="ACK"} {arrasc["7"]=""} {arrasc["8"]="\\b"} {arrasc["9"]="HT"} {arrasc["0a"]="\\n"} {arrasc["0b"]="VT"} {arrasc["0c"]="FF"} {arrasc["0d"]="\\n"} {arrasc["0e"]="SO"} {arrasc["0f"]="SI"} {arrasc["10"]="DLE"} {arrasc["11"]="DC1"} {arrasc["12"]="DC2"} {arrasc["13"]="DC3"} {arrasc["14"]="DC4"} {arrasc["15"]="NAK"} {arrasc["16"]=""} {arrasc["17"]="ETB"} {arrasc["18"]="CAN"} {arrasc["19"]="EM"} {arrasc["1a"]="SUB"} {arrasc["1b"]="ESC"} {arrasc["1c"]="FS"} {arrasc["1d"]="GS"} {arrasc["1e"]="RS"} {arrasc["1f"]="US"} {arrasc["20"]=" "} {arrasc["21"]="!"} {arrasc["22"]=""""} {arrasc["23"]="#"} {arrasc["24"]="$"} {arrasc["25"]="%"} {arrasc["26"]="&"} {arrasc["27"]="'"} {arrasc["28"]="("} {arrasc["29"]=")"} {arrasc["2a"]="*"} {arrasc["2b"]="+"} {arrasc["2c"]=","} {arrasc["2d"]="-"} {arrasc["2e"]="."} {arrasc["2f"]="\\/"} {arrasc["30"]="0"} {arrasc["31"]="1"} {arrasc["32"]="2"} {arrasc["33"]="3"} {arrasc["34"]="4"} {arrasc["35"]="5"} {arrasc["36"]="6"} {arrasc["37"]="7"} {arrasc["38"]="8"} {arrasc["39"]="9"} {arrasc["3a"]=":"} {arrasc["3b"]=";"} {arrasc["3c"]="<"} {arrasc["3d"]="="} {arrasc["3e"]=">"} {arrasc["3f"]="?"} {arrasc["40"]="@"} {arrasc["41"]="A"} {arrasc["42"]="B"} {arrasc["43"]="C"} {arrasc["44"]="D"} {arrasc["45"]="E"} {arrasc["46"]="F"} {arrasc["47"]="G"} {arrasc["48"]="H"} {arrasc["49"]="I"} {arrasc["4a"]="J"} {arrasc["4b"]="K"} {arrasc["4c"]="L"} {arrasc["4d"]="M"} {arrasc["4e"]="N"} {arrasc["4f"]="O"} {arrasc["50"]="P"} {arrasc["51"]="Q"} {arrasc["52"]="R"} {arrasc["53"]="S"} {arrasc["54"]="T"} {arrasc["55"]="U"} {arrasc["56"]="V"} {arrasc["57"]="W"} {arrasc["58"]="X"} {arrasc["59"]="Y"} {arrasc["5a"]="Z"} {arrasc["5b"]="["} {arrasc["5c"]="\\\\"} {arrasc["5d"]="]"} {arrasc["5e"]="^"} {arrasc["5f"]="_"} {arrasc["60"]="`"} {arrasc["61"]="a"} {arrasc["62"]="b"} {arrasc["63"]="c"} {arrasc["64"]="d"} {arrasc["65"]="e"} {arrasc["66"]="f"} {arrasc["67"]="g"} {arrasc["68"]="h"} {arrasc["69"]="i"} {arrasc["6a"]="j"} {arrasc["6b"]="k"} {arrasc["6c"]="l"} {arrasc["6d"]="m"} {arrasc["6e"]="n"} {arrasc["6f"]="o"} {arrasc["70"]="p"} {arrasc["71"]="q"} {arrasc["72"]="r"} {arrasc["73"]="s"} {arrasc["74"]="t"} {arrasc["75"]="u"} {arrasc["76"]="v"} {arrasc["77"]="w"} {arrasc["78"]="x"} {arrasc["79"]="y"} {arrasc["7a"]="z"} {arrasc["7b"]="{"} {arrasc["7c"]="|"} {arrasc["7d"]="}"} {arrasc["7e"]="~"} {arrasc["7f"]="DEL"} {arrasc["80"]=""} {arrasc["81"]=""} {arrasc["82"]=""} {arrasc["83"]=""} {arrasc["84"]="IND"} {arrasc["85"]="NEL"} {arrasc["86"]="SSA"} {arrasc["87"]="ESA"} {arrasc["88"]="HTS"} {arrasc["89"]="HTJ"} {arrasc["8a"]="VTS"} {arrasc["8b"]="PLD"} {arrasc["8c"]="PLU"} {arrasc["8d"]="RI"} {arrasc["8e"]="SS2"} {arrasc["8f"]="SS3"} {arrasc["90"]="DCS"} {arrasc["91"]="PU1"} {arrasc["92"]="PU2"} {arrasc["93"]="STS"} {arrasc["94"]="CCH"} {arrasc["95"]="MW"} {arrasc["96"]="SPA"} {arrasc["97"]="EPA"} {arrasc["98"]=""} {arrasc["99"]=""} {arrasc["9b"]="CSI"} {arrasc["9c"]="ST"} {arrasc["9d"]="OSC"} {arrasc["9e"]="PM"} {arrasc["9f"]="APC"} {arrasc["a2"]=""} {arrasc["a3"]=""} {arrasc["a4"]=""} {arrasc["a5"]=""} {arrasc["a6"]=""} {arrasc["a7"]=""} {arrasc["a8"]=""} {arrasc["a9"]=""} {arrasc["b9"]=""} {arrasc["c1"]=""} {arrasc["c2"]=""} {arrasc["c3"]="@@DQ