Changes a database comment in the system database directory or the local database directory. New comment text can be substituted for text currently associated with a comment.
This API only affects the database partition server on which it is issued.
None
sqlenv.h
SQL_API_RC SQL_API_FN
sqledcgd (
_SQLOLDCHAR * pDbAlias,
_SQLOLDCHAR * pPath,
_SQLOLDCHAR * pComment,
struct sqlca * pSqlca);
SQL_API_RC SQL_API_FN
sqlgdcgd (
unsigned short CommentLen,
unsigned short PathLen,
unsigned short DbAliasLen,
struct sqlca * pSqlca,
_SQLOLDCHAR * pComment,
_SQLOLDCHAR * pPath,
_SQLOLDCHAR * pDbAlias);
The comment is only changed in the local database directory or the system database directory on the database partition server on which the API is executed. To change the database comment on all database partition servers, run the API on every database partition server.
New comment text replaces existing text. To append information, enter the old comment text, followed by the new text.
Only the comment for an entry associated with the database alias is modified. Other entries with the same database name, but with different aliases, are not affected.
If the path is specified, the database alias must be cataloged in the local database directory. If the path is not specified, the database alias must be cataloged in the system database directory.
CHANGE DATABASE database_alias COMMENT [ON path] WITH comment
To change the comment in the system database directory, it is necessary to specify the database alias.
If the path where the database resides is specified (with the path parameter), enter the name (not the alias) of the database. Use this method to change the comment in the local database directory.