"Flowers, Jay" wrote: > > I am not sure if this is the right place to be asking such a question? > > I am writing a sniffer in perl and would like to be able to decode data in > TCP packets from SQL clients and servers. I was wondering if there was part > of the DBI that I could use to decode the raw data, or if someone could > point me to the protocol specs for SQL.
I'm not sure what you are wanting to do when you say "decode data", but if it involves parsing the SQL statements, SQL::Parser (part of the newest SQL::Statement distribution) will do that for a limited subset of SQL. If it involves parsing the data rather than SQL statements, then DBD::AnyData may be able to help. As for the SQL specs, the full ones cost money and are available for download at http://www.ansi.com/. *Draft* specs for SQL3 can be found at http://194.109.245.185/sql/sqltmprl.pdf My favorite is the hyperlinked, browsable version of the BNF for SQL92 at http://cui.unige.ch/db-research/Enseignement/analyseinfo/SQL92/BNFindex.html -- Jeff
