DB2 - Problem description
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 | |
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 |