Data Injection Markup Language Reference

Datasource Definition - sqlsource statement

Module : SQL Extension

Group : Datasources

<%sqlsource 
   name="source-identifier" 
   source="database-connection-scheme" 
   login="login" 
   password="password>" %>

The sqlsource statement allows defining connections to external datasources such as databases. Connections are referred to by an identifier, and may be used by any other statement of the SQL Extension.

For the Perl implementation, Actual connections are open using the DBI generic database library. The connection scheme uses the following syntax:

source="DBI:database-type:database-name;host=hostname"

The SQL::LAST_DEFINED_SOURCE variable contains datasource identifier of the connection opened by the latest <%sqlsource statement call. It may serve as default datasource for any SQL statement with no source defined.

previous summary next

All material is copyleft V.G. FREMAUX (EISTI France) 1999 to 2003 except explicitly mentioned