QUERY function

Use to generate a list of items that match a query. You must specify the name of the IBM® Content Manager OnDemand library server. You specify the application group or folder that you want to search. You can use the following parameters to query the database:
  • SQL query (-i)
  • hold name (-l)
  • public named query (-q)
  • text search string (-t or -T)
  • load ID (-x or -X)

If you use an SQL query, it must contain clauses, database field names, index values, and operators. The data that is retrieved from the server is sorted by using the Sort field from the Field Information page for the folder.

Read syntax diagramSkip visual syntax diagramarsdoc query-ddirectory-D-edelimiter-ffolder-GapplGroup-hinstance -H-isqlQuery-lholdname-qnamedQuery-tsearch_string-Tsearch_string-I-Lmax_docs-n-N"(dbfield)"-ooutputFile-Sstartdate,enddate,format-ppassword-uuserid-Uuser_alias-v-xloadId-XloadId-z-1trace_file-2level
When you use the parameter file option, the only parameters that can be specified on the command line are -F, -h, -u, -U, -v, -1, and -2. The -u, -p, and -z parameters can be specified in the parameter file instead. If specified, a logon will be performed for the retrieval request (if not already logged on). All other parameters must be specified in the parameter file. The following shows the syntax of the QUERY function when you use the parameter file option:
Read syntax diagramSkip visual syntax diagram arsdoc query -F parm_file -h instance -ppassword-uuserid-Uuser_alias -v -z -1trace_file-2level
The syntax of the parameter file for the QUERY function is:
Read syntax diagramSkip visual syntax diagram[-ddirectory][-D][-edelimiter] [ -f folder ] [-GapplGroup][-H][-isqlQuery][-lholdname][-qnamedQuery][-tsearch_string][-Tsearch_string][-I][-Lmax_docs][-n][-N(dbfield)][-ooutputFile][-Sstartdate,enddate,format][-xloadId][-XloadID]