arsdoc get of .out, .ind, .ann, .ang with preview exit

[SueB]

I need to extract reports using arsdoc get.  I cannot determine how to extract the .out (without duplicate pages), .ind, .ann and .ang while using the preview exit. When we use the following the .ann and .ang are not extracted.

arsdoc get -h dbinst -g -a -A 7 -N -c -G APPLGRP -n -X LOADID -d PATH -o FILENAME
                               
If we use the command below, the .ann and .ang file is generated, but the .out file contains duplicate copies of report pages. It appears that a copy of the page is extracted for each row in db table (report has multiple indexes per page).             

arsdoc get -h dbinst -g -a -A 7 -N -c -f FOLDER -G APPLGRP -n -x LOADID -i "WHERE DOC_NAME like '1FAA%'" -d  PATH -o FILENAME

Any suggestions ?             

[Justin Derrick]

Hi Sue.

First thing -- your second command has -x (with loadID) AND an SQL Statement.  In the MP world, you only need one of these.

Second, I believe I've seen this behavior before in a server consolidation back in 2006...  When you load the extracted file, as long as the generic index entries are next to each other (ie, the generic index is sorted by object id, then byte offset), arsload should be smart enough to NOT store the duplicates.  Give it a try and see if this works in your environment.

-JD.