Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

update operation attempted on non-updatable remote query

2 posts in General Discussion Last posting was on 2004-05-17 16:00:46.0Z
Gordon Johnson Posted on 2004-05-12 18:09:59.0Z
Reply-To: "Gordon Johnson" <gjohnson@intellimed.com>
From: "Gordon Johnson" <gjohnson@intellimed.com>
Newsgroups: ianywhere.public.general
Subject: update operation attempted on non-updatable remote query
Lines: 25
Organization: Intellimed
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: mybox.intellimed.com
X-Original-NNTP-Posting-Host: mybox.intellimed.com
Message-ID: <40a26877$1@forums-1-dub>
Date: 12 May 2004 11:09:59 -0700
X-Trace: forums-1-dub 1084385399 208.178.77.100 (12 May 2004 11:09:59 -0700)
X-Original-Trace: 12 May 2004 11:09:59 -0700, mybox.intellimed.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3049
Article PK: 6512

Hi,

I have an ASA 9 database that I proxy the master reference tables.

I try this query and receive an error message.

UPDATE NV888 INNER JOIN drg2 ON NV888.drg_code_raw = drg2.drg_code SET
NV888.drg_code = drg2.drg_code
;

error - update operation attempted on non-updatable remote query

drg2 is the proxy table NV888 is the local table.

The NV888 has many drg records the drg2 table drg_code is the primary key.

Is there an ODBC settings I need to change.

The Server is ASA9 build 1271.

The user name I am using has DBA priveledges on both databases

Thanks.


David Fishburn Posted on 2004-05-17 16:00:46.0Z
Newsgroups: ianywhere.public.general
Subject: Re: update operation attempted on non-updatable remote query
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <40a26877$1@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns94EC7A27D350Ffishburnsybasecom@10.22.241.106>
User-Agent: Xnews/06.08.25
NNTP-Posting-Host: 10.25.100.243
X-Original-NNTP-Posting-Host: 10.25.100.243
Date: 17 May 2004 09:00:46 -0700
X-Trace: forums-1-dub 1084809646 10.25.100.243 (17 May 2004 09:00:46 -0700)
X-Original-Trace: 17 May 2004 09:00:46 -0700, 10.25.100.243
Lines: 30
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3052
Article PK: 6517

"Gordon Johnson" <gjohnson@intellimed.com> wrote in
news:40a26877$1@forums-1-dub:

I dont think you can do that.
I think you would have to either:
1) create a temporary table holding the ids of the remote table and
join to it.
or
2) Use a while loop.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList