Copying object sets
Use the following syntax to copy an object set:
CREATE OBJECTSET creator2.name2 LIKE creator1.name1
RETAIN AUTH yes|no
RETAIN OBJECTS yes|no
RETAIN AUTH yes|no
RETAIN OBJECTS yes|no
If you want to copy an existing object set but also include additional objects, you can use the LIKE parameter when creating a new object set with the INCLUDE TABLESPACE, INCLUDE TABLE, INCLUDE SQL, or INCLUDE INDEX options.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*