SAP Knowledge Base Article - Preview

2845937 - DB6: SQL0010N during table activation in SE14

Symptom

Following errors can be found in the log:

sql:
CREATE TABLE "PATACP"
("ACP_PATCH" SAPDB6VARCHAR(000020)
DEFAULT ' ' NOT NULL,
"CHANGE_PATCH" SAPDB6VARCHAR(000020)
DEFAULT ' ' NOT NULL,
"CHANGE_ORIGIN" SAPDB6VARCHAR(000013)
DEFAULT ' ' NOT NULL,
"CHANGE_NUMBER" SAPDB6VARCHAR(000007)
DEFAULT ' ' NOT NULL,
"CHANGE_EXTENSION" SAPDB6VARCHAR(000003)
DEFAULT ' ' NOT NULL)
IN "PRD#DATA{20}"
INDEX IN "PRD#DATA{20}"
LONG IN "PRD#DATA{20} COMPRESS YES"
SQL0010N The string constant beginning with """ does not have an ending string delimiter. SQLSTATE=42603
DDL time(___1): .........2 milliseconds
The SQL statement was not executed
Statements for Table PATACP could not be executed
Request for PATACP could not be executed

The error can also occur on other tables.


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

 SQL0010N; ending string delimiter; storage parameter; COMPRESS YES , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

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

Search for additional results

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