Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Status Help Automated - Vincent's Blog - Ammend for DB2 option

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    2,107

    Default Status Help Automated - Vincent's Blog - Ammend for DB2 option

    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
    Samuel Pizarro

  2. #2
    Join Date
    Feb 2009
    Location
    Queens, NY, NY
    Posts
    6,397

    Default 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?
    Click image for larger version. 

Name:	utility.jpg 
Views:	39 
Size:	121.3 KB 
ID:	13007
    Michael Mullan.
    Danes Bridge Enterprises.

    ++++++++++++++++++++++++++++
    There is just today. Tomorrow is a concept
    that is mostly theoretical. -- GM Wylie
    ++++++++++++++++++++++++++++

  3. #3

    Default Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option

    want!

  4. #4
    Join Date
    Feb 2009
    Location
    Queens, NY, NY
    Posts
    6,397

    Default Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option

    sent.
    Michael Mullan.
    Danes Bridge Enterprises.

    ++++++++++++++++++++++++++++
    There is just today. Tomorrow is a concept
    that is mostly theoretical. -- GM Wylie
    ++++++++++++++++++++++++++++

  5. #5
    Join Date
    Feb 2009
    Posts
    778

    Default Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option

    Post it on VDF-Guidance in source control....

    Peter
    Peter H. van Wijk
    X-Organize Consultancy N.V.

  6. #6
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    9,290

    Default Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option

    What Peter said!
    Garret

    Was just beaten up by six dwarfs- Not Happy!



  7. #7

    Default 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

  8. #8

    Default Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option

    FYI, Michael's contribution is now available via vdf-guidance:

    Table Document Editor Utility

    I played a bit with it today and can say that it is pretty nice.

    Thanks Michael!
    --
    Wil

  9. #9
    Join Date
    Feb 2009
    Location
    Queens, NY, NY
    Posts
    6,397

    Default Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option

    Thanks to Wil for the extra effort to get this up on vdf-GuiDance.

    MM
    Michael Mullan.
    Danes Bridge Enterprises.

    ++++++++++++++++++++++++++++
    There is just today. Tomorrow is a concept
    that is mostly theoretical. -- GM Wylie
    ++++++++++++++++++++++++++++

  10. #10
    Join Date
    Feb 2009
    Location
    Adelaide, South Australia, Down under
    Posts
    2,150

    Default Re: Status Help Automated - Vincent's Blog - Ammend for DB2 option

    Hi Michael
    I’m interested too!
    Marco Kuipers
    DataFlex Consultant
    28 IT Pty Ltd - DataFlex Specialist Consultancy
    Adelaide, South Australia
    www.28it.com.au

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •