Translation Term (TR)

Use the translation term operator (TR) to expand a query to include all defined foreign language equivalent terms.

Syntax

Syntax	Description
TR(term[, lang, [thes]])	Expands term to include all the foreign equivalents that are defined for term.

term

Specify the operand for the translation term operator. term is expanded to include all the foreign language entries defined for term in thes.

lang

Optionally, specify which foreign language equivalents to return in the expansion. The language you specify must match the language as defined in thes. If you omit this parameter, the system expands to use all defined foreign language terms.

thes

Optionally, specify the name of the thesaurus used to return the expansions for the specified term. The thes argument has a default value of DEFAULT. As a result, a thesaurus named DEFAULT must exist in the thesaurus tables before you can use any of the thesaurus operators.

Examples

Consider a thesaurus MY_THES with the following entries for cat:

cat 
  SPANISH: gato 
  FRENCH:  chat 

To search for all documents that contain cat and the spanish translation of cat, issue the following query:

'tr(cat, spanish, my_thes)'

This query expands to:

'{cat}|{gato}|{chat}'

Related Topics

You can browse a thesaurus using procedures in the CTX_THES package.