WHERE

The WHERE clause enables you to specify an SQL-compatible WHERE logical condition.

Important

BMC AMI Unload does not support the VARBINARY and XML data types.


Related topics

Option descriptions—UNLD syntax

UNLD syntax diagrams 

When you use the PARTS option and a WHERE clause in the same UNLOAD statement, the selection of partitions is subject to partition analysis. The resulting unloaded data is the intersection of the results from the specified PARTS option and the results from the WHERE clause.

If the intersection results in no partitions being selected, BMC AMI Unload analyzes the MINROWS parameter specification. If the MINROWS criterion is satisfied, the unload continues. If the MINROWS criterion is not satisfied, BMC AMI Unload issues a warning and the unload job ends with an RC=4.


 

  • 13.1
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*