OnDemand Users Group

Support Forums => Report Indexing => Topic started by: curioste on September 23, 2010, 04:06:29 PM

Title: CMOD Indexing - Newbie
Post by: curioste on September 23, 2010, 04:06:29 PM
I have a normal print document with carriage control at the top of every page.  I am trying to index based on a value string at column 2 on the whole document.  The value I am looking for shows up multiple times before the next carriage control on each page.  I thought using TRIGGER1=2,*,'APPLICATION: ',(TYPE=GROUP), would catch the word 'APPLICATION: ' as the trigger throughout the document.  But it only occurs after carriage control 1.  Is there anything I can do here?  The sample is below.

1
APPLICATION: AIXMATCH

EVENT: SCHED.AIXMATCH

RUN DATES: THU 23 SEP 2010

                    SUB                           *** RELEASES ***                                *** REFERENCED BY ***
HOLD TAG       TYPE TIME   JOBNAME  QUALIFIER HC JOBNAME  QUALIFIER  RESOURCE      SCOPE     APPL     JOBNAME  QUALIFIER TYPE
---- ---       ---- ----   -------  --------- -- -------  --------   --------      -----     ----     -------- --------- ----
 N   PROD      JOB  00.01  SCPSCHDY            0 (NONE)              RUN_TIME
                           LongName = SCP_SCHEDULE_DAY
 N   PROD      JOB  18.00  SCPSCHAP            0 (NONE)              RUN_TIME
                           LongName = SCP_SCHEDULE_AP

END OF APPLICATION: AIXMATCH

APPLICATION: AS400

EVENT: SCHED.AS400

RUN DATES: THU 23 SEP 2010

                    SUB                           *** RELEASES ***                                *** REFERENCED BY ***
HOLD TAG       TYPE TIME   JOBNAME  QUALIFIER HC JOBNAME  QUALIFIER  RESOURCE      SCOPE     APPL     JOBNAME  QUALIFIER TYPE
---- ---       ---- ----   -------  --------- -- -------  --------   --------      -----     ----     -------- --------- ----
 N   PROD      JOB         AS400               0 (NONE)              RUN_TIME

END OF APPLICATION: AS400

APPLICATION: CHECKDF

EVENT: SCHED.CHECKDF

RUN DATES: THU 23 SEP 2010

                    SUB                           *** RELEASES ***                                *** REFERENCED BY ***
HOLD TAG       TYPE TIME   JOBNAME  QUALIFIER HC JOBNAME  QUALIFIER  RESOURCE      SCOPE     APPL     JOBNAME  QUALIFIER TYPE
---- ---       ---- ----   -------  --------- -- -------  --------   --------      -----     ----     -------- --------- ----
 N   PROD      JOB         CHECKDF             0 (NONE)              RUN_TIME

END OF APPLICATION: CHECKDF

APPLICATION: CRITTASK

EVENT: SCHED.CRITTASK

RUN DATES: THU 23 SEP 2010

                    SUB                           *** RELEASES ***                                *** REFERENCED BY ***
HOLD TAG       TYPE TIME   JOBNAME  QUALIFIER HC JOBNAME  QUALIFIER  RESOURCE      SCOPE     APPL     JOBNAME  QUALIFIER TYPE
---- ---       ---- ----   -------  --------- -- -------  --------   --------      -----     ----     -------- --------- ----
 N   PROD      JOB         CRITTASK            0 (NONE)              RUN_TIME

END OF APPLICATION: CRITTASK

APPLICATION: DATAWHSE

EVENT: SCHED.DATAWHSE

1RUN DATES: THU 23 SEP 2010

                    SUB                           *** RELEASES ***                                *** REFERENCED BY ***
HOLD TAG       TYPE TIME   JOBNAME  QUALIFIER HC JOBNAME  QUALIFIER  RESOURCE      SCOPE     APPL     JOBNAME  QUALIFIER TYPE
---- ---       ---- ----   -------  --------- -- -------  --------   --------      -----     ----     -------- --------- ----
 N   PROD      JOB         DWSALES             0 (NONE)              RUN_TIME
                           LongName = BATCH_SCRIPTS_DW.SALES
 N   PROD      JOB  04.00  SVC100              0 (NONE)              RUN_TIME
                           LongName = BATCH_SCRIPTS_SVCLVL100_RUN
 N   PROD      JOB  05.30  MCSTRT              0 (NONE)              RUN_TIME
                           LongName = BATCH_SCRIPTS_MCSTART_CHK
 N   PROD      JOB  06.50  MCEND               0 (NONE)              RUN_TIME
                           LongName = BATCH_SCRIPTS_MCEND_CHK
 N   PROD      JOB  06.00  PHONEFTP            0 (NONE)              RUN_TIME
                           LongName = BATCH_SCRIPTS_FTP.SET
 N   PROD      JOB  18.00  PHONELOG            0 (NONE)              RUN_TIME
                           LongName = BATCH_SCRIPTS_PHONE
 N   PROD      JOB  06.00  SHIPRUN             0 (NONE)              RUN_TIME
                           LongName = BATCH_SCRIPTS_SHIPMENT_RUN

END OF APPLICATION: DATAWHSE

APPLICATION: ESPPMAIN   SUB-APPLICATION: ESPMAINT

EVENT: SCHED.ESPPMAIN

RUN DATES: THU 23 SEP 2010

                    SUB                           *** RELEASES ***                                *** REFERENCED BY ***
HOLD TAG       TYPE TIME   JOBNAME  QUALIFIER HC JOBNAME  QUALIFIER  RESOURCE      SCOPE     APPL     JOBNAME  QUALIFIER TYPE
---- ---       ---- ----   -------  --------- -- -------  --------   --------      -----     ----     -------- --------- ----

Title: Re: CMOD Indexing - Newbie
Post by: pankaj.puranik on September 28, 2010, 06:40:54 AM
Hi

Is it possible for you to provide the entire index file and a screen shot of the Data format tab on the Indexer Properties?

Thanks
Pankaj.
Title: Re: CMOD Indexing - Newbie
Post by: pankaj.puranik on October 21, 2010, 10:05:29 AM
While I was reading some CMOD documents, I came across this :
Common options for use as Triggers - Carriage control characters, pagination characters, unique headers.

Going by that, I think the Carriage control character should solve the purpose.

Cheers
Pankaj.
Title: Re: CMOD Indexing - Newbie
Post by: Greg Ira on October 22, 2010, 05:54:38 PM
Could be a typo in your post but I believe Trigger1 needs to be TRIGGER1=*,2,'APPLICATION: ',(TYPE=GROUP) if that was what you're aiming for(Trigger1 needs * for record number).  If you were shooting for TRIGGER2 I would go with TRIGGER2=*,2,'APPLICATION: ',(TYPE=FLOAT)
Title: Re: CMOD Indexing - Newbie
Post by: pankaj.puranik on October 27, 2010, 06:36:03 AM
I agree with Greg. A TYPE=FLOAT trigger should also work in your case.
Title: Re: CMOD Indexing - Newbie
Post by: Sammy on October 29, 2010, 05:35:18 PM
Or, why not define your trigger as the carriage control in column 1, such as:
TRIGGER1=*,1,X'F1',(TYPE=GROUP)

Then define field "Application" as a FIELD and INDEX referencing back to the carriage control. 
Title: Re: CMOD Indexing - Newbie
Post by: curioste on December 17, 2010, 04:28:05 PM
I know it's been so long, but I will try these things soon.  Thanks for all your advice!  I'll make a reply with my results soon.