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