Table of Contents

Search

  1. Preface
  2. Introduction
  3. Servers
  4. Console Client
  5. Search Clients
  6. Table Loader
  7. Update Synchronizer
  8. Globalization
  9. Siebel Connector
  10. Web Services
  11. ASM Workbench
  12. System Backup and Restore
  13. Batch Utilities

Starting from the Command Line

Starting from the Command Line

You can start Relate from the Command line on Windows or UNIX.
Use the following syntax to run Relate on Windows:
%SSABIN%\relate Search Infile Outfile -rRulebase -pSystem -hHost:Port -wWorkDir [Optional Switches]
Use the following syntax to run Relate on UNIX:
$SSABIN/relate Search Infile Outfile -rRulebase -pSystem -hHost:Port -wWorkDir [Optional Switches]
Use the following options when you run Relate:
Search
Nominates the Search Definition to use.
Infile
The name of the file containing input records. When reading records from an SQL database, specify
lfile=xxx
where
xxx
is the name of the Logical-File-Definition that describes the SQL source. The same applies when reading records from an XML file. Specify
lfile=xxx
where
xxx
is the name of the Logical-File-Definition that describes the XML file.
Outfile
The name of the file that contains the matching records. These records are not written to the optional
-m0
and
-m1
files.
--append-to-output-file
Optional. Indicates to append the matching records to the output file. By default, the Relate process overwrites the output file.
-rRulebase
Required. The name of the Rulebase.
-pSystem
Required. The name of the System.
-hHost:Port
Required. The name of the host and the port number of the Search or Connection server.
-wWorkDir
Required. Work Directory.
-m0File
Optional. The name of the file to hold records that had no match.
-m1File
Optional. The name of the file to hold records that had one match.
-b
Optional. A binary input file containing records of fixed length. The record length must match IDT record length or Input View length.
-cOutputViewName
Optional. Nominates the name of the output view used to format the records returned by the search.
-dd<c>
Optional. Field delimiter character.
-df<c>
Optional. Field separator character.
-dr<c>
Optional. Record separator character.
-dl
Optional. Record layout.
-eEncoding
Optional. Nominates the UNICODE encoding used for W fields. The valid values are:
  • 6 = UTF-16 Little Endian
  • 7 = UTF-16 Big Endian
  • 8 = UTF-8
--failed-searches-log
Optional. Absolute path and file name for the log file to log details about the failed searches.
--failed-searches-count
Optional. Maximum number of allowed searches that can fail. Default is 0.
--skip-input-records
Optional. Number of input records that you want to skip. Default is 0.
--query_timeout
Optional. Set the timeout interval in seconds for a search request to query the database.
-Ffilter
Optional. Nominates a single dynamic SQL Filter. For individual searches within a Multi-Search, this switch does not support multiple filter values.
-iInputViewName
Optional. Nominates the view that describes the input records. The default is the IDT layout.
-jSearchWidth
Optional. Nominates a predefined search width that overrides the width in the Search Controls:
Narrow
,
Typical
,
Exhaustive
or
Extreme
. You cannot use this parameter with a Multi-Search.
-kMatchTolerance
Optional. Nominates a predefined match tolerance that overrides the tolerance specified in the Search Controls:
Conservative
,
Typical
or
Loose
. You cannot use this parameter with a Multi-Search.
-nx[:y[:z]]
Optional. Use
x
search threads with an input queue of
y
records and an output queue of
z
records for each thread.
--retry-options=<Number of Retries>,<Time Interval>,<Number of Retries for Intermittent Errors>
Optional. Sets the following values:
  • Maximum number of times you want to retry a search request before it fails. Default is 5.
  • Time interval in seconds for the first retry attempt. The time interval doubles with every retry attempt. Default is 5.
  • Maximum number of retries for any intermittent errors, such as socket error. Default is 5.
-s
Optional. Create a histogram of search transaction durations.
-ss
Optional. Provide individual timings for each search transaction.
-t
Optional. Append
newline
. The supported output formats are 0 and 3.
-tt
Optional. Append
newline
and trim trailing blanks. The supported output formats are 0 and 3.
-Tnum[,score]
Optional. Limit to num the number of records written from a result-set to the output file. Optionally, write more records than num if the records have a Score that is equal or greater than score.
-on
Optional. Specifies the report output format.
-ln
Optional. n = Lower score limit. Default is 0.
-un
Optional. n = Upper score limit. Default is 100.
-v
Optional. Verbosity level.
-Vpackage:parm
Optional. The VPD context-setting package and corresponding parameter.
-y
Optional. Print output view information at the start of the output file. Requires you to specify
-c
.
-x[{n|s}][rpt,recid]
Optional.
DupFinder
mode.
-X
XML output.

0 COMMENTS

We’d like to hear from you!