🚀 go-pugleaf

In  <1993Jul25.110748.1@woods.ulowell.edu>  adamsm@woods.ulowell.edu writes:

[stuff deleted]

| I like to do something like this:
|
| UPDATE table#1                  \\ I realize that this won't work but I can't
| SET last=table#2.last,          \\ find a valid statement to do this,
|     middle=table#2.middle,      \\ can anyone give me some idea that
|     last=table#2.last           \\ would accomplish this? The FROM clause
| WHERE table#1.id=table#2.id     \\ won't work with my version (VMS 1986)

Why not just do it in QUEL since QUEL supports correlated updates in the version
of the DBMS you are using. I.e.,

REPLACE table#1
(
last=table#2.last,
middle=table#2.middle,
last=table#2.last
)
WHERE table#1.id=table#2.id

If you need to include this as part of an application, just put it in an E/QUEL
subroutine which you precompile with EQC.  It will be callable from either ABF
or an ESQL program.  I'm not a big fan of QUEL, but prior to 6.4, it did have
its advantages....

--
David L. Tondreau, Jr. |   ars_mgr@nhqvax.hq.nasa.gov   | Don't "Just do it."
Managing Consultant    | dtondreau@aeromail.hq.nasa.gov | Do it right.
LCT, Inc.              |        (202) 554-0115          | The first time.