Re: database independence

In article <CKMG9K.2JI@sybase.com> davec@ribo.sybase.com (David Clegg) writes: The suggestion that you layer your application to isolate the RDBMS access in separate modules is a very good one, but do not confuse that with the other issues. I would recommend that if you can implement your project using ANSI '92 Entry level ESQL, you should go ahead and do that. All ANSI certified ESQL precompilers have a mechanism known as FIPS-FLAGGING which you can use to identify any non-standard extensions you are using in your ESQL. If you can get a 'database independent' version of your application running in this way, you can worry about optimizing performance for specific databases later -- as the performance bottle-necks and market demand direct you. -- Dave Clegg -- davec@sybase.com I'm getting nervous. Sybase reps (ie anyone@sybase.com) seem very sealous about projecting ESQL. Will dblib last long? Shouldn't the server have the sql (in sp's)? rjs -- Rob Sargent s-mail: Dept. of Human Genetics e-mail: rob@fosters.med.utah.edu U. of Utah Medical School phone: (801) 585-3388 Eccles Genetics Bldg phax : -3833 Salt Lake City, Utah 84112