Basic Questions on sybase 
Author Message
 Basic Questions on sybase

Dear ALL,

I do not know anything about Sybase and I have a couple very basic questions
on Sybase. The reason is that our product is running on Oracle only and we
are thinking of migrating to Sybase. Currently, we are just concentraing on
UNIX platforms.

Here are some of the questions that I have in mind:

1.  In Oracle, they have PL/SQL , a kind of 3GL procedural language which is
very efficeint and which could accomodate stored procedures, packages and
triggers  within the Database. What tools do Sybase offer?

2,   How does Sybase handle inter-process communication? In Oracle, we
      have 'pipes', in which one process could send messages down a pipe and
     another process listening down the pipe to take some action.

3.  In Oracle, they have CLOB, BLOB (Large Structures), which could handle
data item of  size up to 2 GB. Is there similar offering in Sybase? Are they
easy to manipulate?

4.  In Oracle, they have 'sequence', internally generated number which is
unique and  non-reusable. They are very efficient. DO we have similar thing
in Sybase?

5.  Can Sybase access system services through its own program interface?  In
Oracle, they  have so called external procedures which are essentially shared
libary written in C or  Java and which could access all kinds of services.

Thanks for any advice

Anthony

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 Basic Questions on sybase

Dear ALL,

I do not know anything about Sybase and I have a couple very basic questions
on Sybase. The reason is that our product is running on Oracle only and we
are thinking of migrating to Sybase. Currently, we are just concentraing on
UNIX platforms.

Here are some of the questions that I have in mind:

1.  In Oracle, they have PL/SQL , a kind of 3GL procedural language which is
very efficeint and which could accomodate stored procedures, packages and
triggers  within the Database. What tools do Sybase offer?

2,   How does Sybase handle inter-process communication? In Oracle, we
      have 'pipes', in which one process could send messages down a pipe and
     another process listening down the pipe to take some action.

3.  In Oracle, they have CLOB, BLOB (Large Structures), which could handle
data item of  size up to 2 GB. Is there similar offering in Sybase? Are they
easy to manipulate?

4.  In Oracle, they have 'sequence', internally generated number which is
unique and  non-reusable. They are very efficient. DO we have similar thing
in Sybase?

5.  Can Sybase access system services through its own program interface?  In
Oracle, they  have so called external procedures which are essentially shared
libary written in C or  Java and which could access all kinds of services.

Thanks for any advice

Anthony

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 Basic Questions on sybase

And your reason for posting this on comp.databases._informix_ was...?


Quote:

>I do not know anything about S-word and I have a couple very basic
>questions
>on S-word. The reason is that our product is running on Orabe only and we
>are thinking of migrating to S-word. Currently, we are just concentraing on
>UNIX platforms.

>Here are some of the questions that I have in mind:

>1.  In Orable, they have PL/SQL , a kind of 3GL procedural language which
>is
>very efficeint and which could accomodate stored procedures, packages and
>triggers  within the Database. What tools do S-word offer?

Informix offers SPL, and the ability to make your C or Java application
logic available as SQL built-ins. Way ahead of anyone else.

Quote:
>2,   How does S-word handle inter-process communication? In Orable, we
>       have 'pipes', in which one process could send messages down a pipe
>and
>      another process listening down the pipe to take some action.

You mean between client and server? Informix offers shared memory
communication, streams (pipes) or TCP.

Quote:
>3.  In Orable, they have CLOB, BLOB (Large Structures), which could handle
>data item of  size up to 2 GB. Is there similar offering in S-word? Are
>they
>easy to manipulate?

All present in Informix and very easy to manipulate. You can also create
your own datatypes and build them into the server. There are also
prepackaged server extensions for handling certain types of BLOB/CLOB, like
text, geospatial, images, etc, etc.

Quote:
>4.  In Orable, they have 'sequence', internally generated number which is
>unique and  non-reusable. They are very efficient. DO we have similar thing
>in S-word?

Informix has the SERIAL datatype, and if that doesn't float your boat, you
can extend the server with a function.

Quote:
>5.  Can S-word access system services through its own program interface?  
>In
>Orable, they  have so called external procedures which are essentially
>shared
>libary written in C or      Java and which could access all kinds of services.

Absolutely. Informix has the Virtual Table Interface, where you can take any
source of information (files, OS Services, HTML, other databases, whatever)
and treat them as part of your database.

_____________________________________________________________________________________
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com



Wed, 18 Jun 1902 08:00:00 GMT
 Basic Questions on sybase

Obviously should have started the posting with:
Dear All,
        I do not know anything about Deja.com.  I do not know anything about
Usenet.  I do not know anything about Informix.  I do not know anything....


: And your reason for posting this on comp.databases._informix_ was...?


:>
:>I do not know anything about S-word and I have a couple very basic
:>questions
:>on S-word. The reason is that our product is running on Orabe only and we
:>are thinking of migrating to S-word. Currently, we are just concentraing on
:>UNIX platforms.
:>
:>Here are some of the questions that I have in mind:
:>
:>1.  In Orable, they have PL/SQL , a kind of 3GL procedural language which
:>is
:>very efficeint and which could accomodate stored procedures, packages and
:>triggers  within the Database. What tools do S-word offer?

: Informix offers SPL, and the ability to make your C or Java application
: logic available as SQL built-ins. Way ahead of anyone else.

