Examples

Start of change

The following ARSDOC examples include guidance on how to add a user ID to the stash file. For example, to add the user ID "sysadmin" to the stash file, enter the following command:

arsstash -a 1 -s stash_file -u sysadmin
where:
-a 1
Adds the user ID to the stash file.
-s stash_file
Name of the stash file.
-u sysadmin
User ID that is added to the stash file (if -u sysadmin is used on command line, then -p is not required since the password is obtained from the stash file).
  1. The following shows how to use the GET function to retrieve documents and save them in a file in the current directory. 
      arsdoc get -h ARCHIVE -u sysadmin -f "Student Information" -o student
  -c -S 1/1/97,12/31/97 -i "WHERE student='001200340056'" -v
    The ARSDOC program saves all of the documents that match the query in the following output file: student
  2. The following shows how to use the GET function and a parameter file to run more than one query at a time. The parameter file is in the current directory. The output files are saved in the current directory. 
      arsdoc get -h ARCHIVE -u sysadmin -F parmfile -v
    The parameter file contains two queries: 
    [-f "Student Information"] [-S 1/1/97,12/31/97] [-o (student)(type)] \
[-i "WHERE student='123420010056' AND type='B' OR type='G' OR type='T'"]

[-f "Student Information"] [-S 1/1/97,12/31/97] [-o (student)(type)] \
[-i "WHERE student='123450011917' AND type='B' OR type='G' OR type='T'"]
    Assuming that documents exist for all of the specified types, the ARSDOC program creates the following output files:
    • 123420010056.Bills
    • 123420010056.Grades
    • 123420010056.Transcripts
    • 123450011917.Bills
    • 123450011917.Grades
    • 123450011917.Transcripts
  3. The following shows how to use the GET function to retrieve documents, write the documents to a file, and generate and save generic index data for the documents that match the query. The example shows how to specify the name of a public named query that is valid for the specified folder. 
      arsdoc get -h ARCHIVE -u sysadmin -f "Student Information"
  -a -c -g -o student -q "3rd yr students GPA>3.5" -N -v
    The number of output files that the ARSDOC program generates is a factor of the number of application groups queried, the applications contained in the application groups, whether the data is AFP and if so, the versions of resource groups in each application. At a minimum, for AFP data with one version of the resource group and one application group, the ARSDOC program generates three output files. For example:
    • student.1.Student Information.TRANSCRIPTS.ind
    • student.1.Student Information.TRANSCRIPTS.out
    • student.1.Student Information.TRANSCRIPTS.res
    For AFP data, if there is more than one version of the resource group per application, then the ARSDOC program can generate additional output files. For example:
    • student.1.Student Information.TRANSCRIPTS.ind
    • student.1.Student Information.TRANSCRIPTS.out
    • student.1.Student Information.TRANSCRIPTS.res
    • student.2.Student Information.TRANSCRIPTS.out
    • student.2.Student Information.TRANSCRIPTS.ind
    • student.2.Student Information.TRANSCRIPTS.res
    If the application group contains more than one application, then the ARSDOC program can generate additional output files. For example:
    • student.1.Student Information.Bills.ind
    • student.1.Student Information.Bills.out
    • student.1.Student Information.Bills.res
    • student.2.Student Information.Grades.out
    • student.2.Student Information.Grades.ind
    • student.2.Student Information.Grades.res
  4. The following shows how to use the QUERY function to generate a list of items and save the list in a file in the current directory. 
      arsdoc query -h ARCHIVE -u sysadmin -f "Student Information" -o query1.out -H 
  -S 1/1/97,12/31/97 -i "WHERE student='0012-0034-0056' AND type='B' OR 
  type='G' OR type='T'" -v
  5. The following shows how to use the QUERY function and a parameter file to run more than on query at a time. The parameter file is in the current directory. The output files are saved in the current directory. 
      arsdoc query -h ARCHIVE -u sysadmin -F parmfile -v
    The parameter file contains three queries: 
      [-f "Student Information"] [-i "WHERE type='B'"] [-o query2.out] \
  [-S 1/1/97,12/31/97] [-H] [-N (student)(id)(p_date)]

  [-f "Student Information"] [-i "WHERE type='G'"] [-o query3.out] \
  [-S 1/1/97,12/31/97] [-H] [-N (student)(id)(p_date)]

  [-f "Student Information"] [-i "WHERE type='T'"] [-o query4.out] \
  [-S 1/1/97,12/31/97] [-H] [-N (student)(id)(p_date)]
  6. The following example shows how to use the QUERY function to search a specific application group: 
      arsdoc query -h ARCHIVE -u sysadmin -i "where Date_Taken BETWEEN 9863 AND 11531"
  -G load-scanned-images-jpeg -o jpeg -v
  7. The following example shows how to use the ADD function to add a document to the Credit Card Statements folder: 
      arsdoc add -h ARCHIVE -u sysadmin -o /newdata/crd.dat -n "crd_date=01/21/98" 
  -n "account='000-000-000'" -n balance=123.45 -n "name='John Watpole'" 
  -f "Credit Card Statements" -g CRD -a CRD -v
  8. The following example shows how to use the UPDATE function to update a document in the Credit Card Statements folder, changing the balance from 123.45 to 0.00: 
      arsdoc update -h ARCHIVE -u sysadmin -i "where account='000-000-000' and 
  name='John Watpole'" -n "balance=0.00" -S 1/1/97,12/31/97 -f 
  "Credit Card Statements" -g CRD -v
  9. The following example shows how to use the DELETE function to delete a document from the Credit Card Statements folder: 
      arsdoc delete -h ARCHIVE -u sysadmin -i "where account='000-000-000' and 
  name='John Watpole'" -f "Credit Card Statements" -S 1/1/97,12/31/97 
  -v
  10. The following example shows how to use the PRINT function to send the documents that match a query to a server printer: 
      arsdoc print -h ARCHIVE -u sysadmin -P 
