This helps immensely, I cannot thank you enough.
I have fixed my FIRST OnDemand problem.
The problem was that this, FIELD3=4,-12,35,(TRIGGER=3,BASE=TRIGGER) instructed to go 4 lines down after finding the '.' (which is an amount, not part of the address). But it only needed to go 2 lines down. This tool will help a lot in the future.

A co-worker is telling me to do a walk through here is her text: "For Fayette, if you go into the OnDemand application and do update (right click and select update) with one of these reports on hold, you can specify the library and queue, you can 'walk' through the fields to see what the program is finding for the fields--especially field 3." I asked her how you do this with no response back. It appears she is saying you can see the data coming through on demand somehow, yet see nothing that I see enables a mode like that.

Agree, thanks for the follow up.

Thank you. I have a on demand application that appears to be setup correctly, comparing the setup to another functioning one. It will not go to on demand though. The system log does not show anything other than the log on and log off. Is there a file somewhere that I can query that shows more detail? Or is there somewhere that explains  the purpose of the files? Thank you.

It does and thank you for taking the time to do that. Searching through the manuals, I discovered some of that. Trigger 2 makes sense, it is looking for fiscal year. But Trigger3 (you accidently called it 2), is searching for a period, and this is in an address. It always stops on the CSZ line and uses that instead of the name. Even if there is a period in the name and first address. Here is a good example,
Innovative Ag Services Co.

2010 S Main St.

Monticello         ,IA 52310

It indexes the City State and zip. In this example there is a period. But in others, no period exists and it still shows city state zip.
I have tried moving the record range around, but end up with blanks then. Also searching for a blank, and it went way down to the bottom and picked up an amount.

QUESTION: Do you use the spool file entry to determine the lines in the Recordrange?

Thank you. Still struggling with how stuff gets indexed. I am sure a one sentence answer from a former employee who did this could clear it up for me.

Is this what I should be looking at?
 (Applications/indexer information/Details button)
I see the wrong field in question, entity, but have no idea what the parameters mean.


All of it:
CC=YES
CCTYPE=A
CONVERT=NO
CPGID=37
MCF2REF=CPCS
TRC=NO
FILEFORMAT=RECORD
TRIGGER1=*,1,X'F1',(TYPE=GROUP)                          /* 1      */
TRIGGER2=*,*,X'61F2F0',(TYPE=GROUP,RECORDRANGE=(1,4))    /* /20    */
TRIGGER3=*,23,X'4B',(TYPE=GROUP,RECORDRANGE=(2,6))       /* .      */
FIELD2=0,-4,9,(TRIGGER=2,BASE=TRIGGER)
FIELD3=4,-12,35,(TRIGGER=3,BASE=TRIGGER)
INDEX2=X'A8858199',FIELD2,(TYPE=GROUP,BREAK=YES)         /* year   */
INDEX3=X'8595A389A3A8',FIELD3,(TYPE=GROUP,BREAK=YES)     /* entity */
DCFPAGENAMES=NO
UNIQUEBNGS=YES
IMAGEOUT=ASIS
INDEXOBJ=GROUP
INDEXSTARTBY=1
INSERTIMM=NO
RESTYPE=NONE
DOCTYPE=AFP

Thanks for you quick reply. But on number 1, how the heck is it pulling data off a report based on what is defined in Field Mapping. I just see a field defined, and it follows through and somehow auto magically strips data off the report. I see nowhere to define where that data is on the report.

On the second question, the system log just shows a log on and log off by the user.

Thanks!

There are two problems that I am at a loss for finding a solution with CMOD. One is that a user is complaining that when they want to view a PDF with on demand, it is showing the wrong information for the third field. I see in the forum you referring to setting these type of things up, but do not see where that happens. If you could point me in the right direction or give me some basic help I would be grateful. See attachments.

Second, is there some type of log on the IBM i for on demand to show what is happening when a report fails? I have a report that does not get archived. It is not on ONDERR. I can see in my program that I am pushing the report to ONDEMAND out queue. I see data base files in QUSROND but not sure if any can be useful to me.

Thanks. Any help would be appreciated. We have users waiting for months on tickets, and I just got assigned to them with no training or experience with On Demand.