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
Description
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.
Cause
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.
Resolution
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.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
Toad Data Point
Toad for SAP Solutions
Topic(s):
Technical Solutions
Article History:
Created on: 2/3/2014 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
