Porting From Other RDBMS Packages

PostgreSQL 7.3.4 Documentation
PrevChapter 4. ECPG - Embedded SQL in CNext

4.10. Porting From Other RDBMS Packages

The design of ecpg follows the SQL standard. Porting from a standard RDBMS should not be a problem. Unfortunately there is no such thing as a standard RDBMS. Therefore ecpg tries to understand syntax extensions as long as they do not create conflicts with the standard.

The following list shows all the known incompatibilities. If you find one not listed please notify the developers. Note, however, that we list only incompatibilities from a preprocessor of another RDBMS to ecpg and not ecpg features that these RDBMS do not support.

Syntax of FETCH

The standard syntax for FETCH is: 

FETCH [direction] [amount] IN|FROM cursor

Oracle, however, does not use the keywords IN or FROM. This feature cannot be added since it would create parsing conflicts.

PrevHomeNext
Library FunctionsUpFor the Developer
Home
Online Resources
General
Beginner Tutorials
MySQL
PostgreSQL
Oracle
mSQL
Microsoft SQL
Contact Us
Random quote of the moment:
A rolling stone gathers momentum.
 
http://www.sql.org/
 
Proudly designed and hosted by OmegaSphere, providers of all your Web Hosting, SSL Certificate, and Domain Name needs!