Hi,
Are there any setting in the reporting server to enable or disable RDBMS managed joins? I ask this question as I have a few sql's which are good when run outside of FOCUS .But when the same query is executed thro a fex like

SQL
SELECT * FROM TABLE WHERE CONDITION
END

IT TAKES A VERY LONG TIME TO BRING THE RESULT. And sometiems there si a warning RDBMS managed joins have been disabled.

Could anyone throw more light on this?
Thanks
Kalyan.

The syntax you are using will translate the SQL to FOCUS. To pass SQL directly to the RDBMS, do this:

SQL sqlengine
SELECT * FROM ....
;
TABLE FILE SQLOUT
PRINT *
END

The sqlengine will depend on the RDBMS. Use whatever is in the master file. SQLORA for Oracle or SQLMSS for SQL Server for example.

As to why WebFOCUS sometimes doesn't optimize JOINs, that could be for many different reasons. Depends on your request. That becomes irrelevent if you pass the SQL directly and run the report off of SQLOUT.

Also, if you are using EDA:
SQL ENGINE EDA SET OPTIMIZATION FOCUS

should disable RDBMS-managed joins. Usually you want to enable them with
SQL ENGINE EDA SET OPTIMIZATION SQL, instead, though.