The only thing I can suggest is, sometimes, it looks like the SQL is sent directly to the SQL engine (passthru), but instead, WebFOCUS is using the metadata. I would verify the SQL ENGINE connection and also turn SQL traces on - it might shine a light on what's going on. Why post some of your code, including the connection string?
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
October 08, 2010, 01:41 AM
If your connection string command is failing due to improper case, etc., is the query using a default connection and database instead?