In addition to WHERE driver string supported by all the SQL Accelerator drivers, Oracle Accelerator supports the following special WHERE driver string.
/Where in the FILE Definition
When a FILE declaration references more than one Oracle table, you must tell the Oracle server which columns link the tables together. A /WHERE in the FILE definition specifies the connecting fields between two or more Oracle tables. For example:
OrdBrowse FILE,DRIVER('ORACLE','/WHERE Orders.AccNum=Customer.AccNum'),|
NAME('Orders,Customer'),PRE(Orb),BINDABLE,THREAD
OrdbKey KEY(-Orb:OrderNumber),NAME('OrdbKey'),PRIMARY
Record RECORD,PRE()
OrderNumber LONG,NAME('OrderNum')
AccountNumber LONG,NAME('Orders.AccNum')
ShipTo STRING(32),NAME('ShipTo')
Name STRING(31),NAME('Name')
END
END
If you use the templates to generate your application, you will not need this technique. The templates automatically generate VIEWs when more than one table is referenced.