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.

what's means for "Positioned UPDATE and DELETE"

2 posts in General Discussion Last posting was on 2004-04-01 05:03:52.0Z
simple Posted on 2004-04-01 03:35:37.0Z
From: "simple" <zhaizy@e-future.com.cn>
Newsgroups: ianywhere.public.general
Subject: what's means for "Positioned UPDATE and DELETE"
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 211.102.28.41
X-Original-NNTP-Posting-Host: 211.102.28.41
Message-ID: <406b8e09@forums-1-dub>
Date: 31 Mar 2004 19:35:37 -0800
X-Trace: forums-1-dub 1080790537 211.102.28.41 (31 Mar 2004 19:35:37 -0800)
X-Original-Trace: 31 Mar 2004 19:35:37 -0800, 211.102.28.41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2910
Article PK: 6380

The following Adaptive Server Anywhere features are not supported on remote
data. Attempts to use these features will therefore run into problems:

a.. ALTER TABLE statement against remote tables

b.. Triggers defined on proxy tables will not fire

c.. SQL Remote

d.. Java data types

e.. Foreign keys that refer to remote tables are ignored

f.. The READTEXT, WRITETEXT, and TEXTPTR functions.

g.. Positioned UPDATE and DELETE

h.. UPDATE and DELETE requiring an intermediate temporary table.

i.. Backwards scrolling on cursors opened against remote data. Fetch
statements must be NEXT or RELATIVE 1.

j.. If a column on a remote table has a name that is a keyword on the
remote server, you cannot access data in that column. Adaptive Server
Anywhere cannot know all of the remote server reserved words. You can
execute a CREATE EXISTING TABLE statement, and import the definition but you
cannot select that column.


----------------------------------------------------------------------------
----


Stephen Rice Posted on 2004-04-01 05:03:52.0Z
Newsgroups: ianywhere.public.general
Subject: Re: what's means for "Positioned UPDATE and DELETE"
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <406b8e09@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns94BE20DD467sricenospamianywhere@192.138.151.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: toronto-hse-ppp3930283.sympatico.ca
X-Original-NNTP-Posting-Host: toronto-hse-ppp3930283.sympatico.ca
Date: 31 Mar 2004 21:03:52 -0800
X-Trace: forums-1-dub 1080795832 69.157.73.234 (31 Mar 2004 21:03:52 -0800)
X-Original-Trace: 31 Mar 2004 21:03:52 -0800, toronto-hse-ppp3930283.sympatico.ca
Lines: 23
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2911
Article PK: 6378

"simple" <zhaizy@e-future.com.cn> wrote in news:406b8e09@forums-1-dub:

<snip>

See

ASA Programming Guide
Using SQL in Applications
Working with cursors
Cursor positioning

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer