|
<< Click to Display Table of Contents >> Cross-database operations |
  
|
|
<< Click to Display Table of Contents >> Cross-database operations |
|
BDE query and batch functions can operate on heterogeneous data sources. The following examples illustrate this feature:
•A single SQL or QBE query, can do a three-table join, for example, between InterBase, Oracle, and Paradox tables, and update a Sybase table with join result. For more information, see "Heterogeneous Joins" in the Local SQL Guide
•DbiBatchMove can be used to copy one table type to another; for example, a Paradox table to an Oracle server. All the data types are converted to the appropriate Oracle data types. The table name and all field names are converted to legal Oracle names, and options exist to convert any textual data between the character sets of the two data sources. For more information, see Adding, updating, and deleting records.
•DbiSortTable can be used, for example, to sort an Oracle table and return the result as a Paradox or a dBASE table. For more information, see Sorting tables.
•See Querying databases for a thorough exposition about cross-database operations.