Kbase P118006: When do DataServers translate 4GL code into SQL?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/15/2006 |
|
Status: Unverified
GOAL:
When do DataServers translate 4GL code into SQL?
GOAL:
When do DataServers convert 4GL statements into their SQL equivalent?
GOAL:
Why is r-code not portable among database management systems?
FACT(s) (Environment):
DataServers
FIX:
Progress generates r-code when it compiles a 4GL procedure. This code is portable among machines and compatible among platforms. However, r-code is not portable among database management systems such as SQL Server and Oracle. During compile time Progress translates the static portions of 4GL database access statements into SQL statements that are specific to a database. At run-time the DataServer will issue the SQL statements and resolve the variable values associated with those statements.
Note, a connection to the foreign database is not required to compile code since the schema-holder contains all the necessary information needed by the compiler.