DB-Library, CT-Library or Embedded SQL 
Author Message
 DB-Library, CT-Library or Embedded SQL


>>        Here's a few advantages to go with E/SQL.
>>        E/SQL makes you _somewhat_ database independent.
>>        It'd be easier to switch to some other RDBMS.

>>        Second, with E/SQL, you're learning a generic language
>>        that makes one a little more marketable than becoming
>>        knowledgeable about some arcane jargon.

>>        Also, were Sybase to _change_ the ct lib, you'd have to
>>        convert your code.
>>        Whereas if it were in E/SQL Sybase would certainly release
>>        a new pre-compiler to take existing E/SQL and
>>        macro it into the right Sybase calls.

>>        I would not permit the software staff I work with
>>        to go ct at all ...

>> --

>>                                                AT&T, I no speak for them.

        Also, as you say, ESQL makes you only somewhat database independant.
        You still have to use sybase specifics such as CS datatypes.
        ESQL also does not execute a stored procedure by making an
        RPC call. It invokes it by a language call.
        Since ESQL code is converted to DBLIB/CTLIB code by the
        preprocessor, debugging it can be painful.
        ESQL also does not allow you to do certain things such as set
        configuration options.

        -Rajesh Gandhi
         Systems Architect
         Merrill {*filter*}

        My own opinions and mine only.

Wed, 16 Jul 1997 02:38:01 GMT
 [ 1 post ] 

 Relevant Pages 

1. DB-library/CT-library/Tools for Linux

2. DB-Library error 10040: DB-Library network communication layer not loaded

3. Strange behaviour of Ct-Library RPC calls through XA-Library

4. Embedded SQL or DB-Library

5. DB-library library

6. Latest Versions: Net-Library, DB-Library, ODBC Driver

7. EXPRESS OLE DB LIBRARY : Ideal data access library

8. Migrating DB-Library into Client-Library on UNIX

9. Migrating DB-Library into Client-Library in UNIX

10. Library similiar to DB-Library in public domain...

11. Migrating DB-Library into Client-Library on UNIX

12. Library similiar to DB-Library in public domain...

Powered by phpBB® Forum Software