Still no good...I just wished the damn 88 message gave you SOMETHING to track down....Below is the entire indexer we're using....for the remainder of the indexing fields, we use the GROUP RANGE Trigger based on ACCOUNT ..whats strange is, prior to trying to use the Posting Date, we got the file to load, BUT the first page (where the date is) was dropped...Doesn't show anywhere in the version..We thinking because of the RecordRange being used it wouldn't be indexed...Just thought it would be appended on some other page. But its like that page got discarded entirely
TRIGGER1=*,1,X'F1',(TYPE=GROUP)
TRIGGER2=*,2,X'C1C3C3D6E4D5E37A',(TYPE=GROUP,RECORDRANGE=(1,4))
TRIGGER3=1,19,X'C481A3857A',(TYPE=GROUP)
FIELD1=19,50,16,(TRIGGER=2,BASE=0)
FIELD2=5,11,4,(TRIGGER=2,BASE=0)
FIELD3=1,16,11,(TRIGGER=2,BASE=0)
FIELD4=0,10,35,(TRIGGER=2,BASE=0)
FIELD5=1,57,3,(TRIGGER=2,BASE=0)
FIELD6=7,19,6,(TRIGGER=2,BASE=0)
FIELD7=4,51,8,(TRIGGER=2,BASE=0)
FIELD8=3,49,3,(TRIGGER=2,BASE=0)
FIELD9=3,9,25,(TRIGGER=2,BASE=0)
FIELD10=8,11,10,(TRIGGER=2,BASE=0)
FIELD11=7,54,1,(TRIGGER=2,BASE=0)
FIELD12=5,52,3,(TRIGGER=2,BASE=0)
FIELD13=15,23,35,(TRIGGER=2,BASE=0)
FIELD14=13,14,17,(TRIGGER=2,BASE=0)
FIELD15=9,22,12,(TRIGGER=2,BASE=0)
FIELD16=9,58,1,(TRIGGER=2,BASE=0)
FIELD17=10,18,15,(TRIGGER=2,BASE=0)
FIELD18=6,58,16,(TRIGGER=2,BASE=0)
FIELD19=0,24,8,(TRIGGER=3,BASE=0)
INDEX1=X'E2E6C9C6E36DE3D9D5',FIELD1,(TYPE=GROUP,BREAK=YES)
INDEX2=X'D4E2C76DE3E8D7C5',FIELD2,(TYPE=GROUP,BREAK=YES)
INDEX3=X'C3D6D9D96DC2C9C3',FIELD3,(TYPE=GROUP,BREAK=YES)
INDEX4=X'C1C3C3E36DD5',FIELD4,(TYPE=GROUP,BREAK=YES)
INDEX5=X'C2D5E86DC2C3D6C4C5',FIELD5,(TYPE=GROUP,BREAK=NO)
INDEX6=X'C9E2D56DD6E2D5',FIELD6,(TYPE=GROUP,BREAK=YES)
INDEX7=X'E5C4C1E3C5',FIELD7,(TYPE=GROUP,BREAK=NO)
INDEX8=X'C3E4D9D9C5D5C3E8',FIELD8,(TYPE=GROUP,BREAK=NO)
INDEX9=X'C1D4E3',FIELD9,(TYPE=GROUP,BREAK=NO)
INDEX10=X'C6E4D5C3E3C9D6D5',FIELD10,(TYPE=GROUP,BREAK=NO)
INDEX11=X'C4C9D96DC9D6',FIELD11,(TYPE=GROUP,BREAK=NO)
INDEX12=X'C1D7D7D36DC9C4',FIELD12,(TYPE=GROUP,BREAK=YES)
INDEX13=X'C6C9D56DC9D5E2E3',FIELD13,(TYPE=GROUP,BREAK=NO)
INDEX14=X'D9E2D56DE3E8D7C5',FIELD14,(TYPE=GROUP,BREAK=NO)
INDEX15=X'E2C5E36DD7D3C1C3C5',FIELD15,(TYPE=GROUP,BREAK=NO)
INDEX16=X'D6C6C1C36DE2E3C1E3',FIELD16,(TYPE=GROUP,BREAK=NO)
INDEX17=X'E2C5D5C46DD4E2C7',FIELD17,(TYPE=GROUP,BREAK=NO)
INDEX18=X'D9C5D36DD9C5C6',FIELD18,(TYPE=GROUP,BREAK=NO)
INDEX19=X'D7D6E2E3C9D5C76DC4C1E3C5',FIELD19,(TYPE=GROUP,BREAK=NO)
Here is a screen shot of actual database where the date appears
=COLS> ----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
****** ***************************** Top of Data ******************************
000001 1*** FNI ON DEMAND REPORT ******************************************* PA
000002 FNI Messages for Date:10/16/17
000003
000004 KINDLY NOTE THAT FNI ONDEMAND REPORT CREATION STARTED SEPTEMBER 1, 2
000005 MERVA MESSAGES. MRV REPORTS WILL CONTINUE TO BE PRODUCED FOR NEW MSG
000006 GRACE PERIOD THROUGH NOVEMBER, 2009. MERVA (MRV) ONDEMAND REPORTS WI
000007 BE NEEDED, TO LOOK UP MERVA MESSAGES PROCESSED PRIOR SEPTEMBER 1, 20
000008
000009 FOR THE BENEFIT OF NEW USERS, A COMPUTER BASED TRAINING IS AVAILABLE
000010 THE INTRANET
http://xsa00x02:9212/fni/training/on_demand_reports.ht000011
000012 ADDITIONAL TRAINING ISSUES MAY BE ADDRESSED TO THE EFM SERVICE DESK
000013 VILLAGE. ON DEMAND ACCESS ISSUES SHOULD BE ADDRESSED via e-mail grou
000014 AND CC THE EFM SERVICE DESK.
000015
000016 1*** ACK/NAK AND/OR MSG KEYS **************************************** PA