Netezza sql analyzer framework

sarf13 has asked for the wisdom of the Perl Monks concerning the following question:

Hi All

I have to create sql analyzer framework for Netezza sql. Netezza sql is little bit different from other DB sql. I want to use SQL::Parser and SQL::Statement. Can anyone tell me how I can customize these module based on my requirement. How can I override the public methods of these modules? What approach should I take up for this task?

Thanks

Comment on Netezza sql analyzer framework

Replies are listed 'Best First'.
Re: Netezza sql analyzer framework by Corion (Patriarch) on Jul 12, 2012 at 12:09 UTC
I would assume that the approach to customize the modules is to find out the differences between Netezza SQL and the SQL accepted by the modules, and then to adapt the modules to also accept the Netezza dialect. For example, SQL::Parser has a `->dialect` method, and I would consider looking at how that method influences the parser, and use one of the dialects as a basis to implement my own.	[reply] [d/l]
Re^2: Netezza sql analyzer framework by sarf13 (Beadle) on Jul 16, 2012 at 06:13 UTC
Thank you very much Corion.i am going to start my work now onwards.	[reply]