Columns get invisible in IDS 7.30

Hello, import data with LOAD-Statement from a file e.g.: LOAD FROM '/data/adresses.txt' DELIMITER '|' INSERT INTO adresses;results that many columns are invisible e.g. with SELECT-Statement. What can i do ? very thanks Wulls

Wulls wrote: > import data with LOAD-Statement from a file e.g.: > LOAD FROM '/data/adresses.txt' DELIMITER '|' INSERT INTO adresses;> results that many columns are invisible e.g. with SELECT-Statement. > What can i do ? Fix the problems. You haven't given us enough information to begin to diagnose your trouble. Invisible columns probably mean that the values are nulls -- I'm guessing, but it might be what you mean. In which case, you need to look at the data file rather carefully. Or it could be that you have a character column as the last column in each row, and the data comes from DOS (Win95/98/ME/NT/2K) and the last character in the majority of these rows is therefore CR (carriage return) and this is confusing DB-Access. Or it could be something else. You don't give us any platform or version information either. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"