|
|
|
[WHERE = <string>]
The <where> definition is required for the purge/archive directives file to work. It must either be in the purge/archive directives file or entered on the command line. If –where is used on the command line, its <string> value will replace the <string> value defined in the purge/archive directives file.
The <string> value is an SQL search clause that defines what objects of this object type to find. For this to work, all data must be in the format of the SQL search. Examples:
WHERE objid > 0
WHERE "title like '%failure%'"
Note: If the clause contains single quotes it must be entirely enclosed in double quotes.
Note: When dealing with Unicode string constants, you must precede all Unicode strings with a capital letter N. For example, "WHERE title = N'résumé'"
See Also |
Next |