Re: Help!!! - - Informix problems - - p, p, p, p, p, p, p, p, PLEASE!! (A real puzzlething)
"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