Hi,
Just wondering, is there a way to supply data to a couple of index field during the ARSLOAD command? Let's say I have 5 index field but only 3 index field has available data on the actual report data. So i need to supply the data for the remaining index field that doesn't have available data on the actual report data.
Could this be possible? Thanks,
In the application settings--load information.
Set a default value to each field
I appreaciate your respond Jeff but in my case, setting up a default value would not be applicable because i need to supply it with the information based on the job that produces the report data.
for an example: the missing index field on the actual report data are FREQUENCY and APPCODE.
The report filename is XXX.REPORT1.MONTLY or YYY.REPORT2.DAILY then I want to have XXX or YYY as the value for my index field called APPCODE
and DAILY or MONTHLY as the value for the field FREQUENCY
Hope you understand what i meant.
Thanks
Ive seen this done in the past but not the way you describe. I have seen reports come down such as:
JEFFREPORT.03242014123567890APPCODE1.PDF
and have a generic index created similar to:
Report Date : 03/24/2014
SSN : 123567890
Appcode : APPCODE1
I would imagine if you wanted to use the graphical indexer and pull part of the file name you would have to write some kind of postprocessor script. Personally I have never seen it done before but with the variety of languages we can all write in I am sure it is possible :)
If you're on CMOD 8.5 or higher, check out the -b and -B options for arsload.
If you're NOT on CMOD 8.5 or newer... Get familiar with writing code in Perl. :)
-JD.
Thanks a lot Jeff and Derrick.
We are using CMOD v.9 for Windows
Just out of curiousity, why not alter the reports to include the index values ?