OnDemand Users Group

Support Forums => Tips and Tricks => Topic started by: Declan on January 21, 2013, 10:31:21 AM

Title: Using ARSDOC to pull multiple documents
Post by: Declan on January 21, 2013, 10:31:21 AM
I'm looking for some help on this one. I'm trying to pull documents from the database for a specific record identifier within a date range. I was using arsdoc get, but it just pulls back the oldest document, when there should be multiples. Do I need to use an arsdoc query instead? Any help greatly appreciated.
Title: Re: Using ARSDOC to pull multiple documents
Post by: Ed_Arnold on January 21, 2013, 03:16:09 PM
Not an expert, but perhaps something like this:

/usr/lpp/ars/V8R4M0/bin/arsdoc query -Ip -v -h ARCHIVE -G ggggg -o query.results.run.1 -i
            "WHERE REPORT_ID='xxxxxxxx' AND DATE BETWEEN low_number AND high_number
Title: Re: Using ARSDOC to pull multiple documents
Post by: pankaj.puranik on January 21, 2013, 04:07:23 PM
Try the arsdoc get -i or the -Q option.
Title: Re: Using ARSDOC to pull multiple documents
Post by: Declan on January 23, 2013, 03:30:08 PM
Thanks for the replies. I got to the bottom of it. I had cut and pasted an old arsdoc get command and it had the -L parameter set to 1. I upped it to 20 and it works fine now.