my database has the codepage of 1252. I have done many LOAD FROM commands, like:
LOAD FROM ./myFile.csv of del
Untill now, it hasnt made any problem of loading the file into the database. As I tried to understand more about codepage on db2, it showed up that I havent understood:
if LOAD FROM command is running, does it do codepage conversion automatically?
What is the best practice of loading from a .csv file? Should this .csv file be coded as ascii or ansi?
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be