Re: SQL UPDATE with SELECT not working

["Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>]

Hi Peter,

Not sure what you're trying to do here, but maybe it should be something 
like this:

UPDATE PVIDAL/INSPEC
  SET INMJMN = '6'
WHERE EXISTS (SELECT * FROM AERODTATST/INSPEC, AMFLIBN/RTGOPR 
               WHERE INSPEC.INITEM = RTGOPR.RTID
                 AND INSPEC.INATRB Like '%ANODIZE%'
                 AND INSPEC.INMJMN<>6
                 AND RTGOPR.WKCTR='CA00')

Peter Dow
Dow Software Services, Inc.
909 793-9050


Peter Vidal wrote:
> Hi list:
>
> What is wrong here?
>
> UPDATE PVIDAL/INSPEC SET INMJMN = '6' WHERE SELECT INSPEC.INITEM, 
> INSPEC.INATRB, INSPEC.INOPNO, INSPEC.INSEQ, INSPEC.INSRT, 
> INSPEC.INMJMN, RTGOPR.WKCTR FROM AERODTATST/INSPEC, AMFLIBN/RTGOPR 
> WHERE INSPEC.INITEM = RTGOPR.RTID AND ((INSPEC.INATRB Like 
> '%ANODIZE%') AND (INSPEC.INMJMN<>6) AND (RTGOPR.WKCTR='CA00')) 
>
> The error message is:
> Token INSPEC was not valid. Valid tokens: < > = <> <= !< !> != >= ¬<
>
> The cursor is placed on INSPEC.INITEM, immediatelly after the SELECT 
> clause.
>
> TIA,
>
> Peter Vidal 
> PALL Corporation / SR Programmer Analyst, IT Development Group
> 10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
> http://www.pall.com
>
> "Good habits result from resisting temptation."
> Ancient Proverb
>
>   
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 269.5.1/764 - Release Date: 4/17/2007 4:43 AM
>