Re: SQL UPDATE of SELECTed records

["Paul Morgan" <pmorgan@xxxxxxxxxxxxxx>]

Steve,

Your UPDATE statement is too complicated.  Asssuming the UPDATE is occuring
on the same file as your SELECT statement the statement should be:

UPDATE library/file
SET field = 'U'
WHERE conditions

You don't need the SELECT statement in your WHERE clause.  As it's already
been mentioned if this is in a RUNSQLSTM source then put a semi-colon at the
end of the statment.

Paul

-- 
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333

"Steve McKay" wrote

> Can this be done?  Current statement looks like this:
>
> UPDATE library/file
> SET field = 'U'
> WHERE
> (SELECT fields
> FROM library/file
> WHERE conditions)
>
> Obviously, I've left out actual library and field names plus the
conditions
> that I'm testing, but you get the idea.