|
Problem IC62264
|
Status: Geschlossen |
CLP MIGHT RETURN SQL0104N BECUASE TERMINATE CHARACTER REMAINS AT THE END OF STATEMENT. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 29.07.2009
22.12.2009
22.12.2009 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
