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.

ASA to ASE Issue

9 posts in General Discussion Last posting was on 2005-09-23 02:14:47.0Z
Chris Ceniza Posted on 2005-09-21 07:02:53.0Z
Sender: 4e2b.43310341.1804289383@sybase.com
From: Chris Ceniza
Newsgroups: ianywhere.public.general
Subject: ASA to ASE Issue
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4331059d.4e48.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 Sep 2005 00:02:53 -0700
X-Trace: forums-1-dub 1127286173 10.22.241.41 (21 Sep 2005 00:02:53 -0700)
X-Original-Trace: 21 Sep 2005 00:02:53 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4787
Article PK: 8541

Guys!

I have sooo many row level triggers in my ASA(9.0.2)
Database and I have heard that row level triggers won't run
in ASE. Is this true? I am not familiar with ASE.

The problem is that we have an upcoming project that would
require us to migrate ASA structure to ASE. So, if i just
right-click then change to T-SQL my row level triggers and
apply it to ASE would this be effective?
And would it run as effectively as my triggers in ASA?


Chris Ceniza


David Fishburn Posted on 2005-09-21 13:13:26.0Z
Newsgroups: ianywhere.public.general
Subject: Re: ASA to ASE Issue
From: David Fishburn <fishburn_spam@off.ianywhere.com>
References: <4331059d.4e48.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns96D85DA06BCA5fishburnsybasecom@127.0.0.1>
User-Agent: Xnews/06.08.25 Hamster/2.0.6.0
NNTP-Posting-Host: vpn-concord-104.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-104.sybase.com
Date: 21 Sep 2005 06:13:26 -0700
X-Trace: forums-1-dub 1127308406 158.159.8.104 (21 Sep 2005 06:13:26 -0700)
X-Original-Trace: 21 Sep 2005 06:13:26 -0700, vpn-concord-104.sybase.com
Lines: 49
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4788
Article PK: 17424

Chris Ceniza wrote in news:4331059d.4e48.1681692777@sybase.com
of ianywhere.public.general:

CC> I have sooo many row level triggers in my ASA(9.0.2)
CC> Database and I have heard that row level triggers won't run
CC> in ASE. Is this true? I am not familiar with ASE.

Correct, ASE only has statement level triggers.

CC> The problem is that we have an upcoming project that would
CC> require us to migrate ASA structure to ASE. So, if i just
CC> right-click then change to T-SQL my row level triggers and
CC> apply it to ASE would this be effective?
CC> And would it run as effectively as my triggers in ASA?

You can do anything with statement level triggers that you can do with
row level triggers. You just write them with a different framework in
mind.

For example, an update statement changes 5 rows, fires 5 row level
triggers in ASA.

In ASE the trigger fires once, and you must loop through a local
temporary table and address each row.

You can experiment with Sybase Central and have it translate your row
level triggers to TSQL triggers (statement level) and test the results.
I think this might work for you.
--
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


"Rob Waywell" <rwaywell Posted on 2005-09-21 16:53:13.0Z
From: "Rob Waywell" <rwaywell@no_spam.ianywhere.com>
Newsgroups: ianywhere.public.general
References: <Xns96D85DA06BCA5fishburnsybasecom@127.0.0.1> <43317dc1.57d5.1681692777@sybase.com>
Subject: Re: ASA to ASE Issue
Lines: 83
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: rwaywell-xp.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp.sybase.com
Message-ID: <43318ff9$1@forums-1-dub>
Date: 21 Sep 2005 09:53:13 -0700
X-Trace: forums-1-dub 1127321593 10.25.98.159 (21 Sep 2005 09:53:13 -0700)
X-Original-Trace: 21 Sep 2005 09:53:13 -0700, rwaywell-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4791
Article PK: 17425

Any particular reason for migrating to ASE?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

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

<Chris Ceniza> wrote in message news:43317dc1.57d5.1681692777@sybase.com...
> I'll try that thanx
>
> Chris Ceniza
>
>> Chris Ceniza wrote in
>> news:4331059d.4e48.1681692777@sybase.com of
>> ianywhere.public.general:
>>
>> CC> I have sooo many row level triggers in my ASA(9.0.2)
>> CC> Database and I have heard that row level triggers
>> won't run CC> in ASE. Is this true? I am not familiar with
>> ASE.
>>
>> Correct, ASE only has statement level triggers.
>>
>> CC> The problem is that we have an upcoming project that
>> would CC> require us to migrate ASA structure to ASE. So,
>> if i just CC> right-click then change to T-SQL my row
>> level triggers and CC> apply it to ASE would this be
>> effective? CC> And would it run as effectively as my
>> triggers in ASA?
>>
>> You can do anything with statement level triggers that you
>> can do with row level triggers. You just write them with
>> a different framework in mind.
>>
>> For example, an update statement changes 5 rows, fires 5
>> row level triggers in ASA.
>>
>> In ASE the trigger fires once, and you must loop through a
>> local temporary table and address each row.
>>
>> You can experiment with Sybase Central and have it
>> translate your row level triggers to TSQL triggers
>> (statement level) and test the results. I think this might
>> work for you. --
>> 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
>>


Breck Carter [TeamSybase] Posted on 2005-09-22 14:34:02.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: ASA to ASE Issue
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <j2g5j1tutko1343hukev88fbe9ij0jp4q8@4ax.com>
References: <43318ff9$1@forums-1-dub> <43320cb6.608e.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 12.24.172.2
X-Original-Trace: 22 Sep 2005 07:32:50 -0700, 12.24.172.2
Lines: 185
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Sep 2005 07:32:51 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Sep 2005 07:34:02 -0700
X-Trace: forums-1-dub 1127399642 10.22.108.75 (22 Sep 2005 07:34:02 -0700)
X-Original-Trace: 22 Sep 2005 07:34:02 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4804
Article PK: 17426

