SYSPROC.ALTOBJ() does not copy DB2 comments over?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • aj
    #1

    SYSPROC.ALTOBJ() does not copy DB2 comments over?

    DB2 LUW 8.2 FP14 Red Hat AS 2.1

    Looks like SYSPROC.ALTOBJ( ) doesn't copy table and column comments over?

    Shouldn't it?

    Yes, I know. I can use ALTOBJ() to create a script, dump it to a text
    file, add the "COMMENT ON..." statements myself, then execute it.

    But doesn't copying the comments seem like something that should happen
    all the time anyways? Why would you want to lose comments?

    Bug?

    TIA

    aj
    Tags: None
    • Serge Rielau
      #2
      Re: SYSPROC.ALTOBJ( ) does not copy DB2 comments over?

      aj wrote:
      DB2 LUW 8.2 FP14 Red Hat AS 2.1
      >
      Looks like SYSPROC.ALTOBJ( ) doesn't copy table and column comments over?
      >
      Shouldn't it?
      >
      Yes, I know. I can use ALTOBJ() to create a script, dump it to a text
      file, add the "COMMENT ON..." statements myself, then execute it.
      >
      But doesn't copying the comments seem like something that should happen
      all the time anyways? Why would you want to lose comments?
      >
      Bug?
      Depends on your point of view. I would agree though.

      Cheers
      Serge
      --
      Serge Rielau
      DB2 Solutions Development
      IBM Toronto Lab

        Comment

        Previous template Next
        Working...