To work with a data source, you must first open a database in R:BASE, then you can connect the data source and select the table(s) with which you want to work. You can attach as many tables as you like.
Once you have attached a table from a data source, you can work with the data as you would with R:BASE data. However, you cannot use the following R:BASE commands with attached data source tables:
Restrictions on attached tables by foreign databases remain in effect--you can only perform actions on attached tables that are allowed within the restrictions of any access rights, rules, or constraints on the foreign database. For example, if your access rights to a foreign database allow you to view data only, you will receive an error message from the data source if you try to modify data.
For best performance, your attached tables should have a primary or unique key defined.
ODBC Topics:
Connecting Data Sources and Tables
Disconnecting Data Sources and Tables
See also:
