DELCOL primary command

In the row selection criteria panel of the File Manager template editor, the DELCOL command removes any column expression entered against one or all columns. Any affected column name and, when displayed, data type fields that are editable are changed to protected. You can also enter the DC prefix command against a column to achieve the same result.

Syntax


1 DELCOL
1! ALL
1 colref
1 columnname
colref
A reference to a single column, for example, #4.
columnname
The name of a column in the Db2® object or result table being processed.

DELCOL with no parameters deletes all column expressions and changes all column name fields and, when displayed, data type fields to protected.

DELCOL with either a column reference or a column name removes any column expression for the specified column and changes the specified column name field and, when displayed, data type fields to protected.

Availability

Related tasks