I have used '-- ' to enter comments about tables or columns and am curious about the value of storing comments in tables using the COMMENT key word. When is the latter more appropriate than the former?
TIA,
Rich
-- is a comment which is like a language comment: it has _no_ effect on the program being compiled. Likewise --
is simply ignored. The value in a COMMENT is actually stored in the data base. For example:
tsh009=# comment on schema racf is 'Snapshot of z/OS RACF database via IRRDBU00 output';