Skip to Content

CLR (Clear Column)

The CLR row command resets these columns:

  • Columns that were previously frozen with the FREEZE primary command or F row command
  • Columns that were previously hidden with the HIDE primary command or H row command.

This command is valid in the Column List window.

Use CLR’s block format or a range specifier to clear more than one column. Use the RESET primary command in the parent window to return all columns to their original order and status. See Controlling Window Columns for more information.

image2021-5-6_17-33-20.png

CLRR Block Format

Specifies the first and last row in a block of columns that you want to clear.

n

Specifies the number (n) of frozen or hidden columns to clear.

 

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

BMC AMI DevX File-AID for Db2 23.01