Hi I created one SQL Collection. By default all tables created through SQL get journalled by the default journal created by system. My requirement is to rename the collection. Can someone help in this? Is there any work around? I tried creating new collection and doing CPYF. It copies all the files but does not journal the files? There are too many files and I do not want to journal them manually. I also tried SAVLIB and then re-storing it to new library. It retains journalling but in the old library. Thanks,
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
SQL Collection Rename
Collapse
X
-
SQL Collection Rename
The RNMOBJ command will let you specify the type as *LIB. I haven't used it, but it seems like that would keep all your journalling intact. But it course, it uses the system library name of 10 characters rather the the SQL collection name, so if the 2 are different, I don't what issues would be involved.
Comment