DB2 FOR LUW / DB2FORLUW / A10 - DB2

The following SQL statement will return an SQL0104N (syntax 
error): 
 
db2 "create or replace package test is pipe constant char(10) := 
'blah'; end" 
 
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 "pipe" was found following "create 
or replace package test is pipe constant char(10) := 'bla". 
Expected tokens may include:  "".  LINE NUMBER=1. 
SQLSTATE=42601 
 
 
The problem will only occur if the variable is named "pipe".

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1, Fix pack 3                      * 
****************************************************************

Use a different name for the variable or use delimited 
identifier "PIPE" as variable name .   Example: 
 
db2 "create or replace package test is pipe1 constant char(10) 
:= 'blah'; end" 
or 
 
db2 "create or replace package test is "PIPE" constant char(10) 
:= 'blah'; end"

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 10.1, Fix pack 3

see Local Fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.02.2013
17.10.2013
17.10.2013