Editing Relational Tables › Edit the Structure of a New Table › Special Criteria for Column Descriptions

Special Criteria for Column Descriptions

For a column to be null, the first byte of that column must contain the word NULL. However, you receive error messages if NULL appears in the first column byte and you defined that column as NOT NULL. A column defined as NOT NULL can contain the word NULL only if the word begins after the first byte.

If you edit data in the DEFAULT column of a table, CA OPS/MVS reads that data exactly as you enter it. For example, if you are using the Table Structure Editor panel and you insert two blanks and a word into the DEFAULT column, the first two characters in the DEFAULT column remain blank.