Author Topic: Supply data on multiple index fields during ARSLOAD  (Read 3173 times)

kit

  • Guest
Supply data on multiple index fields during ARSLOAD
« on: March 24, 2014, 05:06:58 AM »
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

  • Guest
Re: Supply data on multiple index fields during ARSLOAD
« Reply #1 on: March 24, 2014, 05:43:41 AM »
In the application settings--load information.

Set a default value to each field

kit

  • Guest
Re: Supply data on multiple index fields during ARSLOAD
« Reply #2 on: March 24, 2014, 10:12:01 AM »
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

  • Guest
Re: Supply data on multiple index fields during ARSLOAD
« Reply #3 on: March 24, 2014, 11:30:55 AM »
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

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2231
  • CMOD Guru for hire...
    • Tenacious Consulting
Re: Supply data on multiple index fields during ARSLOAD
« Reply #4 on: March 24, 2014, 05:41:29 PM »
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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

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

kit

  • Guest
Re: Supply data on multiple index fields during ARSLOAD
« Reply #5 on: March 26, 2014, 07:36:56 AM »
Thanks a lot Jeff and Derrick.

We are using CMOD v.9 for Windows

LWagner

  • Guest
Re: Supply data on multiple index fields during ARSLOAD
« Reply #6 on: March 26, 2014, 03:04:39 PM »
Just out of curiousity, why not alter the reports to include the index values ?