Hi,

is there a way to disable the new SQL/99 enforcement in ASA
9 ?
My customer has to migrate from ASA 8 to ASA 9 but the
application has issues with the behavior change in the area
:

'References to table expressions preceding in the FROM
clause may now be used in ON clauses of nested outer joins.
In previous releases, outer references in the ON phrase were
permitted. Such outer references must now be indicated by
use of the LATERAL keyword. The restriction enforces clarity
and conforms to the SQL/99 standard.
'

They have many queries to revisit.
Is there a way to revert temporarily to SQL/92 syntax in ASA
9 until queries can be fixed ?

Many thanks in advance.

Best regards.

J Vega

There is no method to disable this.
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** ***************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** ***************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

************************************************** ***************************

juanv (AT) sybase (DOT) com wrote:
Recognize that the reason for this standard is that previous queries are
often ambiguous. Without the LATERAL keyword, there is more than one
way to interpret the query.

Quite often when customers have hit this problem, they recognize that a
rewrite of the query eliminates the need for the LATERAL keyword and
cleans up their query in the process.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/