| Subject: | Re: Questions about SQL::Statement |
| Date: | Mon, 24 Oct 2011 20:35:02 -0700 (PDT) |
| To: | "rehsack [...] cpan.org" <rehsack [...] cpan.org>, "bug-SQL-Statement [...] rt.cpan.org" <bug-SQL-Statement [...] rt.cpan.org> |
| From: | Ze'ev Atlas <zatlas1 [...] yahoo.com> |
Sir
I wish to report a bug
The function.pm file contains two places where it says do_er rather then do_err (lines 131 and 134). When I fixed that it worked as advertised.
Ze'ev Atlas
201-801-0378
201-805-0286 (cell)
From: Ze'ev Atlas <zatlas1@yahoo.com>
To: "rehsack@cpan.org" <rehsack@cpan.org>
Sent: Monday, October 24, 2011 5:44 PM
Subject: Questions about SQL::Statement
Good day sir
Thank you for the SQL::Statement module
I would like to ask you a couple of questions:
1. It is not clear how to create a file to satisfy
$parser->parse("LOAD 'MyLib::MySyntax' ");
I understand that by sifting through all documentation I should be able to figure it out, but do you by a chance have some samples that could expedite my understanding.
2. Similarly, assuming I want the package to recognize the DATE function of DB2
as far as I am concerned (since I do only syntax parsing), the function could do nothing, maybe return the input parameter as is.
What shopuld be therefore the syntax for
$parser->parse("CREATE FUNCTION DATE ...");
so I won't get an error message such as
Can't locate object method "do_er" via package "SQL::Statement" at C:/Perl/lib/SQL/Statement/Function.pm line 134, <IFILE> line 728.
If that would work for me, I may add some of the problematic keywords such as WITH, FOR and so on (that DB2 use for optimization, etc.) and be done with... but I need to know how!
I am pretty good in Perl, but I couldn't find (yet) any obvious place in the documentation to answer these questions
Thank you so much
Ze'ev Atlas
201-801-0378
201-805-0286 (cell)