Most wanted feature in ASE 12.5 beta 
Author Message
 Most wanted feature in ASE 12.5 beta

What is the most wanted feature in Sybase ASE 12.5 (Everest)?
Is it ready for enterprise-class applications needs?
Or it's just better price than Oracle!
How to compare with MS SQLServer 2000 beta?

Adaptive Server Enterprise 12.5

This exciting new release of ASE - the Portal-Ready Database - will focus
on e-commerce needs. In particular, most of the features fall into one of
the categories: Internet Security and Directory Services, Web Productivity
Enhancements and Enterprise-class E-commerce capabilities.

Internet Security and Directory Services

-Internet Directory Services - full integration with a Directory Server
supporting LDAP API.
-Internet Communication Security and User Authentication - Support for
PKI based infrastructure using Secure Socket Layer (SSL) protocol.

Web Productivity Enhancements

-Dynamic Web Content from XML Documents - Support for XQL queries on XML
documents that enables customized web content generation from same
storage.
-Java Stored Procedures - Compliance with SQLJ Part 1 standard to support
Java stored procedures that return result sets.
-Support for Enterprise Java Beans - Capability to run data-centric EJBs
within the ASE environment for greater security and better performance.
-Management of Non-relational Web Content - Use ASE to manage web content
stored in operating system supported files.
-Heterogeneous Distributed Transaction Support - 2PC support via
CIS/Enterprise Connect across heterogeneous databases.

Enterprise-class E-Commerce Capabilities

-Continuous Availability - Support of EMC Time Finder and Veritas Cluster
Software to utilize investments already made. Transportable databases to
migrate databases across servers without shutdown needed.
-Quality of Service - Continuous, automatic Internet workload monitoring
and resource adjustments.
-Support for UCS-2 encoding
-JIT Java Compilation - Significant speedups of Java-based queries
-Relaxed Server Limits - Greater page size, column size and other relaxed
limits to cater to enterprise-class application needs. Also, unlimited
number of users and logins.

Systems Management and Other Features

-Sybase's New Visual Diagnostic Tool - A brand new visually appealing and
color coordinated diagnostic tool that has drill-down capability.
-Union-in-views

Open Client 12.5

-New version of Open Client will support all new features of ASE 12.5. In
addition, performance improvements have also been made in some areas.

Supported Platforms and Operating Systems

-The Pre-Release program will only support the following platforms and
operating systems:

                  Solaris 32 bit Windows NT Linux      HP - 64 bit
Operating System: 2.8            NT 4.0     RedHat 6.2 11 Patch Bundle
990P

--
http://www.***.com/



Mon, 20 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta

Quote:

> What is the most wanted feature in Sybase ASE 12.5 (Everest)?

The ability to programmatically determine the time zone of the server.

Equivalently, a new datetime datatype based upon UDT,
independent of the server's time zone (Think unix time_t).

Currently, when we replicate data from London to San Francisco,
the datetimes of the replicated rows reflect the source system's time zone,
rather than the target system's.  Therefore, temp{*filter*}comparisons
cannot be made among data originating in different time zones,
unless the schema designers have hacked in a TZ-like column on all objects
with datetime values.

Hmmm, seeing the crosspost, how does MS handle this problem?

--wade

ps: Shell scripting of Sybase would be much easier if
isql had a "return" keyword, so isql could be used to
programmatically return a non-zero exit status.



Mon, 20 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta

Quote:

>> What is the most wanted feature in Sybase ASE 12.5 (Everest)?

> The ability to programmatically determine the time zone of the server.

> Equivalently, a new datetime datatype based upon UDT,
> independent of the server's time zone (Think unix time_t).

> Currently, when we replicate data from London to San Francisco,
> the datetimes of the replicated rows reflect the source system's time zone,
> rather than the target system's.  Therefore, temp{*filter*}comparisons
> cannot be made among data originating in different time zones,
> unless the schema designers have hacked in a TZ-like column on all objects
> with datetime values.

> Hmmm, seeing the crosspost, how does MS handle this problem?

SQL Server has always supported the GetDate function for returning the
current date and time in the internal datetime format. This has now been
extended with the GetUTCDate function, which returns the date and time in
UTC format (Universal Time Coordinate or Greenwich Mean Time). This value
is derived from the current local time and the time zone setting of the
operating system. The GetUTCDate function operates in exactly the same
manner as the GetDate function, and both are interchangeable:



