February 07, 2008, 11:07 AM
Francis MarianiSQL Server, WebFOCUS and the USE command
This returns data:
SET SQLENGINE = SQLMSS
SQL
select * from EIDW_test.dbo.TestTable1
END
So does this:
SET SQLENGINE = SQLMSS
SQL
select * from EIDW.dbo.TestTable1
END
This returns no data:
SET SQLENGINE = SQLMSS
SQL
use EIDW_test
select * from TestTable1
END
Neither does this:
SET SQLENGINE = SQLMSS
SQL
use EIDW
select * from TestTable1
END
This works in SQL Query Analyzer:
use EIDW_test
select * from TestTable1
So does this:
use EIDW
select * from TestTable1
Why does the SQL USE command not function in WF SQL Pass-through?
Francis
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
February 07, 2008, 12:41 PM
hammo1jFran
The problem that you have with .sql scripts run under Query Analyser or the Oracle equivalent, SQL plus, is that these are interpreter programs and part of the script is command to the interpreter and not the SQL engine on the server.
Thus in
(1) use EIDW_test
(2) select * from TestTable1
(1) is an instruction to SQL Query Analyzer and thus not understood by the SQL engine.
February 07, 2008, 01:22 PM
Francis MarianiJohn,
Thanks for that explanation.
Cheers,
Francesco.
Francis
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