Page Indexing Criteria Example

Creating Logical Views › Specifying and Accessing Page Indexes › Page Indexing Criteria Example

Page Indexing Criteria Example

The following illustration shows the Page Indexing Criteria panel for the TESTRPT SYSOUT:

CA View ALL ------ View Definition - Indexing Criteria ------ Row 00001 of 00008 Command ===> Scroll ===> PAGE View ID --> TESTRPT Cross Report Index ===> NO (Specify YES or NO) Search Specifications: Begin End Begin End Sel Line Line Column Column Op Text T R Extraction Specifications: Left Upper Sel Index Line Column Length Extract Justify Case DIVSISON 1 1 10 NBLK NO NO NAME 2 1 30 FIRST NO NO ******************************** BOTTOM OF DATA ********************************

Be aware of the following:

This example uses multi level indexing.
You can define up to eight levels of index.
For TESTRPT, the primary index is called DIVISION and the sub‑index is called NAME.

The following illustration shows the Page Indexing Criteria panel for the SALESRPT SYSOUT:

CA View ALL ------ View Definition - Indexing Criteria ------ Row 00001 of 00008 Command ===> Scroll ===> PAGE View ID --> SALESRPT Cross Report Index ===> YES (Specify YES or NO) Search Specifications: Begin End Begin End Sel Line Line Column Column Op Text T R 1 60 100 EQ 'SUMMARY' Extraction Specifications: Left Upper Sel Index Line Column Length Extract Justify Case REGION 2 1 20 ALL NO NO AMOUNT 2 40 15 ALL NO NO ******************************** BOTTOM OF DATA ********************************

Be aware of the following:

This example extracts two index fields from the report summary pages: Region and Sales Amount.
The index is defined as a cross report index.

The following illustration shows the Page Indexing Criteria panel for the BANKRPT SYSOUT:

CA View ALL ------ View Definition - Indexing Criteria ------ Row 00001 of 00008 Command ===> Scroll ===> PAGE View ID --> BANKRPT Cross Report Index ===> NO (Specify YES or NO) Search Specifications: Begin End Begin End Sel Line Line Column Column Op Text T R 3 60 100 LK '###-########' Extraction Specifications: Left Upper Sel Index Line Column Length Extract Justify Case BRANCH 2 1 5 ALL NO NO ACCOUNT @+0 @+0 12 ALL NO NO NAME @+1 @+5 20 ALL NO NO ******************************** BOTTOM OF DATA ********************************

Be aware of the following:

This example extracts three index fields from a report: Branch, Account, and Name.
The report can contain more than one account on a page.

The following illustration shows the View Selection panel; note that page indexing information is included as part of the logical view definition.

CA View EXPO ---------------- View Selection -------------------------------- Command ===> Scroll ===> HALF Index Value ===> Sel Num Acc View ID Description __ 000 PUB REPORT1 NATIVE BROWSE __ 001 PUB VIEW INDEXED BY DIVISION AND NAME __ 002 PUB VIEW INDEXED BY TITLE __ 003 PUB VIEW INDEXED BY STATE __ 004 PUB VIEW INDEXED BY DATE __ 005 PUB VIEW INDEXED BY NAME __ 006 PUB __ 007 PUB __ 008 PRV USER PRIVATE LOGICAL VIEW

Each primary index name (DIVISION, TITLE, and so on) is listed with the view description.
The Index Value field allows you to enter an initial text string to be located from the index choices.