first of all wrong group this is not support list.
But you doing somethink what is supported by execute statement, and you do mot need to modify external table intf. Execute statement in Fb2.5 can run query against external database
----- Reply message -----
Od: "Gopala Krishna Gundeboyina" <f2001642@...>
Do: "For discussion among Firebird Developers" <firebird-devel@...>
Temat: [Firebird-devel] SQL Hint
Data: śr., sty 23, 2013 15:32
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!!