Consultor Eletrônico

Status: Unverified

GOAL:

Does Oracle dataserver convert Progress 4GL to Oracle SQL at runtime only?

GOAL:

Does Oracle dataserver convert Progress 4GL to Oralce SQL per sql statement parsed as opposed to per SQL executed?

FACT(s) (Environment):

Oracle DataServer

FIX:

Some of the conversion is done at compile time and some of it at run time. The where clause usually is done at compile time. The construction of the SQL statement is done at runtime for most cases. Once the sql gets generated, we check if we already have a cursor with that same sql and reuse it. In that case we don't parse the statement again, we simply execute it. But we generate the SQL for every new query at runtime so we can check if we have already a cursor for that query.