Geschrieben von Ivy am Mai 20, 2003 um 09:33:

Als Antwort auf Re: LOAD: Umlaut-Problem geschrieben von Gernot Ruban on Mai 19, 2003 um 20:26:

Hi Gernot,

LOAD-Statement (erstellt aus CC):

CONNECT TO FK1XATL1;
LOAD FROM "C:\comp.csv" OF DEL MODIFIED BY CHARDEL"" CODEPAGE=1252 COLDEL, DATEFORMAT="D-M-YYYY" DECPT. FASTPARSE METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) MESSAGES "C:\comp.txt" REPLACE INTO DB2ADMIN.FK1R_COMP (COMPANYID, REGISTEREDNAME, SHORTFORM, ADDRESS, INCLUSIONDATE, EXCLUSIONDATE, ACTUALSVALMAG, PLANNINGVALMAG, VOINGRIGHTPERC, PARA313RELEVANT, PARA313NOTE, PERIODID, COUNTRYID, COMPANYPURPOSEID, FIRSTCONSDATE, ISDELIVUNIT, LOCALACCTNGSTDID, CURRENCYID, RECLASSGROUPID, GROUPID) NONRECOVERABLE INDEXING MODE AUTOSELECT;
CONNECT RESET;

LOG (Auszug):

SQL3501W The table space(s) in which the table resides will not be placed in
backup pending state since forward recovery is disabled for the database.

SQL3109N The utility is beginning to load data from file "C:\comp.csv".

SQL3500W The utility is beginning the "LOAD" phase at time "19/05/2003
14.51.12.887378".

SQL3519W Begin Load Consistency Point. Input record count = "0".

SQL3520W Load Consistency Point was successful.

SQL3125W The character data in row "4" and column "2" was truncated because
the data is longer than the target database column.

usw, usw, es werden diese Zeilen aufgeführt, die ein Zeichen mit Umlaut beinhalten ! Es ist DB2 V8.1 PE auf WIN mit Zeichensatz UTF-8, Land DE !

Gruss & merci im voraus
Ivy

• Re: LOAD: Umlaut-Problem Gernot Ruban 21:13 20.5.2003 (3)
  • Re: LOAD: Umlaut-Problem Ivy 08:46 21.5.2003 (2)
    • Re: LOAD: Umlaut-Problem Sven 00:27 23.12.2003 (0)
    • Re: LOAD: Umlaut-Problem Gernot Ruban 11:26 22.5.2003 (0)

Schreibe eine Antwort