Using ARSDOC GET with an input file for multiple retrievals

Previous topic - Next topic

rstockton

Does anyone have a script or process to use ARSDOC GET with an input file to get mutiple retrievals using index values?  We ocassionally have request for large number of retrievals for particular documents and we are given a list with Index information.

Thanks,

Russell

LWagner

The joy of getting this to work was just not there, so I save you the grief.

command file sample:
arsdoc get -h <instance-name-ip-address>   -u uid -p passwd -F <parameter file> -v  2>>c:\HACLA\LOGS\LOG2.HACLA.PDFZos-611.txt
--------
parameter file sample:
[-f "zHACLApdf"] [-o "(INDEX_2)(INDEX_3)(POSTING_DATE)"] [-n] [-d D:\HACLA\PDFzOS] [-i "WHERE INDEX_2 = 'LAB' AND INDEX_3 = '11322G' AND POSTING_DATE > 13939"]
[-f "zHACLApdf"] [-o "(INDEX_2)(INDEX_3)(POSTING_DATE)"] [-n] [-d D:\HACLA\PDFzOS] [-i "WHERE INDEX_2 = 'RAB' AND INDEX_3 = '498012' AND POSTING_DATE > 13939"]
[-f "zHACLApdf"] [-o "(INDEX_2)(INDEX_3)(POSTING_DATE)"] [-n] [-d D:\HACLA\PDFzOS] [-i "WHERE INDEX_2 = 'GIR' AND INDEX_3 = '481845' AND POSTING_DATE > 13939"]

LWagner

A caution, if the column names are used in the output filename, as an example, a  60 character value with the last 50 as spaces, will have those 50 spaces in the filename for that column value. You will ant to have a method of stripping spaces from filenames.

If you can program the retrieval with API calls, do that so you have full control of your output filenames.

rstockton

Thanks.

What is  2>>c:\HACLA\LOGS\LOG2.HACLA.PDFZos-611.txt?.

Justin Derrick

Quote from: rstockton on July 16, 2014, 08:16:59 PM
Thanks.

What is  2>>c:\HACLA\LOGS\LOG2.HACLA.PDFZos-611.txt?.

Windows path.  :)  2>> is Windows-ese for redirecting error messages into the log file as well.
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

rstockton

Another question.  It appears that the output file name can be either user defined text or DB field names, is there anyway to combine the two? 

Example :  [-o "TestFile"]  or [-o "(INDEX-1)"] 

Thanks,

Russell

LWagner

My recollection is that you have to choose one or the other.

rstockton

That is what I have found with my testing, but was hoping there was a way around it.

Thanks

LWagner

If you use a program and the JAVA API calls, you of course have total freedom in final naming.