View Source

&<img src="../resources/images/opentocr.png" title="Open Contents list" border="0"&>
You are here:

Access Route Examples

These examples apply to defining an access route within a table definition.
Four related table definitions are used in these examples. These are defined as follows:

Table:		ORDHDR	ORDLIN	CUSMST	PROMST
Desc:		Order header	Order lines	Customer master	Product master
Columns:		ORDNUM CUSTNO DATE	ORDNUM ORDLIN QUANTY PRODNO	CUSTNO NAME ADDR1 ADDR2 ADDR3	PRODNO DESC PRICE TAXRTE
Primary Key	1	ORDNUM	ORDNUM	CUSTNO	PRODNO
	2		ORDLIN
Indexes:		ORDHDRV1O	RDLINV1
by key	1	CUSTNO	PRODNO

|
To allow complete traversal of this database by users the following access routes would be defined:

Definition Name	Access Route Name	Table to be accessed via this route	Max Rcds Expected	Action to be taken if no records found	Key Columns/Values Used for access
ORDHDR	ORDHRT1	ORDLIN	99	IGNORE	ORDNUM
	ORDHRT2	CUSMST	1	ABORT	CUSTNO
ORDLIN	ORDLRT1	ORDHDR	1	ABORT	ORDNUM
	ORDLRT2	PROMST	1	ABORT	PRODNO
CUSMST	CUSMRT1	ORDHDRV1	9999	IGNORE	CUSTNO
PROMST	PROMRT1	ORDLINV1	9999	IGNORE	PRODNO

|
From this table it is easy to see how LANSA can follow the access route chains. For example, if the user nominated PROMST (product master) as a "starting" or "base" table, then the following would occur:

Using access route PROMRT1 a route to ORDLIN (order lines) is available (via index ORDLINV1) which will access all invoice lines that use the product.
From ORDLIN the associated order header (ORDHDR) details can be picked up using access route ORDLRT1. The access route ORDLRT2 back to PROMST would be ignored as it forms a "loop".
From ORDHDR the associated customer details (CUSMST) can be found via access route ORDHRT2. Again ORDHRT1 would be ignored as it forms a "loop".

&<img src="../resources/images/opentoc-dark.png" title="Open Contents List" border="0"&>