Re: SQL select and update command

2001-10-03 Thread Daniel Sparrman
The update statement is not allowed using the TSM ODBC driver. What you can do is do a select, and then pipe the result to dsmadmc -id -pwd command --- Daniel Sparrman Exist i Stockholm AB Bergkällavägen 31D 192 79 SOLLENTUNA Växel: 08 - 754 98 00 Mobil: 070 - 399

SQL select and update command

2001-10-02 Thread Guan, Phillip
Hi all, Could someone give me an example how to do a select and then run command against the select reqult? For example, I want: Select volume_name from volumes where access!='READWRITE' then update volume the_result_from_select access=readwrite. Thanks. Best regards, Phillip Guan

AW: SQL select and update command

2001-10-02 Thread Baines, Paul
word= "checkout libv robot_3494 $i remove=no" done Mit freundlichen Grüßen - With best regards Serdeczne pozdrowienia - Slan agus beannacht Paul Baines TSM/ADSM Consultant -Ursprüngliche Nachricht- Von: Guan, Phillip [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 2. Oktob