|
Problem IC64182
|
Status: Closed |
ERROR SQL0104N IN CONTROL CENTER WHEN YOU DOUBLE-CLICK ON OR OPEN ANY TABLE OR VIEW THAT ALREADY APPEARS IN DOUBLE QUOTES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When you do the following sequence of actions:
1. Start Control Center.
2. Expand the Databases list and pick a database to connect to.
3. Expand the Tables folder or the Views folder.
4. Double click (or Open or Query) on any row in which the
table name or view name appears in double quotes.
then you get an error which includes this text:
SQL0104N An unexpected token """" was found following
An example of the full text of an error message you might get is
this:
com.ibm.db.DataException: A database manager exception
occurred. :
[IBM]{CLI Driver][DB2/AIX64] SQL0104N An unexpected token ""
was
found following "ELECT * FROM SYSCAT.". Expected tokens may
include:
"<space>". SQLSTATE=42601
Table names and view names that appear in double quotes in
Control Center include:
- those which are reserved words, such as
SYSCAT."REFERENCES" or SYSIBMADM."PRIVILEGES",
- those which include lower case letters. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Control Center with DB2 for Linux, UNIX and Windows *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* . *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 2 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC64415
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.10.2009
25.01.2011
25.01.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
