Troubleshooting
Problem
Running SQL you get error "-282 Found a quote for which there is no matching quote".
Symptom
You run an SQL statement but see this error:
-282 Found a quote for which there is no matching quote
Cause
The database server found a quote for which there is no matching quote. This error occurs when you miss a quote that should exist or if a starting quote is on a different line than an ending quote.
Resolving The Problem
This problem can be resolved in one of three ways, after a solution has been implemented rerun the SQL that caused the -282 error:
Missing quote:
- Put a quote in the SQL syntax where it belongs.
Quotes on different lines:
- Run EXECUTE PROCEDURE ifx_allow_newline ('t'). This stays in effect until the end of your session.
- Set the ALLOW_NEWLINE parameter to 1 in the ONCONFIG configuration file and restart the database server.
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0;11.1;11.5;11.7;12.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21173896