Creating a super Q-pointer

Follow these steps to create a Super Q-pointer called cust.ord using the Update Processor.

This example shows how to retrieve data from two tables from the Northwind database called, Customers and Orders.

Procedure

Type u md cust.ord at the TCL prompt.
Type q in attribute 1.
Note: Attribute 2 is left blank, press ENTER to continue.
Type sqlsvr.host:odbc:cust.ord in attribute 3.
Type a table name and column name(s) from the Northwind database in attribute 4, and then press CTRL+V. For example:
```
customers,order
```
(Optional) Type a where clause, and then press CTRL+V. See Developing super Q-pointers for more information on where clauses. For example:
```
 "customers"."customerid" = "orders"."customerid"
```
(Optional) Type a candidate key, and then press CTRL+V. See Developing super Q-pointers for more information on candidate keys.
Type the column name(s) from the Northwind database, and then press CTRL+XF to save to file. For example:
```
customers.customerid
orderid
orderdate
```
The Super Q-pointer cust.ord displays.