SAP Knowledge Base Article - Preview

2490797 - Command line option of hdbsql fails with 'sql syntax error: incorrect syntax near..." when sql statement contain special characters

Symptom

  • You are using command line option of hdbsql to run statement
  • Execution fails with erros like 'sql syntax error: incorrect syntax near..." 
  • The same statement can run correctly in Hana Studio's SQL console
  • The SQL statement contains special characters such as ', ", /


Read more...

Environment

SAP HANA Database

Product

SAP HANA 1.0, platform edition

Keywords

single quotes, double quotes, quotation mark, slash, SQLSTATE, HY000 , KBA , HAN-DB-SCR , SAP HANA SQL Script , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.