+CONSISTENT


Use this parameter to define the value of the CONSISTENT keyword when you specify UNLOAD SHRLEVEL CHANGE. For more information, see CONSISTENT.     


consistent.png

Operands

YES

(Default) Sets CONSISTENT YES as the default value.

For more information, see CONSISTENT.

NO

Sets CONSISTENT NO as the default value.
For more information, see CONSISTENT.

Warning

Important

The CONSISTENT keyword specification on the UNLOAD command takes precedence over the default specified using the +CONSISTENT parameter.


Information
Example

If you specify +CONSISTENT (YES), the UNLOAD command is affected as follows:

       UNLOAD select * from sysibm.sysdummyE;
The UNLOAD command will be treated as if SHRLEVEL CHANGE CONSISTENT YES was coded 
Warning

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

 

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

BMC AMI Unload for Db2 13.1