DB2 FOR LUW / DB2FORLUW / 970 - 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:                                              * 
* CLPPlus users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB29.7 Fix Pack 8                                      * 
****************************************************************

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

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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 9.7 FP8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC91292 
follow-up : 

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

09.11.2012
15.04.2013
15.04.2013

9.7.FP8