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.
Notes:
•For best performance, the attached tables should have a primary or unique key defined.
•When queries are sent to the server avoid using abbreviated commands by writing complete keywords, such as "WHERE" and not "WHE".
ODBC Topics:
Connecting Data Sources and Tables
Disconnecting Data Sources and Tables
See also: