开发者

Is it possible to force Business Objects 6.5 to create proper ANSI joins?

开发者 https://www.devze.com 2023-01-17 05:34 出处:网络
The SQL that Business Objects generates seems to be stuck in a bygone era for SQL joins -- it insists on using the old Sybase outer-join syntax (*=, e开发者_开发知识库tc.), which is illegal in SQL Ser

The SQL that Business Objects generates seems to be stuck in a bygone era for SQL joins -- it insists on using the old Sybase outer-join syntax (*=, e开发者_开发知识库tc.), which is illegal in SQL Server 2005 when running at level 90. Is there an option somewhere to make it use modern join syntax (i.e., joining using the JOIN keyword rather than using commas in the FROM statement)?


From memory, there's a universe parameter called ANSI92 that does exactly what you want.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号