Author Topic: RECORDRANGE and GROUPRANGE  (Read 4935 times)

pankaj.puranik

  • Guest
RECORDRANGE and GROUPRANGE
« on: November 29, 2010, 12:06:29 AM »
Hi

Has anyone used the RECORDRANGE and GROUPRANGE parameters in the indexer program?
Could anyone share an example?

Thanks
Pankaj.

Greg Ira

  • Full Member
  • ***
  • Posts: 240
    • View Profile
Re: RECORDRANGE and GROUPRANGE
« Reply #1 on: December 01, 2010, 12:59:09 PM »
Here is an example of GROUPRANGE.  This is indexing a large log file and the grouprange index will give me the start and end times for the log which are in the format hh:mm:ss 

FIELD1=0,12,6,(TRIGGER=1,BASE=0)
FIELD2=0,21,5,(TRIGGER=1,BASE=0)
FIELD3=*,*,8,(OFFSET=(27:34),MASK='##:##:##',ORDER=BYROW)
INDEX1=X'D985979699A36DD5819485',FIELD1,(TYPE=GROUP,BREAK=NO)     /* Report_Name */
INDEX2=X'D396876DC481A385',FIELD2,(TYPE=GROUP,BREAK=NO)           /* Log_Date    */
INDEX3=X'D396876DE3899485',FIELD3,(TYPE=GROUPRANGE,BREAK=NO)      /* Log_Time    */


Greg Ira

  • Full Member
  • ***
  • Posts: 240
    • View Profile
Re: RECORDRANGE and GROUPRANGE
« Reply #2 on: December 01, 2010, 01:16:51 PM »
And to add to my previous post.  To use the index I have two fields defined:  Log_Time and Log_Time_end.  In the application under the Load Information tab in Preprocessor Parameters both those fields have Log_Time set as the Load ID name. 

pankaj.puranik

  • Guest
Re: RECORDRANGE and GROUPRANGE
« Reply #3 on: December 03, 2010, 12:28:59 AM »
So that means GROUPRANGE is mainly used with transaction type of reports where I need the starting and ending values for a group, correct?

Greg Ira

  • Full Member
  • ***
  • Posts: 240
    • View Profile
Re: RECORDRANGE and GROUPRANGE
« Reply #4 on: December 03, 2010, 07:04:29 AM »
Correct

pankaj.puranik

  • Guest
Re: RECORDRANGE and GROUPRANGE
« Reply #5 on: December 16, 2010, 01:10:22 AM »
I also came across PAGERANGE.
Have you used pagerange also?