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: arnaud.brion AT panalpina DOT com
************************************************************************
******

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Adrian Mazarache
Sent: Wednesday, 18 August, 2004 08:46
To: ADSM-L AT VM.MARIST DOT EDU
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.