Consultor Eletrônico



Kbase P110497: Is the MAX-ROWS option of the OPEN QUERY Statement implemented in the Oracle DataServer?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   11/4/2005
Status: Unverified

GOAL:

Is the MAX-ROWS option of the OPEN QUERY Statement implemented in the Oracle DataServer?

GOAL:

Does the MAX-ROWS option of the OPEN QUERY Statement work in an Oracle DataServer environment?

FACT(s) (Environment):

Oracle DataServer
Oracle

FIX:

No, the MAX-ROWS option is not implemented in the Oracle DataServer. When executed against an Oracle Database, the same SQL statement will be generated by the DataServer regardless of whether MAX-ROWS is set to 5 or 100, for instance.