OnDemand Users Group

Support Forums => Report Indexing => Topic started by: PasiPK on July 29, 2010, 08:14:22 AM

Title: Loading one document, index fields on first page, how to stop scanning
Post by: PasiPK on July 29, 2010, 08:14:22 AM
Hello,
I am loading just one long line data document.
It has ASA/CC characters in first column, so there are multiple pages.
All pages have exactly same titles, from which index fields are picked.
So the needed index values are found already on first page,
and all the following pages have the same values.

I have
TRIGGER1=*,1,X'F1',(TYPE=GROUP)  /* 1 */
FIELD1=1,9,10,(TRIGGER=1,BASE=0)
etc.
INDEX1='KEY1',FIELD1,(TYPE=GROUP,BREAK=YES)
etc.
all INDEXn have TYPE=GROUP,BREAK=YES.

My understanding is, that all pages are scanned.
Which in this application is wasted work, because values do not change.
Probably not a big deal, but would there be some better way to do this?

Pasi
Title: Re: Loading one document, index fields on first page, how to stop scanning
Post by: pankaj.puranik on March 15, 2011, 01:55:01 PM
Ok. From what I understand from your post is that you have only a single document in the report file.
Whatever be the case, every record in each page will always be read because you have a * for records in TRIGGER1.
I don't think there's a way to tell CMOD to read only the first page.
Title: Re: Loading one document, index fields on first page, how to stop scanning
Post by: LWagner on March 17, 2011, 05:21:02 PM
If you have a page number, make "Page 1" a group trigger,  or "Page 1 "

Then it won't repeat.
Title: Re: Loading one document, index fields on first page, how to stop scanning
Post by: rick on March 18, 2011, 11:05:10 AM
But still I guess the scan will be across the complete document.
Title: Re: Loading one document, index fields on first page, how to stop scanning
Post by: pankaj.puranik on March 22, 2011, 11:13:59 PM
That is correct.