DB2 - Problem description
| Problem IT07958 | Status: Closed |
LOAD FROM CURSOR USING REMOTE FETCH AND MODIFIED BY CODEPAGE DOES NOT RETURN ERROR | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
Load from remote cursor does not support modified by codpage.
However no error is returned.
Sample of the issue.
db2 LOAD FROM CUR13414 OF CURSOR MODIFIED BY codepage=1208
REPLACE INTO RMPP001.TEST_CUST NONRECOVERABLE
db2 LOAD FROM CUR13414 OF CURSOR MODIFIED BY codepage=819
REPLACE INTO RMPP001.TEST_CUST NONRECOVERABLE
It did not work , still put the same data .
12186836 575256008 MU¹OZ ROJAS CUE
Customer exported the data , scp it over to Linux and run the
import or load with code page 1208 it works
db2 "load from ./AIX1.del of del modified by codepage=1208
insert into rmpp001.test_cust"
db2 "import from ./AIX1.del of del insert into
rmpp001.test_cust"
12186836 575256008 MU¹OZ ROJAS | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to the latest release. * **************************************************************** | |
| Local Fix: | |
Perform a export and import of the data. | |
| Solution | |
First fixed in V10.5 fix pack 7. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.03.2015 25.01.2016 25.01.2016 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.7 |
|