This function can be quite helpful in multi-site applications. The current
GetDate function is often used in recording the time of insert and update
of row entries. In applications today, many of which use replication and
span multiple time zones, this value loses its meaning unless the time
zone in which the value was recorded is known. If you standardize on UTC
time, the new GetUTCDate function eliminates this problem.

http://www.***.com/

Quote:

> --wade

> ps: Shell scripting of Sybase would be much easier if
> isql had a "return" keyword, so isql could be used to
> programmatically return a non-zero exit status.

--
http://www.***.com/


Tue, 21 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta

Quote:



> >> What is the most wanted feature in Sybase ASE 12.5 (Everest)?

I want ASE 12.5 doesn't crash.
I think It will be better to stop developing any new features and make ASE more
reliable.

--
My best regards,
Vitaly Lipovetsky.
Deputy head of IT division
First Ukrainian Intl bank

Brainbench(Tekmetrix) e-certification id 14050 SYBASE DBA 4.38
Brainbench(Tekmetrix) e-certification id 14050 MS SQL Server DBA 4.51



Tue, 21 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta

Quote:

> I want ASE 12.5 doesn't crash.
> I think It will be better to stop developing any new features and make ASE
more
> reliable.

Perhaps, but some less fancy features would be nice, such as the ability to
do:

SELECT * FROM (SELECT.... )

I'd love to see that.....



Tue, 21 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta

Quote:




>> >> What is the most wanted feature in Sybase ASE 12.5 (Everest)?

> I want ASE 12.5 doesn't crash.
> I think It will be better to stop developing any new features and make ASE more
> reliable.

It seems that this is the only way to make ASE wouldn't crash.

--
http://www.asl.com.hk/employment.htm



Wed, 22 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta

Quote:


>> I want ASE 12.5 doesn't crash.
>> I think It will be better to stop developing any new features and make ASE
> more
>> reliable.

> Perhaps, but some less fancy features would be nice, such as the ability to
> do:

> SELECT * FROM (SELECT.... )

> I'd love to see that.....

This is one of the nice features in SQLAnywhere/MSSQL/Oracle.

--
http://www.asl.com.hk/employment.htm



Wed, 22 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta

Quote:

> > SELECT * FROM (SELECT.... )

> > I'd love to see that.....

> This is one of the nice features in SQLAnywhere/MSSQL/Oracle.

Yeah, it's one of the very few things I miss about MSSQL (along with a
decent GUI manager :-> )

Another couple of things I'd really like to see:

- The ability to pass TEXT and IMAGE types as SP arguments.  MSSQL can do
that too, and so should ASE.

- SQL3 data types, especially the Array type.

Frankly, I'd much rather see these relatively fundamental changes, rather
than some fancy, buzzword-compliant, LDAP addon.  I can do LDAP in my
application, I don't need ASE to do it for me.  ASE's a database, not an
application server.  I wish Sybase would concentrate on that, instead of
making it something it's not.

kenny



Thu, 23 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta

Quote:


>> > SELECT * FROM (SELECT.... )

>> > I'd love to see that.....

>> This is one of the nice features in SQLAnywhere/MSSQL/Oracle.

> Yeah, it's one of the very few things I miss about MSSQL (along with a
> decent GUI manager :-> )

> Another couple of things I'd really like to see:

> - The ability to pass TEXT and IMAGE types as SP arguments.  MSSQL can do
> that too, and so should ASE.

> - SQL3 data types, especially the Array type.

AS/IQ 12 Multiplex starts to support SQL3

Quote:

> Frankly, I'd much rather see these relatively fundamental changes, rather
> than some fancy, buzzword-compliant, LDAP addon.  I can do LDAP in my
> application, I don't need ASE to do it for me.  ASE's a database, not an
> application server.  I wish Sybase would concentrate on that, instead of
> making it something it's not.

Maybe Sybase is concentrating on Enterprise Portal

--
http://www.asl.com.hk/employment.htm



Thu, 23 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta
If you are looking for a good GUI, check DB Artisan by Embarcadero.  They
support sybase, ms, db2 and oracle.  The UI is great and really should be
licensed by all the RDBMS makers.

--
Robert Gelb


Quote:


> > > SELECT * FROM (SELECT.... )

> > > I'd love to see that.....

> > This is one of the nice features in SQLAnywhere/MSSQL/Oracle.

> Yeah, it's one of the very few things I miss about MSSQL (along with a
> decent GUI manager :-> )

> Another couple of things I'd really like to see:

