PROTCOL primary command

In the row selection criteria panel of the File Manager template editor, the PROTCOL command changes the column name and, when displayed, the data type fields from editable to protected. Any column expression entered for a column is retained. You can also enter the PC prefix command against a column to achieve the same result. Use this command to protect a previously entered column expression from inadvertent changes.

Syntax


1 PROTCOL
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.

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

PROTCOL with either a column reference or column name changes the specified column name field and, when displayed, data type fields to protected.

Availability

Related tasks