Hi

I spot this blog today.. Status Help Automated - Using SQL column descriptions as status help

Nice!

Just contributing for DB2 flavor..

To retrieve the "column comment's from a db2 database.. a similar query that would get all columns for a single table at once (same way used by vincent) would be:

Code:
"SELECT COLNAME, REMARKS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = '" - sSchema - "' AND TABNAME = '" - sTabName - "'"
The column comments are in 'REMARKS' column.

And you can set a column comment executing the following SQL statement:


Code:
COMMENT ON COLUMN "APPCTRL"."WEBAPP_USER"."SUSERLOGIN" IS 'user e-mail';
@Vincent...
Feel free to update your blog.

Regards