I have modified Firebird External Table interface to retrieve data from a
proprietary database basically to take advantage of the SQL interface.
I have been using it for some time and most of the standard SQL statements
work great. But there are some additional attributes (call them as HINT)
that I want to pass along with the SQL queries which basically makes sense
to proprietary database but are non SQL standard.
I was looking for a clean solution and the first thing I tried was to embed
them as comments (HINT) in SQL statements extract them while executing it.
I was able to extract them from plain SQL statements but obviously it
doesn't work with parametrized queries, stored procedures and views as
they are ignored in BLR form.
Can someone please suggest me a workaround or a better way to achieve this?
Any alternate options that I have?
Thanks in advance!!
Get latest updates about Open Source Projects, Conferences and News.