Return
-
Title
Is there a way to toggle on and off the ANSI Join in the Query Builder for Toad for Sybase? -
Description
In Toad for Oracle there is a button that allows you to toggle between the types of JOIN that is generated from Query Builder so that you could generate the regular join or ANSII Join. Is there a way in Toad for Sybase to do the same thing? It is currently doing the ANSI Join by default. -
Cause
Currently the query builder builds ANSI SQL statements by default which is incorrect. Toad for Sybase should be using TSQL join syntax with the option to switch to ANSI SQL join syntax. This option is not currently enabled for Toad for Sybase. -
Resolution
WORKAROUND:
None.STATUS:
Waiting for fix in a future release of Toad for Sybase. -
Defect ID
ST105152