:>2,   How does S-word handle inter-process communication? In Orable, we
:>       have 'pipes', in which one process could send messages down a pipe
:>and
:>      another process listening down the pipe to take some action.

: You mean between client and server? Informix offers shared memory
: communication, streams (pipes) or TCP.

:>3.  In Orable, they have CLOB, BLOB (Large Structures), which could handle
:>data item of  size up to 2 GB. Is there similar offering in S-word? Are
:>they
:>easy to manipulate?

: All present in Informix and very easy to manipulate. You can also create
: your own datatypes and build them into the server. There are also
: prepackaged server extensions for handling certain types of BLOB/CLOB, like
: text, geospatial, images, etc, etc.

:>4.  In Orable, they have 'sequence', internally generated number which is
:>unique and  non-reusable. They are very efficient. DO we have similar thing
:>in S-word?

: Informix has the SERIAL datatype, and if that doesn't float your boat, you
: can extend the server with a function.

:>5.  Can S-word access system services through its own program interface?  
:>In
:>Orable, they  have so called external procedures which are essentially
:>shared
:>libary written in C or     Java and which could access all kinds of services.

: Absolutely. Informix has the Virtual Table Interface, where you can take any
: source of information (files, OS Services, HTML, other databases, whatever)
: and treat them as part of your database.

: _____________________________________________________________________________________
: Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com



Wed, 18 Jun 1902 08:00:00 GMT
 Basic Questions on sybase
Serendipity! That's right, Informix is the one.
Rudy
Quote:

> Dear ALL,

> I do not know anything about Sybase and I have a couple very basic questions
> on Sybase. The reason is that our product is running on Oracle only and we
> are thinking of migrating to Sybase. Currently, we are just concentraing on
> UNIX platforms.



Wed, 18 Jun 1902 08:00:00 GMT
 Basic Questions on sybase

Dear Me,

I do not know anything about posting to newsgroups and I have a couple very basic questions on posting to newsgroups. Can I send a message on any topic to any group and expect it to wind up going to the right place?

Maybe he's heard we're much more helpful than the Sybase folks (or Oracle since he mentions them). Or maybe he just enjoys getting witty responses to posts....


Quote:

>Dear ALL,

>I do not know anything about Sybase and I have a couple very basic questions
>on Sybase. The reason is that our product is running on Oracle only and we
>are thinking of migrating to Sybase. Currently, we are just concentraing on
>UNIX platforms.

==
"Outlook not so good."
That magic 8-ball knows everything!
I'll ask about Exchange Server next.

_____________________________________________________________
Want a new web-based email account ? ---> http://www.firstlinux.net



Wed, 18 Jun 1902 08:00:00 GMT
 Basic Questions on sybase

Quote:

> Dear Me,

> I do not know anything about posting to newsgroups and I have a couple very basic questions on posting to newsgroups. Can I send a message on any topic to any group and expect it to wind up going to the right place?

> Maybe he's heard we're much more helpful than the Sybase folks (or Oracle since he mentions them). Or maybe he just enjoys getting witty responses to posts....

Well I guess he'll just have to live in hope of that. :-)

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+

| http://www.informix.com  http://www.informixhandbook.com |/////  / //|
| http://www.iiug.org  +-----------------------------------+////  / ///|
|                      |This email will self-destruct in   |///  / ////|
|                      |10 sec. If you received this email |//  / /////|
|                      |in error, sorry about the mess.    |/  ////////|
+----------------------+-----------------------------------+-----------+



Wed, 18 Jun 1902 08:00:00 GMT
 Basic Questions on sybase


Quote:


>> Dear Me,

>> I do not know anything about posting to newsgroups and I have a couple very basic questions on posting to newsgroups. Can I send a message on any topic to any group and expect it to wind up going to the right place?

>> Maybe he's heard we're much more helpful than the Sybase folks (or Oracle since he mentions them). Or maybe he just enjoys getting witty responses to posts....

>Well I guess he'll just have to live in hope of that. :-)

Ouch! Well, maybe I was half-right.

==
"Outlook not so good."
That magic 8-ball knows everything!
I'll ask about Exchange Server next.

_____________________________________________________________
Want a new web-based email account ? ---> http://www.firstlinux.net



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. Basic question on Sybase Open Client onto server

2. basic questions on Sybase

3. Visual Basic & Sybase, Log File activity question

4. NC-WILMINGTON-113234--Visual Basic-RDBMS-ORACLE-SYBASE-MS ACCESS-MS SQL Server-VISUAL BASIC/RDBMS

5. NC-Winston Salem-245164--C-Visual Basic-ORACLE-SYBASE-DBMS-Programmer-C/Visual Basic/Oracle/Sybase

6. The Risks of Followup to Oracle Questions (Oracle vs Sybase Questions)

7. US-CA-LA SYBASE DATA WAREHOUSE VISUAL BASIC POWERBUILDER DATA MODELING ANALYSIS ESSBASE

8. Visual Basic / Powerbuilder / MS SQL Server / Sybase

9. MS-Access, Visual Basic, SQL Server, SyBase, C++, Java

10. Problems with Visual Basic 6, RDO and Sybase Adaptive Server

11. Visual Basic - ODBC - Sybase error handling

12. Visual Basic 4.0/Sybase


 
Powered by phpBB® Forum Software