how to skip banner page from line data report

[jw]

I have a line data report and the first 2 pages are banner pages.  Real data pages are from page 3 onward.

Is there any way to define the application to ignore those 2 banner pages?

Thanks in advance for your help.

[Justin Derrick]

Check out the IndexStartBy parameter in ACIF.  It allows you to specify the allowed number of pages before finding a trigger/index value.

Let us know how it turns out.

-JD.

[jw]

Thanks Justin.  Will keep you posted.

[jw]

Justin,

I tried it and it still failed with the following messages.  It seems to me that CMOD still find the index field from page 1 and page 2 even the IndexStartBy=3.

Am I still missing something?

Thanks for your help.
=====================

arsload: Processing file >XXXX.YYYYYYYY.STEP0010.AFX0230A.2013193.07425362724.ARD<
arsload: Load Version <8.5.0.6> Operating System <AIX> <6.1>
arsload: Server Version <8.5.0.6> Operating System <AIX> <6.1> Database <DB2> <09.05.0010>
arsload: 07/12/13 07:45:47 -- Indexing started, 3413016 bytes to process
APK415I CC=YES
APK415I CCTYPE=A
APK415I CONVERT=NO
APK415I CPGID=500
APK415I MCF2REF=CPCS
APK415I TRC=NO
APK415I FILEFORMAT=RECORD
APK415I TRIGGER1=*,1,X'F1',(TYPE=GROUP)
APK415I FIELD1=3,120,10,(TRIGGER=1,BASE=0)
APK415I FIELD2=0,12,4,(TRIGGER=1,BASE=0)
APK415I FIELD3=0,128,4,(TRIGGER=1,BASE=0)
APK415I INDEX1=X'D985979699A3C481A385',FIELD1,(TYPE=GROUP,BREAK=NO)
APK415I INDEX2=X'C29981958388D5A494828599',FIELD2,(TYPE=GROUP,BREAK=YES)
APK415I INDEX3=X'D7818785D5A494828599',FIELD3,(TYPE=GROUP,BREAK=NO)
APK415I DCFPAGENAMES=NO
APK415I UNIQUEBNGS=YES
APK415I IMAGEOUT=ASIS
APK415I INDEXOBJ=ALL
APK415I INDEXSTARTBY=3
APK415I INSERTIMM=NO
APK415I RESTYPE=NONE
APK415I inputdd=/arsjesd_downloads/XXXX.YYYYYYYY.STEP0010.AFX0230A.2013193.07425362724.ARD
APK415I outputdd=/dev/null
APK415I indexdd=./XXXX.YYYYYYYY.STEP0010.AFX0230A.2013193.07425362724.ARD.ind
APK415I resobjdd=/dev/null
APK440I ACIF AT IM43P11 HAS COMPLETED NORMALLY WITH RETURN CODE 0.
arsload: 07/12/13 07:45:48 Indexing completed
arsload: 07/12/13 07:45:48 -- Loading started, 3413016 bytes to process
Row 1:  The string "" could not be converted to a date from the format of %m/%d/%Y
Loaded 0 rows into the database
arsload: 07/12/13 07:45:48 Loading failed
arsload: Processing failed for file >XXXX.YYYYYYYY.STEP0010.AFX0230A.2013193.07425362724.ARD<
arsload: Processing has stopped.  The remaining files will NOT be processed.

[Justin Derrick]

You need to find something else to trigger on -- not just the 'top of form' character.  Find something on the 3rd  (and subsequent) pages that doesn't exist on the first two pages.

Hope that helps!

-JD.

[jw]

I created a 2nd trigger and it works.

Thanks Justin.