ILE COBOL Programmer's Guide

Adding, Modifying and Removing Constraints

Constraints can be added, modified, or removed using:

Through SQL, a constraint can be added to the column of a table using the CREATE TABLE statement. If the table already exists, then the ALTER TABLE statement can be used to add the constraint. The ALTER TABLE statement can also be used to DROP the constraint.

Using CL commands, the Add PF Constraint (ADDPFCST) command can be used to add or change a constraint, and the Remove PF Constraint (RMVPFCST) command can be used to remove a constraint.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]