|
Problem IT28459
|
Status: Closed |
SELECT FROM PIPE VIA EXTERNAL TABLES DOES NOT WORK ON WINDOWS CLIENT
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.03.2019
02.03.2020
02.03.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
