SAP Knowledge Base Article - Preview

2350468 - CREATE TABLE containing square brackets fails with Syntax Error - SAP IQ

Symptom

Creating a table containing a column with a square bracket in the column name gives a syntax error.

CREATE TABLE test
(
test_col1 int,
"[test_col2]" int
)
Could not execute statement.
Syntax error near '[test_col2]' on line 4
SQLCODE=-131, ODBC 3 State="42000"
Line 1, column 1


Read more...

Environment

  • SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

identifier ;  , KBA , BC-SYB-IQ , Sybase IQ , 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.