Error given when trying to access data from Toad details viewer, "Error ^ found "LIMIT" (at char 46) expecting a keyword". (4229212)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error given when trying to access data from Toad details viewer, "Error ^ found "LIMIT" (at char 46) expecting a keyword".
Description

When trying to access data via the Object Explorer's details viewer window, the following error is given:
"ERROR: 'SELECT * FROM <some table> LIMIT 1000 limit 1000' error ^ found "LIMIT" (at char 46) expecting a keyword"
Resolution

WORKAROUND:
Connect to Netezza using "Generic ODBC" as it betters handles pulling data for the details viewer window.
STATUS:
Waiting for fix in a future version of Toad Data Point.
Defect ID

QAT-5292
Additional Information

This should only be an error with Netezza connections, when viewing data tab in the details viewer window and in some case when running import. Running general queries in editor from tables and views not should be a problem.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title