Supply data on multiple index fields during ARSLOAD

Previous topic - Next topic

kit

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,





jeffs42885

In the application settings--load information.

Set a default value to each field

kit

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

jeffs42885

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 :)

Justin Derrick

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.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

kit

Thanks a lot Jeff and Derrick.

We are using CMOD v.9 for Windows

LWagner

Just out of curiousity, why not alter the reports to include the index values ?