Consultor Eletrônico



Kbase P155993: Error 3237 and 3264 with nested FOR FIRST with ODBC DataServer when used JOIN-BY-SQLDB QUERY-TUNING
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   25/11/2009
Status: Unverified

SYMPTOM(s):

Error 3237 and 3264 with nested FOR FIRST with ODBC DataServer when used JOIN-BY-SQLDB QUERY-TUNING parameter

Program <program-name>, line <line-number> warning: Cannot join this query by the database server. (3237)

Program <program-name>, line <line-number>: PROGRESS will perform the join by the client. (3264)

FACT(s) (Environment):

ODBC DataServer is used against the DB2/400 database
Windows
OpenEdge 10.x
ODBC DataServer

CAUSE:

FIRST/LAST is designed to be always resolved on the client side

FIX:

This is an expected behavior