SQL portability

Writing portable SQL is mandatory if you want to succeed with different kind of database servers. This section gives you some hints to solve SQL incompatibility problems in your programs. Read this section carefully and review your program source code if needed. You should also read carefully the ODI adaptation 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.