Recently, the Firebird on mailing list (the site firebase.com.br), I had the opportunity to meet an added feature in the latest stable version of this database manager, version 2.5 and this feature in the sentence syntax "EXECUTE STATEMENT".
This matter is already known since version 1.5, and already have used it, to build dynamic SQL, formed with string concatenation, but the additional syntax is the "ON EXTERNAL".
Within a procedure or trigger, would be used something like:
EXECUTE ETATEMENT :sql
WITH COMMON TRANSACTION
AS USER :user
PASSWORD :password
ON EXTERNAL :databasepath ;
It is something very recent, so that people have the image related to Firebird, have not used it.
About UDF Database Link, the native feature of version 2.5 makes the functionality of the installation is not necessary developed by me, since integration is between 2 Firebird databases.
But it is good to know that the UDF DBLink in which I worked, allows to work with ODBC, so the work goes much can view or enter data in several other types of management systems such as PostgreSQL, Oracle and even Excel, which are where already tested.
In summary, the requirements for the "EXECUTE STATEMENT ON EXTERNAL" is a Firebird version 2.5 and an external base which should also be Firebird.
Ja UDF Database Link can be used in Feribird 2.1 (where tested, might work in 1.5), Windows Server and ODBC data source to connect to another data source, and may be even Excel.
More details can be found in the reference manual of the Firebird language:
http://www.firebirdsql.org/refdocs/langrefupd25-psql-execstat.html
Nenhum comentário:
Postar um comentário