|
midrange.com
I'm sorry that sounded rude, but I didn't mean it that way. Learn by
doing!
Anyway, look in your WHERE EXISTS statement... maybe you just copied it
that way, but the there needs to be a space before the FROM.
Michael Schutte
Work 614-492-7419
email michael_schutte@xxxxxxxxxxxx
Michael_Schutte@b
obevans.com
Sent by: To
midrange-l-bounce Midrange Systems Technical
s@xxxxxxxxxxxx Discussion
<midrange-l@xxxxxxxxxxxx>
cc
04/04/2006 12:11
PM Subject
RE: Another SQL question
Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>
Sounds like you need to put your thinking cap on and try to determine why
it's not working.
Michael Schutte
Work 614-492-7419
email michael_schutte@xxxxxxxxxxxx
"John Candidi"
<jacandidi@rutger
sinsurance.com> To
Sent by: "'Midrange Systems Technical
midrange-l-bounce Discussion'"
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc
04/04/2006 12:07 Subject
PM RE: Another SQL question
Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>
Elvis, this produces the following error.
UPDATE jacfiles.agcy_ext r1 SET r1.bus_name = (SELECT r2.acnm_name1 FROM
rugr80dat.pmspag00 r2 WHERE r1.mco = r2.agnm_mco and r1.agcy =
r2.agnm_agcy)
WHERE EXISTS (SELECT r2.acnm_name1FROM rugr80dat.pmspag00 r2 WHERE r1.mco =
r2.agnm_mco and r1.agcy = r2.agnm_agcy)
[SQL0104] Token . was not valid. Valid tokens: , FROM INTO. Cause . . . . .
: A syntax error was detected at token .. Token . is not a valid token.
A partial list of valid tokens is , FROM INTO. This list assumes that the
statement is correct up to the token. The error may be earlier in the
statement, but the syntax of the statement appears to be valid up to this
point. Recovery . . . : Do one or more of the following and try the
request again: -- Verify the SQL statement in the area of the token ..
Correct the statement. The error could be a missing comma or quotation
mark, it could be a misspelled word, or it could be related to the order of
clauses. -- If the error token is <END-OF-STATEMENT>, correct the SQL
statement because it does not end with a valid clause.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Tuesday, April 04, 2006 10:38 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Another SQL question
UPDATE jacfiles.agcy_ext r1
SET r1.bus_name = (SELECT r2.acnm_name1
FROM rugr80dat.pmspag00 r2
WHERE r1.mco = r2.agnm_mco and r1.agcy = r2.agnm_agcy)
WHERE EXISTS (SELECT r2.acnm_name1
FROM rugr80dat.pmspag00 r2
WHERE r1.mco = r2.agnm_mco and r1.agcy = r2.agnm_agcy)
First subselect sets the value and second ensures only matching rows are
updated.
Elvis
-----Original Message-----
Subject: FW: Another SQL question
I know the following sql syntax is not correct (I'm new at attempting SQL)
but this is what I want to do. I am attempting to pull the field acnm_name1
from rugr80dat/pmspag00 table and put it into the bus_name field in the
jacfiles.agcy_ext table. These 2 files are tied by agcy_mco=mco and
agnm_agcy = agcy. Any help (without laughing) would be appreciated.
UPDATE jacfiles.agcy_ext r1
SET bus_name = acnm_name1
WHERE EXISTS (SELECT 1 FROM rugr80dat.pmspag00 r2)
WHERE r1.mco = r2.agnm_mco and r1.agcy = r2.agnm_agcy
John A Candidi
Rutgers Insurance Companies
IT Director - AS/400 Manager
856-779-2274
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
