What about "COPy CLOptset" command.

Zlatko Krastev
IT Consultant






"Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
11.10.2002 19:19
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        SQL - Copy client options with SQL?


Yes, I know it can be done, but I am not enough of a SQLer to do it.
But by example I am getting better :)

I want to make a copy of a complete set of client options, to a new name.
(I have a Windows set of options, now I want a Win2K set, to tweak them
a little differently).

0) First a relatively simple one, what SQL QUERY could I issue to list all
the options
and related fileds of each option, within a set for a particular "Client
Options" set?

1) How can I copy this (other than the obvious, re-manual entry :(
within SQL just to make a duplicate of the current client options?
(Some kind of select, on the client options, selecting each option,
then inserting each option and its fields under a new client option)

2) Could I send it all to a file I could edit, then use the edited file as
input
to build the new set of Client Options?

TIA ... Jack