Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Invalid Syntax error in SybaseIQ when using a query using WITH AS statements
설명
When running a query that contains multiple "WITH AS" statements in Sybase IQ an Invalid Syntax on Line 1 error occurs in version 3.4. However the same query; connected to the same database executes without syntax errors in Toad Data Point 3.3.
원인
Toad Data Point 3.3 and below uses a SQL Server parser for all Sybase platforms. Starting in Toad Data Point 3.4, it's using specific parders for Sybase ASE only, which does not support this type of syntax to cause syntax errors.
해결 방안
WORKAROUND: Use Toad Data Point version 3.3 and install it side-by-side with version 3.4.
STATUS: Fix the in the latest version of Toad Data Point. Click here to download the latest release.
