Db2-Fast load stage

[nchincholikar]

Hi,
I'm trying to load Russian-Cyrillic data to Db2-UDB table using Db2 Fast/Bulk load; all the data is loaded except Cyrillic.

I tried same using Db2-UDB stage and I'm able to load Cyrillic data too. Does anybody know why this happening.

Thanks,
Narendra

[Klaus Schaefer]

Narendra,

I think you have to modify the generated load script, e.g.:

... MODIFIED BY codepage=819 ...

Look for the "MODIFIED BY" phrase and insert the "codepage=xxx" after this. I had to do it once for German Umlaute loading, and then it worked. So for the load stage, you should set "LOAD Immediate=NO", then modify the generated load script as shown above and then invoke the load script.

Hope this helps....

Klaus

[nchincholikar]

Thanks Klaus,
It's working ...!

I tried using "LOAD Immediate=YES" for this we need to set DB2 Bulk Load stage property for "FILE TYPE MODIFIER codepage=819"

Using this I can directly run the job without invoking the load script.

Thanks again for showing me correct path ...

Regards,
Narendra

[Klaus Schaefer]

Ah, that's fine!

> property for "FILE TYPE MODIFIER"

I have never recognized/tested that option in the stage...

Happy loading!

Klaus