Re: Basic Questions on sybase
And your reason for posting this on comp.databases._informix_ was...? From: akkha@my-deja.com > >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
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.... In <9017c6$eu0$1@news.xmission.com> article, Obnoxio The Clown mentioned that: : And your reason for posting this on comp.databases._informix_ was...? : From: akkha@my-deja.com :> :>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