I'm using informix 7, 10 and 11, when I create table can I assign
comments for table and it's columns? E.g. like this:

create table user (
id serial,
name char(20) comment "User's first name",
height integer comment "User's height in centimeters, maximal
overall length for amputees"
) comment "Table of users and their height"

I'm affraid there is no support for this in informix, right?

Correct. There is no support for commenting your DDL and storing the
comments. You could, of course, put such commentary in the DDL as
'comments' using any of the legal comment characters, but it won't be stored
anywhere for later display. I have created a Data Dictionary application
for doing this several times in the past with my own commentary tables, but
the comments and other meta-data would be separate from the DDL.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Wed, Nov 10, 2010 at 4:26 AM, dvh <dusan.halicky (AT) gmail (DOT) com> wrote:

Correct. There is no support for commenting your DDL and storing the
comments. You could, of course, put such commentary in the DDL as
'comments' using any of the legal comment characters, but it won't be stored
anywhere for later display. I have created a Data Dictionary application
for doing this several times in the past with my own commentary tables, but
the comments and other meta-data would be separate from the DDL.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Wed, Nov 10, 2010 at 4:26 AM, dvh <dusan.halicky (AT) gmail (DOT) com> wrote:

I suppose you could something clever with "upscol" column action
commenting but it would involve coding around it?
(Is "upscol" still around?)