|
|
|
|
|
|
|
|
|
|
Multi-database queries
  Not available with these kinds of connection
A query (typed in SQL code) can operate on different databases: HFSQL, Oracle, SQL Server, etc. You can perform a join between a query on a database of one type and a query on a database of another type. Therefore, the data can be found in different databases. You have the ability to extract and aggregate data from any source. This feature is very useful for managing existing Information Systems. To better understand the operating mode of the multi-database queries, let's look at a simple example: - On an Oracle database, the following query (named MyQry1) is run by HExecuteSQLQuery. This query is used to select the record numbers of the customers.
SELECT Client.CLCleunik+10 AS CLCleunik10 FROM Client - On an HFSQL database, the following query (named MyQry2) is run by HExecuteSQLQuery. This query is used to select the record numbers of the customers and their order number.
SELECT CLCLEUNIK,Commande.NumeroCommande AS NUMCOMMANDE FROM COMMANDE - The multi-database query executed is as follows:
SELECT * FROM MaReq1,MaReq2
WHERE MaReq2.CLCLEUNIK=MaReq1.CLCleunik10
AND (MaReq2.NUMCOMMANDE = '37348' OR MaReq1.CLCleunik10=80)
This query is run itself by HExecuteSQLQuery.
Remark: Multi-database queries cannot be performed with "SQL query" variables.. It is necessary to use "Data Source" variables..
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|