Hi,

I'm trying to load data from flat file using load command.
When I load the data I'm experiencing some problme in
loading the data.

For eg., Jürg is stored as Jürg.

I'm using this load statement,


LOAD TABLE FX.test_obsolete
(
Codename_Code '|~|' NULL(BLANKS,'null'),
gid '\x0d\x0a' NULL(BLANKS,'null')
)
USING CLIENT FILE '\test_obsolete_20111206_122602.dat'
quotes off
strip rtrim
escapes off
FORMAT ASCII
MESSAGE LOG '\test_obsolete.log'
ROW LOG '\test_obsolete.rowlog'
SKIP 1;

Can you please hepl me how to fix this issue.

-Sab