DB2 FOR LUW / DB2FORLUW / A10 - DB2

CLPPlus may behave erratically when the substitution character 
"&" immediately follows a capital "O". Depending upon the usage 
it may report a syntax error, or generate incorrect output. For 
example: 
 
SQL> DEFINE SYS_DATE=20121012 
 
SQL> show escape 
escape OFF 
 
SQL> spool SERVICEINFO&&SYS_DATE..txt 
 
SQL> select 1 from dual; 
 
          1 
----------- 
          1 
 
SQL> spool off; 
 
SQL> host dir SERVICE* 
 Volume in drive D is Data 
 Volume Serial Number is 18D0-8D0B 
 
 Directory of D:\ 
 
10/30/2012  01:09 PM                51 SERVICEINF&20121012.txt 
 
 
Note the above filename. The commands should create 
'SERVICEINFO20121012.txt'

**************************************************************** 
* USERS AFFECTED:                                              * 
* All CLPPlus users                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 10.1 FP3                                           * 
****************************************************************

Modify your CLPPlus commands so that '&' does not immediately 
follow 'O'

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
 

Problem first fixed in DB2 10.1 FP3

Modify your CLPPlus commands so that '&' does not immediately 
follow 'O'

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

03.04.2013
01.10.2013
01.10.2013