|
Problem IC62264
|
Status: Closed |
CLP MIGHT RETURN SQL0104N BECUASE TERMINATE CHARACTER REMAINS AT THE END OF STATEMENT. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 command line processor (CLP) might return SQL0104N because
terminate character is not eliminated by CLP befor sending SQL
statement to server.
The following steps illustrates one of scenario causing this
problem:
.
1. Connect to a database
.
$ db2 connect to sample
.
2. Run a query with -t option:
.
$ db2 -tv " <hit enter key>
>values current user; <hit enter key>
>" <hit enter key>
.
values current user;
.
SQL0104N An unexpected token ";" was found following " values
current user".
Expected tokens may include: "END-OF-STATEMENT".
SQLSTATE=42601 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* CLP *
****************************************************************
* PROBLEM DESCRIPTION: *
* A CLP command spawned over multiple lines was reproting *
* error. *
****************************************************************
* RECOMMENDATION: *
* Same problem seen on all releases. Fixed to solve the issue *
**************************************************************** |
| Local Fix: |
Please remove new line character at the end of SQL statement. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 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 |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.07.2009
22.12.2009
22.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
