469,883 Members | 1,219 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,883 developers. It's quick & easy.

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

aj
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
Jan 23 '07 #1
1 1385
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
Jan 23 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Fred Pacquier | last post: by
1 post views Thread by Dany | last post: by
7 posts views Thread by Serge Rielau | last post: by
3 posts views Thread by chettiar | last post: by
reply views Thread by aj | last post: by
5 posts views Thread by Jonathan Kay | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.