Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LVARCHAR data Truncated in Informx -Very Urgent

Status
Not open for further replies.

kalpanapai

IS-IT--Management
Feb 10, 2003
9
0
0
NZ
Hi All,

I have a major problem on Production box, recently we have changed thes erver,
and exported and imported the database to new server from old box. Version is 9.21C on Solaris.

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top