You can use the COMMENT ON statement to provide descriptive information for a table, view or column. You can place the statement after the CREATE statement on the same Source Panel or in its own Source Panel. CA Datacom Datadictionary places the comment for the object in a text classification named COMMENT. When you add a comment to an object that already has a comment, the new comment replaces the old comment.
You cannot retrieve a comment through SQL. You can display the text created with the COMMENT ON statement through the CA Datacom Datadictionary online or batch facilities. You can also add additional classifications of text to the occurrence using the CA Datacom Datadictionary functions. See the CA Datacom Datadictionary User Guide for more information on text classifications.
Enter the COMMENT ON statement in the numbered area of an EDIT Source Member Panel. See How to Submit SQL Statements for the steps to obtain the panel and an explanation of the fields on the panel. See COMMENT ON for the syntax of the statement.
|
Copyright © 2014 CA.
All rights reserved.
|
|