DB2 - Problembeschreibung
| Problem IC78613 | Status: Geschlossen |
CREATE VIEW STATEMENT RUN FROM .NET Application LOSES NEW LINE CHARACTERS WHEN STORED IN SYSCAT.VIEWS | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
When running a statement such as the following from the DB2 .Net
provider:
CREATE VIEW A11
AS
select
1 a,
2 b,
3 c
from
sysibm.sysdummy1
It loses the new line characters when stored in SYSCAT.VIEWS:
select substr(text,1,100) from syscat.views where viewname
='A10'
----------------------------------------------------------------
-----------
CREATE VIEW A10 AS select 1 a, 2 b, 3 c
from sysibm.s
ysdummy1
1 record(s) selected. | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 6 * **************************************************************** | |
| Local-Fix: | |
| verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
| Lösung | |
First fixed in DB2 Version 9.7 Fix Pack 6 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84592 Nachfolger : | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.09.2011 11.07.2012 11.07.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.6 |
|