SQL portability

Writing portable SQL is mandatory, to support different kind of database servers.

This section provides hints to solve SQL incompatibility problems in your programs.

In addition to this SQL portability guide, read carefully the database-specific guides which contain database specific information about SQL compatibility issues.

To easily detect SQL statements with specific syntax, you can use the -W stdsql option of fglcomp:

$ fglcomp -W stdsql orders.4gl 
module.4gl:15: SQL Statement or language instruction with specific SQL syntax.

This compiler option can only detect non-portable SQL syntax in static SQL statements.