Re: Q: Portability of ESQL between Informix and Sybase

Derek M Jones <derek@knosof.co.uk> writes: >> Most vendors document (or can tell you) which features are >> non-standard. Sybase SQL in system-10 (Transact-SQL) is supposed to be >> complient with SQL-89, but I think there is a later spec (SQL-92?) that >> supports stored-procedures. >> > >There are several things you need to do. > >1) Avoid straight forward extensions. > >2) Avoid those constructs implemented differently than the description >given in the SQL/2 (ISO 9075:1992) standard > >3) Only use those constructs that are provided by other vendors and also >meet criterion (2) above for those vendors. > >If you are interested in having a tool help you with this process >I will be happy to tell you more about OSPC (Open Systems Portability >Checker), which has supported embedded SQL for over a year now. > Actually, if a product is FIPS compliant (FIPS 127-x) then it must provide a FIPS flagger. The FIPS flagger will flag any statements used in the program which do not adhere to the standard. Dave (ddargo@us.oracle.com)