ADSM-L

SQL - Copy client options with SQL?

2002-10-11 12:24:35
Subject: SQL - Copy client options with SQL?
From: "Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 11 Oct 2002 11:19:44 -0500
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

<Prev in Thread] Current Thread [Next in Thread>