Re: Help!!! - - Informix problems - - p, p, p, p, p, p, p, p, PLEASE!! (A real puzzlething)

Nils Myklebust <Nils.Myklebust@idg.no> wrote in article <32f07a03.8279875@gate.idg.no>... > "Hans Nieuwenburg" <Hans.Nieuwenburg@cmg.nl> wrote: > > :Okay, here it comes (the puzzle of a lifetime) > : > : > :1) Sometimes it looks like Informix destroys some records and makes them > :unreadable, i can come up with a solution to repair these records but i > :need a structural solution! > : Why and how does informix destroy these records? > I haven't ever seen any Informix database do anything like this except > in a crash situation. > Exactly what is happening, and what is your solution to repair it? > And you didn't say anyting about the version of the database. It seems > to be ver 4.x or 5.x but exactly what is it. (OnLine or SE and version > number). > > :2) Every time when we are sending a string like "John" to the field <Name> > : (witch is 10 char's long) and we retreve the data like "John " to > : reduce extra work on the client software we would like to retrieve the > : data with no filling spaces, is there an option in Informix you can use to > : set these spaces off, Trim is not supported in my Informix version ?!?! > What is your client software? Is it ESQL/C? That can easily handle > this. You have Informix-NET for Windows. Is there perhaps some other > client software on the PC? > > :Some Data To Work With! > Not all that much. > > :OS - SCO_SV, Release 3.2v5.0.0 (+Adv. Hardware Suplem. v5.2) > : 30 user > Have you installed the needed patches: rs500d, net100, oss449a > Without these you shouldn't expect much to work well. > > :Hardware - Pentium 100 (2*), Eisa, 64mb ram, 8gb HD, 2 cpu's > : > :Informix - ESQL/C 5.06, I-SQL 4.14, Informix-NET for Windows 5.01.w > These versions seem to be old. Are you sure they are realy for SCO > 5.0.0. If they aren't spesific ports for this version of SCO I > wouldn't expect them to work very well. The changes from earlier > versions of the OS are significant. > > :I hope you can help me but.... > Not much, but possibly a start. > > > Nils.Myklebust@idg.no > NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway > My opinions are those of my company > The Informix FAQ is at http://www.iiug.org >