Hi, Gunnar, Yes, extend showddl will be a very good way to retrieve comments. QiFan is proposing to write a UDF, Oracle seems to provide a system table with comments, and user have to write a query to search in that system table. Showddl will be a nice way, so we can add that capability as well. I will update the jira and record this.
We can discuss more about the implementation and design in the JIRA. It is TRAFODION-1915. Thanks, Ming 发件人: Gunnar Tapper [mailto:[email protected]] 发送时间: 2016年4月1日 21:58 收件人: [email protected] 主题: Re: 答复: 答复: add a comment to a table Can you do the columns too while you're at it? Being able to embed documentation is already a good thing. For example, we could document the repository this way. Also, do you plan to extend showddl to show the comments? Or, some other means? Thanks, Gunnar On Fri, Apr 1, 2016 at 7:02 AM, Liu, Ming (Ming) <[email protected]<mailto:[email protected]>> wrote: Very good plan QiFan. Allow me file a JIRA then. Compatibility will be important. Thanks, Ming 发件人: Qifan Chen [mailto:[email protected]<mailto:[email protected]>] 发送时间: 2016年4月1日 18:31 收件人: [email protected]<mailto:[email protected]> 主题: Re: 答复: add a comment to a table The implementation probably will be involving the following: 1. add a new type for column TEXT_TYPE in meta-table TRAFODION."_MD_".TEXT, say COMMENT_TYPE; 2. allow COMMENT ON syntax in the parser; 3. convert the content of COMMENT ON stmt into insertion/update of a row(s) in the TEXT meta-data table for the SQL object in question; 4. write a UDF to show the comment easily for a SQL object, by hiding the join of the meta-data TEXT and OBJECTS table. The task may be a little bit involving :-). Thanks --Qifan On Fri, Apr 1, 2016 at 1:30 AM, Liu, Ming (Ming) <[email protected]<mailto:[email protected]>> wrote: Shall we file a JIRA to track this requirement? Thanks, Ming 发件人: Suresh Subbiah [mailto:[email protected]<mailto:[email protected]>] 发送时间: 2016年4月1日 11:54 收件人: [email protected]<mailto:[email protected]> 主题: Re: add a comment to a table Hi, I do not think Trafodion currently supports Oracle's COMMENT ON syntax https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4009.htm It will be a relatively simple feature to add but we do not have it today as far as I know. Thank you Suresh On Thu, Mar 31, 2016 at 9:56 PM, [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> wrote: Hi , all, I want to add a comment to a table,like the use of oracle" comment on table tablename is annotate", How to use jdbc way to implement it? ________________________________ [email protected]<mailto:[email protected]> -- Regards, --Qifan -- Thanks, Gunnar If you think you can you can, if you think you can't you're right.
