Re: LVARCHAR Data truncated in Informix - Very Urgent

On Wed, 29 Oct 2003 19:02:58 -0500, KalpanaPai wrote: Probably due to embedded newlines in the unload file. Art S. Kagel > Hi All, > > I have a major problem on Production box, recently we have changed the server, > and exported and imported the database to new server from old box. > > In one table there are 10 fields of datatype LVARCHAR, in export file (.unl) > the data is present , but when it is loaded to the table the data is > truncated, not all the rows , it has happened very randomly. > > To test this , i have created a separate table, and used LOAD from ... INSERT > INTO command > again the same problem ,it is loaded with trucated data. > > Is anybody has come across with the above problem? Is it bcoz of Datablades? > In the new box we do not have any datablades? Is LVARCHAR anything to do with > Datablades? > > Any help would be highly appreciated. As it is on the production i need to > find out the reason, bcoz we are exporting every night with DBEXPORT command. > > If we use dbimport , and if it truncates the data, Is export is relaible? > Early reply would be much helpful. > Thanks in Advance > Kalpana Pai