Creating the SQL/R example databaseSQL/R ODBC includes an example database. It is is primarily intended for use with the SQL/R tutorial. However, its also an easy starting point when exploring the SQL/R product.
The SQL/R example database is available with German or English table and item names. The instructions below demonstrate how to install the English version. Please find instructions to install the German version at the end of the document.
The following commands create the SQL/R example database in the default eloqdb server
cd /opt/sqlr2/share/db.e/ schema db.schema dbcreate db dbimport -vs db.exp dbThis creates the database "db" and imports the data.
To make the database accessible as a DSN please adjust the odbc.dsn configuration file as below:
[SQL/R Example] Database=localhost:eloqdb/db Repository = /opt/sqlr2/share/db.e/db.rep
To install the German version, please replace all instances /opt/sqlr2/share/db.e with /opt/sqlr2/share/db.g.