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 |