suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT28459 Status: Geschlossen

SELECT FROM PIPE VIA EXTERNAL TABLES DOES NOT WORK ON WINDOWS CLIENT

Produkt:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problembeschreibung:
attempting to read data form named pipe on Windows will end up
with error

C:> db2 "INSERT INTO test_table  (uuid, id, text) SELECT
uuid,id,text FROM EXTERNAL '\.pipemyPipe'(uuid VARCHAR(10),
id INTEGER, text VARCHAR(50)) USING (DELIMITER ',' REMOTESOURCE
YES)"
DB21034E  The command was processed as an SQL statement because
it was not a
valid Command Line Processor command.  During SQL processing it
returned:
SQL20569N  The external table operation failed due to a problem
with the
corresponding data file or diagnostic files. File name:
"\.pipemyPipe".
Reason code: "0".  SQLSTATE=428IB
Problem-Zusammenfassung:
****************************************************************
* USERS AFFECTED:                                              *
* all windows Db2 Client                                       *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* DB2 Version 11.1 Fix Pack 5                                  *
****************************************************************
Local-Fix:
DB2 Version 11.1 Fix Pack 5
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.03.2019
02.03.2020
02.03.2020
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version