|
Problem IT36473
|
Status: Closed |
TRUNCATE TABLE WITHOUT IMMEDIATE ON CDE TABLES WITH DELIMITED IDENTIFIERS FAILS
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
When using TRUNCATE TABLE without specifying the IMMEDIATE
keyword and the table is column-organized and the table name
requires the use of delimited identifiers, Db2 returns a syntax
error.
db2 => create table t1."T-2" (c1 int) organize by column
DB20000I The SQL command completed successfully.
db2 => truncate table t1."T-2"
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "-" was found following
"210215095124178999_T".
Expected tokens may include: "WHERE". SQLSTATE=42601 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.6 *
**************************************************************** |
| Comment |
Upgrade to 11.5.6 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.04.2021
11.06.2021
11.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