> - The ability to pass TEXT and IMAGE types as SP arguments.  MSSQL can do
> that too, and so should ASE.

> - SQL3 data types, especially the Array type.

> Frankly, I'd much rather see these relatively fundamental changes, rather
> than some fancy, buzzword-compliant, LDAP addon.  I can do LDAP in my
> application, I don't need ASE to do it for me.  ASE's a database, not an
> application server.  I wish Sybase would concentrate on that, instead of
> making it something it's not.

> kenny



Fri, 24 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta
Is DB Artisan suitable for database developers?  I want a tool that can be
used to modify data easily.


Quote:
> If you are looking for a good GUI, check DB Artisan by Embarcadero.  They
> support sybase, ms, db2 and oracle.  The UI is great and really should be
> licensed by all the RDBMS makers.

> --
> Robert Gelb





>> > > SELECT * FROM (SELECT.... )

>> > > I'd love to see that.....

>> > This is one of the nice features in SQLAnywhere/MSSQL/Oracle.

>> Yeah, it's one of the very few things I miss about MSSQL (along with a
>> decent GUI manager :-> )

>> Another couple of things I'd really like to see:

>> - The ability to pass TEXT and IMAGE types as SP arguments.  MSSQL can do
>> that too, and so should ASE.

>> - SQL3 data types, especially the Array type.

>> Frankly, I'd much rather see these relatively fundamental changes, rather
>> than some fancy, buzzword-compliant, LDAP addon.  I can do LDAP in my
>> application, I don't need ASE to do it for me.  ASE's a database, not an
>> application server.  I wish Sybase would concentrate on that, instead of
>> making it something it's not.

>> kenny

--
http://www.asl.com.hk/employment.htm


Fri, 24 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta
Hi Norris,

Embarcadero has two other tools for developers
ER-studio and RapidSQL. We tried RapidSQL, it looks like DBArtisan
without some adminitrative functions but with tight integration with
MS SourceSafe.

        WBR,
            Oleg

Quote:

> Is DB Artisan suitable for database developers?  I want a tool that can be
> used to modify data easily.



Sat, 25 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta


Quote:
> Hi Norris,

> Embarcadero has two other tools for developers
> ER-studio and RapidSQL. We tried RapidSQL, it looks like DBArtisan
> without some adminitrative functions but with tight integration with
> MS SourceSafe.

>         WBR,
>             Oleg

> > Is DB Artisan suitable for database developers?  I want a tool that can be
> > used to modify data easily.

I'd like to have a transaction log journal as a sequence of separate files and
that SYBASE'd make them
without calling DUMP TRANSACTION command.
Such transaction log systems are implemented in DB2 and ORACLE.

--
My best regards,
Vitaly Lipovetsky.
Deputy head of IT division
First Ukrainian Intl bank

Brainbench(Tekmetrix) e-certification id 14050 SYBASE DBA 4.38
Brainbench(Tekmetrix) e-certification id 14050 MS SQL Server DBA 4.51



Sat, 25 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta

Quote:

> What is the most wanted feature in Sybase ASE 12.5 (Everest)?

What would help me the most is a longer varchar data
type.  Having to use text for anything longer than
255 bytes really hurts.

Larry Coon
University of California




Sun, 26 Jan 2003 03:00:00 GMT
 Most wanted feature in ASE 12.5 beta
You can create 7 columns of varchar(255) in ASE 12 instead of using text
column


Quote:

>> What is the most wanted feature in Sybase ASE 12.5 (Everest)?

> What would help me the most is a longer varchar data
> type.  Having to use text for anything longer than
> 255 bytes really hurts.

> Larry Coon
> University of California



--
http://www.asl.com.hk/employment.htm


Mon, 27 Jan 2003 03:00:00 GMT
 
 [ 15 post ] 

 Relevant Pages 

1. Most wanted feature in ASE 12.5 beta

2. ASE 12.5 Beta on RH linux, can not create server

3. ASE 12.5 beta limitations

4. ASE 12.5 early beta for linux?

5. 12.5 beta features

6. Sybase ASE 12.5 on Windows 2000

7. ASE 12.5 via ADO/ODBC - How to use named parameters in stored procedures

8. downward compatability of 12.5 backup server with 12.0 ASE

9. Sybase ASE 12.5 Security Hole

10. Esp - output parameters problem under ASE 12.5 - Followup

11. Help Installing ASE 12.5

12. SQL -help ASE 12.5


 
Powered by phpBB® Forum Software