svrprt1 -i "where account='000-000-000' and name='John Watpole'" 
-f "Credit Card Statements" -S 1/1/97,12/31/97 -v
  11. You can use the ARSDOC program to use the ADD function to add an index that points to an existing document. For example, assume that you loaded a bank statement for account number 000-000-000, date 5/23/97, and account name Joe Smith. You want to add a new index, but point to the existing statement. The new index uses the same account number and date, but contains a different account name (for example, Sally Smith). After adding the index, if a query is run with account name Joe Smith or Sally Smith, the same bank statement will be retrieved. To add an index for an existing document: 
      arsdoc add -h ARCHIVE -u sysadmin -i "where sdate=10005 and account='000-000-000' 
  and name='Joe Smith'" -n "sdate=5/23/97" -n "account=000-000-000" -n 
  "name='Sally Smith'" -f "Credit Card Statements" -S 1/1/97,6/31/97 -v
  12. The following example shows how to use the QUERY function to limit a search to the documents that were loaded into the system under a specific load ID. For example, assume that the specified folder could be used to search several application groups; each application group contains more than one application; there are 500,000 documents in the application groups. By using the -x parameter, the query will be limited to the set of documents that was loaded into the system under the specified load ID. Without the -x parameter, the query is run against all 500,000 documents. 
      arsdoc query -h ARCHIVE -u sysadmin -x 19867-025-0-3FAA-10136-10136
  -f load-scanned-images -q query -o out -v
  13. The following example shows how to use the QUERY function to limit a search to the documents that were loaded into the system under a specific load ID. In the example, the load ID, application group name, and query string are provided. The search is limited to the application group and only those documents that were loaded into the system under the specified load ID. 
      arsdoc query -h ARCHIVE -u sysadmin -x 19867-025-0-3FAA-10136-10136
  -i "where Date_Taken BETWEEN 9863 AND 11531" -G load-scanned-images-jpeg 
  -o jpeg -v
  14. The following example shows how to use the QUERY function to limit a search to the documents that were loaded into the system under a specific load ID. In the example, the load ID, folder name, application group name, and named query are provided. The search is limited to the application group and only those documents that were loaded into the system under the specified load ID. Because a folder was specified, a named query can be used. (If an application group name is specified and a folder name is not specified, a named query cannot be used, because a named query is associated with a folder.) 
      arsdoc query -h ARCHIVE -u sysadmin -x 19867-025-0-3FAA-10136-10136
  -f load_scanned-images -q query -G load-scanned-images-jpeg -o jpeg -v
  15. The following example shows how to use the GET function and an index file to retrieve documents from the system. The index file was generated for the set of documents that was loaded into the system under the specified load ID. When using the -X parameter, documents are retrieved based on the information in the index file. 
      arsdoc get -h ARCHIVE -u sysadmin -X 19867-025-0-3FAA-10136-10136
  -G load-scanned-images-jpeg -o jpeg -v
  16. -A parameter: The following are two examples of using the ARSDOC GET function with the -A parameter.
    • To retrieve public text annotations: 
      arsdoc get -u oduser -p passwd -h odserver -f "CRD" -q named_query
 -o loaddata -a -g -c -N -A 0 -v
    • An example of the messages that are generated by the ARSDOC program: 
      03/10/2004 10:32:12: Starting arsdoc. Version: 9.5.0.0

03/10/2004 10:32:14: arsdoc get -h ARCHIVE -u sysadmin -f CRD -q named_query -o loaddata -a -g -c -N -A 0 -v

03/10/2004 10:32:14: Attempting login for userid ’sysadmin’ on server ’ARCHIVE’ ...

03/10/2004 10:32:20: Login successful

03/10/2004 10:32:20: Searching for folder 'CRD' ...

03/10/2004 10:32:27: Search successful

03/10/2004 10:32:27: Searching for documents in 'CRD' ...

03/10/2004 10:32:28: Querying database with SQL string 'where account = '000-000-000''

