Can some one advise if there is a know problem when using insert
into <tablename> external file <textfile.txt>
I am trying to use this functionality but does not seem to be
working very wheel.
Somehow the data gets offset by 2 characters after the 1st record is
inserted and remains offseted by 2 characters. I tried with various
data types and even with only one column defined as char but still
doesn't work. I also tried casting the field to the correct size
(i.e. the size set when creating the external table) when inserting
but still no luck.
I am trying all this from ISQL.

Can anyone advise please.

Regards
Brian