Lotus Notes SQL 2.0 (2.04.0203)

You can obtain this driver from the Lotus Web site. Read the documentation that comes with it for an explanation of how Notes data maps to relational tables. You can easily map IQ tables to Notes forms.

See ”Lotus Notes SQL 2.0” in SQL Anywhere Server - SQL Usage.

To set up Sybase IQ to access the Address sample file, follow this procedure.

Setting up IQ to access the Address sample file

Create an ODBC data source using the NotesSQL driver.

The database will be the sample names file c:\notes\data\names.nsf. The Map Special Characters option should be turned on. For this example, the Data Source Name is my_notes_dsn.

Create an IQ server:

CREATE SERVER names
CLASS 'odbc'
USING 'my_notes_dsn'

Map the Person form into an IQ table:

CREATE EXISTING TABLE Person
AT 'names...Person'

Query the table
```
SELECT * FROM Person
```