Status Help Automated - Vincent's Blog - Ammend for DB2 option
Hi
I spot this blog today.. [URL="https://www.dataaccess.com/blog/dataflex/status-help-automated-1513"]Status Help Automated - Using SQL column descriptions as status help[/URL]
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 - "'"[/CODE]
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';
[/CODE]
@Vincent...
Feel free to update your blog.
Regards
1 Attachment(s)
Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option
I also Liked Vincent's blog.
SO I wrote a small utility to display a tree-view of tables, and a grid of columns and descriptions. it loads the MS_Descriptions, and writes them back if you change them.
Anybody want?
[ATTACH=CONFIG]13007[/ATTACH]
Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option
Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option
Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option
Post it on VDF-Guidance in source control....
Peter
Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option
Hi Michael
I’m interested too!
Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option
Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option
That's exactly what happened ;)
So hold on, it will be available soon.
Probably later today.
--
Wil
Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option
Apparently Postgres has the same capabilities though I haven't had time to explore it as yet. See a reference [URL="https://stackoverflow.com/questions/35097578/how-to-add-extended-properties-in-postgresql"]here[/URL]
Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option
FYI, Michael's contribution is now available via vdf-guidance:
[URL="https://vdf-guidance.com/ContribPage.asp?Page=SOFTGENTABLEDOCE&ContribRecId=145"]Table Document Editor Utility
[/URL]
I played a bit with it today and can say that it is pretty nice.
Thanks Michael!
--
Wil