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.

How to run ASE programs under ASA

6 posts in General Discussion Last posting was on 2002-08-29 14:04:17.0Z
Jonathan Posted on 2002-08-26 07:52:36.0Z
From: Jonathan
Date: Mon, 26 Aug 2002 03:52:36 -0400
Newsgroups: ianywhere.public.general
Subject: How to run ASE programs under ASA
Message-ID: <B8A5114247652CA7002B44C685256C21.002B44E085256C21@webforums>
Lines: 11
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:668
Article PK: 2672

Hi there,

My project is developed under ASE environment with multiple database schema
in the system.

Now, I'd like to run the system under ASA (SQL*Anywhere) environment which
does not support multiple database schema.

Any suggestion on this urgent situation? Thanks.

Jonathan


Stephen Rice Posted on 2002-08-26 14:07:55.0Z
Subject: Re: How to run ASE programs under ASA
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <B8A5114247652CA7002B44C685256C21.002B44E085256C21@webforums>
Organization: iAnywhere Solutions
Message-ID: <Xns927664D81A1CAsriceianywherecom@199.93.177.77>
User-Agent: Xnews/L5
Newsgroups: ianywhere.public.general
Date: Mon, 26 Aug 2002 10:07:55 -0400
Lines: 24
NNTP-Posting-Host: 172.31.141.72
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:665
Article PK: 3178

Jonathan wrote in
news:B8A5114247652CA7002B44C685256C21.002B44E085256C21@webforums:

> Hi there,
>
> My project is developed under ASE environment with multiple database
> schema in the system.
>
> Now, I'd like to run the system under ASA (SQL*Anywhere) environment
> which does not support multiple database schema.
>
> Any suggestion on this urgent situation? Thanks.
>
> Jonathan
>

In ASA you use one database file to correspond to each database in ASE
(ASA does not require a MASTER)

There is a whole section of the manual devoted to compatability with
ASE. Please refer to:
ASA SQL User's Guide
12. Transact-SQL Compatibility

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

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


Jonathan Posted on 2002-08-28 02:18:07.0Z
From: Jonathan
Date: Tue, 27 Aug 2002 22:18:07 -0400
Newsgroups: ianywhere.public.general
Subject: Re: How to run ASE programs under ASA
Message-ID: <300A51EAD7B7AF3A000CA50A85256C23.005096A685256C21@webforums>
References: <B8A5114247652CA7002B44C685256C21.002B44E085256C21@webforums> <Xns927664D81A1CAsriceianywherecom@199.93.177.77>
Lines: 13
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:659
Article PK: 2668

Steve,

Thanks.

But the problem is that, ASA does not support the standard SQL syntax like
FROM SCHEMA..TABLE, while ASE does. All of our programs are using FROM
SCHEMA..TABLE format.

Could you advice how to handle that?

Regards,

Jonathan


Stephen Rice Posted on 2002-08-28 12:50:11.0Z
Subject: Re: How to run ASE programs under ASA
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <B8A5114247652CA7002B44C685256C21.002B44E085256C21@webforums> <Xns927664D81A1CAsriceianywherecom@199.93.177.77> <300A51EAD7B7AF3A000CA50A85256C23.005096A685256C21@webforums>
Organization: iAnywhere Solutions
Message-ID: <Xns927857A7788FFsriceianywherecom@199.93.177.77>
User-Agent: Xnews/L5
Newsgroups: ianywhere.public.general
Date: Wed, 28 Aug 2002 08:50:11 -0400
Lines: 18
NNTP-Posting-Host: 172.31.141.72
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:657
Article PK: 2665

Jonathan wrote in
news:300A51EAD7B7AF3A000CA50A85256C23.005096A685256C21@webforums:

> Steve,
>
> Thanks.
>
> But the problem is that, ASA does not support the standard SQL syntax
> like FROM SCHEMA..TABLE, while ASE does. All of our programs are using
> FROM SCHEMA..TABLE format.
>
> Could you advice how to handle that?
>
> Regards,
>
> Jonathan

You are right, AFAIK there is no solution to that particular ASE
statement.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

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


Jonathan Posted on 2002-08-29 02:31:47.0Z
From: Jonathan
Date: Wed, 28 Aug 2002 22:31:47 -0400
Newsgroups: ianywhere.public.general
Subject: Re: How to run ASE programs under ASA
Message-ID: <07191AFBAA9D49E3000DE53B85256C24.0049B9B785256C23@webforums>
References: <B8A5114247652CA7002B44C685256C21.002B44E085256C21@webforums> <Xns927664D81A1CAsriceianywherecom@199.93.177.77> <300A51EAD7B7AF3A000CA50A85256C23.005096A685256C21@webforums> <Xns927857A7788FFsriceianywherecom@199.93.177.77>
Lines: 7
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:656
Article PK: 2669

So, Steve, the only solution is to create a single database, and remove all
of the SCHEMA.. in our programs. Right?

Any negative impacts to that solution? For example, I am worrying about
whether that solution is stable or not when the data volume grows to
certain level.

Jonathan


Jason Hinsperger Posted on 2002-08-29 14:04:17.0Z
From: "Jason Hinsperger" <jason_hinsperger@NOSPAMhotmail.com>
References: <B8A5114247652CA7002B44C685256C21.002B44E085256C21@webforums> <Xns927664D81A1CAsriceianywherecom@199.93.177.77> <300A51EAD7B7AF3A000CA50A85256C23.005096A685256C21@webforums> <Xns927857A7788FFsriceianywherecom@199.93.177.77> <07191AFBAA9D49E3000DE53B85256C24.0049B9B785256C23@webforums>
Subject: Re: How to run ASE programs under ASA
Date: Thu, 29 Aug 2002 10:04:17 -0400
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <GIBKQb2TCHA.276@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.141.17
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:655
Article PK: 2667

You can keep data in different databases if you want, but the method used to
access it is different. You would have to use proxy tables. See the
chapter on 'Remote Data Access' in the help file.

--
Jason Hinsperger
International and Sustaining Engineering
iAnywhere Solutions

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

<Jonathan> wrote in message
news:07191AFBAA9D49E3000DE53B85256C24.0049B9B785256C23@webforums...
> So, Steve, the only solution is to create a single database, and remove
all
> of the SCHEMA.. in our programs. Right?
>
> Any negative impacts to that solution? For example, I am worrying about
> whether that solution is stable or not when the data volume grows to
> certain level.
>
> Jonathan