Re: Sybase versus Informix

Gary D. Hansen@ECCI 10/15/99 10:02 AM There seems to be some confusion here about Sybase ct-lib/db-lib vs Sybase ESQL. Sybase ct-lib (used to be db-lib which is an older version and is still supported) is a set of commands that can be put in a C program to write a client application using ct-lib commands which are Sybase proprietary. Sybase ct-lib is also installed on each client running Sybase apps as a method to connect from the client to the server. Sybase does not require a user to login to the physical server like Informix does. You login to the Sybase Server. ESQL on the other hand allows you to write SQL commands in a COBOL or C program the syntax being: exec sql (SQL Statement) end_exec. I believe there are only 4 Sybase TSQL commands that can't be executed using ESQL. Qintao Zhao <qzhao@usgs.gov> on 10/14/99 03:22:12 PM Please respond to Qintao Zhao <qzhao@usgs.gov> To: informix-list@iiug.org cc: (bcc: Gary D. Hansen/AMPAC/ECCI) Subject: Re: Sybase versus Informix Thanks, Nice to know. At Sybase website, I found Sybase esqlc document. It is about ctlib. The syntax of ctlib is totally different from Informix, Oracle and Ingres's esqlc which needs translations(esql, proc, esqlc) to run. Do you refer to Sybase's esqlc as ctlib or else. Can I get more information? Rumy Driver wrote: > Qintao Zhao, > > Sybase supports ESQL/C and ESQL/COBOL. > > Qintao Zhao wrote: > > > > I am a programmer. One thing I have noticed is that Sybase does not support > > ESQL/C (Informix, Oracle, and Ingres does). Sybase has it's own CTlib or others > > > > to program with C or C++. You can learn it in serveral hours. > > > > Qintao Zhao > > > > Robert Taylor wrote: > > > > > Ok - I know someone who is considering moving from an Informix job to a > > > Sybase job i.e changing employers. The level is 1 years experience as DBA. > > > > > > Whats the merits of Sybase over Informix and vice versa ? > > > Also how difficult is it to move from an Informix environment to a Sybase > > > one ? pitfalls etc > > > What IYHO opiion is the better Engine, has the best tools etc ? > > > > > > I have downloaded the Sybase-Faq and it seems to cover most topics in the > > > Job description he has. He has been told that Sybase is the closest rival to > > > Oracle, obviously Informix appears to be at the moment ( from where I am ) > > > dying slowly. > > > > > > Please note , I don't want this to turn into a slanging match etc and I'm > > > not lighting the fuse here, I just want a reasonable discussion and some > > > reasonable conclusions. Thanks in advance. > > > > > > Ding ding.....Round 1. > > > > > > "The only reason for tradition is tradition itself"