>Guys, I have a question "Why would you choose ASA over ASE?"...

First of all, ASA is now being marketed as an enterprise database
solution, as well as a solution for mid-level and embedded
applications. There is no school system on the *planet* whose
enterprise database requirements could not be handled by an ASA 9
database running on the appropriate equipment. Millions of rows,
thousands of busy users, hundreds of gigabytes, no problem. For some
benchmark and market share reports, see
http://www.risingroad.com/benchmarks.html

So why pick ASA over ASE? Let me count the reasons...

- ASA has a more powerful procedural SQL language. That means when
appropriate, it is possible to push complex logic down into the
database in an efficient manner: efficient for the developer to write,
efficient for the engine to execute. ASA has scheduled and triggered
events, row-level triggers, local blob variables, global temporary
tables, persistent local temporary tables, user-defined
connection-level variables, user-defined SQL functions... the list
goes on and on.

- ASA has a more powerful SELECT statement, including local views via
the WITH clause, the LIST aggregate function with ORDER BY, the
recursive union for hierarchical queries, modern OLAP query operators,
ORDER BY clauses on derived tables... this list goes on and on as
well.

- ASA has tools that work: stored procedure and trigger debugger,
capturing of expensive queries, the index consultant, the graphical
plan display. Plus a low-impact remote performance monitoring and
diagnostic tracing tool coming in the next version.

- ASA has simpler administration. You won't get panic calls "The
transaction log is full!" Installation is easier, configuration is
easier, performance tuning is easier (and mostly unnecessary), backup
is easier, recovery is easier, migration from one platform to another
is easier (even to different-endian setups: install the software, copy
the database file, start the server).

- ASA has a lower price tag, not just for licencing but for all those
DBAs you do not need to hire. Everything comes "in the box"... no need
for third-party tool purchases, no need to buy another DBMS to do
OLAP, or another product to do replication.

- ASA has very bright future. The ASA engineers definitely "get it",
they understand what people need from a DBMS, what the default
settings and default behavior should be, why the ANSI standards are
important... they do things the way they should be done. ASA has
always had many important features before the other guy; examples
include declarative referential integrity, row-level locking,
scrollable cursors and the LEFT OUTER JOIN as an alternative to the
unpredictable *= operator.

Sign up for the Beta of the next version:
http://www.ianywhere.com/promos/sqlanybeta/index.html

It will have hot failover, materialized views, snapshot isolation...
once again, the list goes on and on and on...

Breck

On 21 Sep 2005 18:45:26 -0700, Chris Ceniza wrote:

>We have a school system that is written in ASE and an
>Inventory System written in ASA. One of our client purchased
>a school system which is now up and running. Even before
>they bought the school system they were considering our
>Inventory System for their canteen because they particularly
>liked the "integration" meaning if someone buys then
>automatically it records to the financial or if someone
>delivers stocks/goods then again it reflects automatically
>in the financials.
>
>And so the dilemma begins...
>
>If I were to choose, I would stick to ASA but then again
>"enee-minee-mynee-mow I have to get this show on the
>go!!!..."
>
>Yeah, I'll find a way...Any helpful tips from you guys will
>be greatly appreciated. Thanks.
>
>Guys, I have a question "Why would you choose ASA over
>ASE?"...
>
>
>Thanks Again,
>
>Chris Ceniza
>
>
>> Any particular reason for migrating to ASE?
>>
>> --
>> -----------------------------------------------
>> Robert Waywell
>> Sybase Adaptive Server Anywhere Developer - Version 8
>> Sybase Certified Professional
>>
>> Sybase's iAnywhere Solutions
>>
>> Please respond ONLY to newsgroup
>>
>> EBF's and Patches: http://downloads.sybase.com
>> choose SQL Anywhere Studio >> change 'time frame' to all
>>
>> To Submit Bug Reports:
>>
>http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>>
>> SQL Anywhere Studio Supported Platforms and Support Status
>> http://my.sybase.com/detail?id=1002288
>>
>> Whitepapers, TechDocs, and bug fixes are all available
>> through the iAnywhere Developer Community at
>> www.ianywhere.com/developer <Chris Ceniza> wrote in
>> > message news:43317dc1.57d5.1681692777@sybase.com... I'll
>> try that thanx >
>> > Chris Ceniza
>> >
>> >> Chris Ceniza wrote in
>> >> news:4331059d.4e48.1681692777@sybase.com of
>> >> ianywhere.public.general:
>> >>
>> >> CC> I have sooo many row level triggers in my
>> ASA(9.0.2) >> CC> Database and I have heard that row level
>> triggers >> won't run CC> in ASE. Is this true? I am not
>> familiar with >> ASE.
>> >>
>> >> Correct, ASE only has statement level triggers.
>> >>
>> >> CC> The problem is that we have an upcoming project
>> that >> would CC> require us to migrate ASA structure to
>> ASE. So, >> if i just CC> right-click then change to T-SQL
>> my row >> level triggers and CC> apply it to ASE would
>> this be >> effective? CC> And would it run as effectively
>> as my >> triggers in ASA?
>> >>
>> >> You can do anything with statement level triggers that
>> you >> can do with row level triggers. You just write
>> them with >> a different framework in mind.
>> >>
>> >> For example, an update statement changes 5 rows, fires
>> 5 >> row level triggers in ASA.
>> >>
>> >> In ASE the trigger fires once, and you must loop
>> through a >> local temporary table and address each row.
>> >>
>> >> You can experiment with Sybase Central and have it
>> >> translate your row level triggers to TSQL triggers
>> >> (statement level) and test the results. I think this
>> might >> work for you. --
>> >> 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
>> >>
>>
>>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com