03/10/2004 10:32:56: Search successful

03/10/2004 10:32:56: 1 document(s) have been queried. Retrieving 1 document(s).

03/10/2004 10:34:05: (1): Retrieving document for userid 'oduser' ...

03/10/2004 10:34:05: Document successfully retrieved and stored in file 'loaddata.2.CRD.CRD.out'

03/10/2004 10:34:15: Writing generic indexer file(s).

03/10/2004 10:34:46: '1' annotations were written to file 'loaddata.2.CRD.CRD.ann'

03/10/2004 10:34:46: A total of 1 annotations were written to file 'loaddata.2.CRD.CRD.ann'

03/10/2004 10:34:53: Generic indexer file 'loaddata.2.CRD.CRD.ind' has been successfully created.

03/10/2004 10:34:54: arsdoc completed.
  17. The following example is for the -B option. You want the command line to print all of the documents in the Credit Card Statements folder that have an account number of 000-000-000. The documents are to be printed in sorted ascending order based on the balance: 
    arsdoc print -h ARCHIVE -u sysadmin -i "where account = '000-000-000'"
 -f "Credit Card Statements" -P odprinter -B balance -v.
  18. -Q parameter: The following is an example of the messages that are generated by the ARSDOC program when multiple SQL queries are used.: 
    03/10/2004 10:32:12: Starting arsdoc. Version: 9.5.0.0

03/10/2004 10:32:14: arsdoc get -h ARCHIVE -u sysadmin -f CRD -Q SQL-filename -o loaddata -a -g -c -N -v

03/10/2004 10:32:14: Attempting login for userid ’sysadmin’ on server ’ARCHIVE’ ...

03/10/2004 10:32:20: Login successful

03/10/2004 10:32:20: Searching for folder 'CRD' ...

03/10/2004 10:32:27: Search successful

03/10/2004 10:32:27: Searching for documents in 'CRD' ...

03/10/2004 10:32:28: Querying database with SQL string 'where account = '000-000-000''

03/10/2004 10:32:28: 1 document(s) matches the search criteria.'
03/10/2004 10:32:29: Search successful

03/10/2004 10:32:29: Searching for documents in 'CRD' ...

03/10/2004 10:32:30: Querying database with SQL string 'where account = '000-000-001''

03/10/2004 10:32:32: 1 document(s) matches the search criteria.'

03/10/2004 10:32:33: Search successful

03/10/2004 10:32:33: Searching for documents in 'CRD' ...

03/10/2004 10:32:34: Querying database with SQL string 'where account = '000-000-002''

03/10/2004 10:32:38: 1 document(s) matches the search criteria.'

03/10/2004 10:32:38: Search successful

03/10/2004 10:32:56: 3 document(s) have been queried. Retrieving 3 document(s).

03/10/2004 10:33:05: (1): Retrieving document for userid 'oduser' ...

03/10/2004 10:33:05: Document successfully retrieved and stored in file 'loaddata.2.CRD.CRD.out'

03/10/2004 10:33:07: (2): Retrieving document for userid od'user' ...

03/10/2004 10:33:10: Document successfully retrieved and stored in file 'loaddata.2.CRD.CRD.out'

03/10/2004 10:33:12: (3): Retrieving document for userid 'oduser' ...

03/10/2004 10:33:15: Document successfully retrieved and stored in file 'loaddata.2.CRD.CRD.out'

03/10/2004 10:33:24: arsdoc completed.
  19. -U parameter: In this example, if a common user ID sysadmin is shared by three users: John Smith, Mark Jones, and Kathy Brown. A user alias is assigned to identify each of the actual users. In this example, the user alias is the real user name.
    arsdoc query -h ARCHIVE -u sysadmin -i query_string -f folder
-v -U "John Smith"
arsdoc query -h ARCHIVE -u sysadmin -i query_string -f folder
-v -U "Mark Jones"
arsdoc query -h ARCHIVE -u sysadmin 
-i query_string -f folder
-v -U "Kathy Brown"
    In the system log, the user ID column then contains:
    SYSADMIN-JOHN SMITH
SYSADMIN-MARK JONES
SYSADMIN-KATHY BROWN
  20. HOLD_ADD function: 
    arsdoc hold_add -h ARCHIVE -u sysadmin -l hold_audit -f 
"Monthly Status Reports" -i "where code='TX' and sdate=14117" -v
  21. HOLD_RELEASE function:
    arsdoc hold_release -h ARCHIVE -u sysadmin -l hold_audit -f 
"Monthly Status Reports" -i "where code='TX' and sdate=14117" -v
  22. CFSOD_FED function:
    arsdoc cfsod_fed -h ARCHIVE -u sysadmin -f 
"Monthly Status Reports" -i "where code='TX' and sdate=14117" -v
  23. FTI_ADD function:
    arsdoc fti_add -h ARCHIVE -u sysadmin -f 
"Monthly Status Reports" -i "where code='TX' and sdate=14117" -v
End of change