Oh thanks Arnaud! You have an answer for 100 points.
On Wed, 2004-08-18 at 10:13, PAC Brion Arnaud wrote: > Adrian, > > I believe the correct syntax for what you're trying to achieve would be > : > select 'update node ' || node_name || 'password' from nodes. > Off course you'll have to send the output of the select in a script or a > macro to achieve your goal ! > Hope this helped ... > Cheers > > Arnaud > > ************************************************************************ > ****** > Panalpina Management Ltd., Basle, Switzerland, CIT Department > Viadukstrasse 42, P.O. Box 4002 Basel/CH > Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 > Direct: +41 (61) 226 19 78 > e-mail: [EMAIL PROTECTED] > ************************************************************************ > ****** > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of > Adrian Mazarache > Sent: Wednesday, 18 August, 2004 08:46 > To: [EMAIL PROTECTED] > Subject: updating multiple nodes > > Hello list! > > Can anyone help with some tricky hints about updating multiple nodes? > > something like > > > update node (select node_name from nodes) password > > > Any help is appreciated.