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

  1. Type u md cust.ord at the TCL prompt.
  2. Type q in attribute 1.
    Note: Attribute 2 is left blank, press ENTER to continue.
  3. Type sqlsvr.host:odbc:cust.ord in attribute 3.
  4. Type a table name and column name(s) from the Northwind database in attribute 4, and then press CTRL+V. For example:
    customers,order
  5. (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"
  6. (Optional) Type a candidate key, and then press CTRL+V. See Developing super Q-pointers for more information on candidate keys.
  7. 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.