I use SCO OpenServer 5.x and Informix 7.x My USEOSTIME is set to 1 (Seems if this only enable the fraction part) The date_stamp is declared as...

David Reed

09-20-2006 10:06 PM
Jonathan Leffler

Does anyone know where can i found an Informix SE engine for SUSE Linux?. I have tried at the IBM website but it seems to be a very hard...

Luis Carlos Díaz Otero

09-20-2006 05:06 PM
Luis Carlos Díaz Otero

I use SCO OpenServer 5.x and Informix 7.x My USEOSTIME is set to 1 (Seems if this only enable the fraction part) The date_stamp is declared as...

David Reed

09-20-2006 08:21 AM
David Reed

Christine Normile said: "Insight that can't be measured" is probably more accurate. :o) -- Bye now, Obnoxio "... no bill is required as no value...

calyanram@hotmail.com

09-20-2006 02:16 AM
calyanram@hotmail.com

Hi Gang, During a migration from 7.31.UD8 to 10.00.UC4 I ran into the following error during the conversion : Con/rev: Failed to convert for...

jpierrot@chubb.com

09-19-2006 03:39 PM
Eric Rowell

and why raid5 is a bad idea http://www.epidauros.be/raid.jpg -- Clive Eisen CTO Hildebrand Group +44 (0)7957 626 324

Clive Eisen

09-19-2006 12:42 PM
Claus Samuelsen

Folks-- Not sure what/why exactly I am seeing a very high value under 'prioriy downgrades".. Anybody has seen this or facing this one. Any help is...

Danny

09-19-2006 11:52 AM
Danny

Hi I have a problem in informix environmental setting issue. When i am trying to run a shell script thru html file , then it is throwing...

Arbind

09-19-2006 09:21 AM
Arbind

Hi. IDS V10 on RHEL3. A bit of knowledge of Database though (Informix SE to name it) 1- dbaccessdemo works ok.So I create the database MY_DB, some...

cmic

09-19-2006 09:18 AM
Art S. Kagel

Hello all, What is the Informix equivalent to oracle's function "TO_CHAR", for date formatting? I want to format a date to string YYYYMMDD. Thanks

Fotopoulos Lefteris

09-19-2006 08:33 AM
Fotopoulos Lefteris

I have ids7.3 runninig on hpux.I have the following error when i run oninit: Fatal error in shared memory creation'.I got this error message after...

gwanzuradmire@yahoo.com

09-19-2006 03:36 AM
Martin Fuerderer

Ian Michael Gumby wrote: online and turbo are not one and same. In fact one of the reasons turbo was renamed to online was bcos of the ability to...

roger@star2000.com.tw

09-19-2006 03:32 AM
Jonathan Leffler

We are doing dbimport, it is extremely slow. The job was done with only 3 hours with IDS10 UC4 on the same platform EXCEPT the disk...

Yunyao (Frank) Qu

09-18-2006 04:16 PM
Art S. Kagel

Hi, can you tell me please where could I download JDBC debug driver for Informix (eg. ifxjdbc-g.jar ..). I was not able to find it on IBM web pages...

Lukas Barton

09-18-2006 03:01 PM
Amit Dandekar

Hi list, I discovered what looks like a little documentation bug in esql on Windows (CSDK 2.90TC5). The primary development platform for my...

Carsten Haese

09-18-2006 01:49 PM
Fnu Gaurav

Hi, Wondering if any one can help me with this strange one. Rebuilt ISM as standard. Initiallyising the database with ism_startup -init and get...

mahesh

09-18-2006 11:54 AM
Robert Seifert

Hi, is there a smart way to search any value all-over the database regardless in which column it is stored? We are using IDS 7.31. TIA, Joachim...

Joachim Engel

09-18-2006 11:27 AM
bozon

We have recently started Informix Replication. Our Secondary Server is in "Read Only" mode. We have a issue after doing this.When we create...

dhaya.snidhi@gmail.com

09-16-2006 01:54 AM
Madison Pruet

I believe I've found a disturbing bug in IDS 10 involving rows inserted into a table mysteriously disappearing. And I even have the Informix Holy...

Thomas J. Girsch

09-15-2006 11:05 PM
Thomas J. Girsch

* * * Southern California Informix User Group * * * The next meeting of the Southern California Informix User Group will held on TUESDAY,...

Brucemarchu@aol.com

09-15-2006 02:35 PM
Brucemarchu@aol.com

Hallo there, I import a new database in Informix called "akt". I can locally update, insert and do anything by using the owner of the DB. But I...

09-15-2006 09:14 AM
Christine Normile

Hi I am using dbaccess from linux to access Informix db. Is there any sql that will list all the tables in the database i...

vallinayag@yahoo.co.in

09-14-2006 08:59 PM
vallinayag@yahoo.co.in

Anyone know if there's an Informix system table SQL that'll return the current permissions in force for the current connection on a given...

William Fields

09-14-2006 12:07 PM
Art S. Kagel

have a string for eg: "12|A|B", and need a function that takes "|" as field delimeter and returns 2nd or say 3rd column. Is it possible to do this...

mohitanchlia@gmail.com

09-14-2006 11:52 AM
Art S. Kagel

An oncheck -cI keeps running out of space because it makes large sort files in PSORT_DBTEMP. Is there a way to estimate how much sort space would be...

Floyd Wellershaus

09-14-2006 11:51 AM
Art S. Kagel

I am using IDS 7.31 and I have a big table which is now 22gigs in size. It now has 60 extents and I need to unload and recreate the table again. What...

mchivaviro@okzim.co.zw

09-14-2006 11:12 AM
mark.scranton@gmail.com

Ing. edwin grullón egrullon (AT) gmail (DOT) com INSTALACION DE IBM INFORMIX DYNAMIC SERVER 10.00.UC4 EN SUSE LINUX ENTERPRISE SERVER 9 1. Nos...

egrullon

09-14-2006 10:36 AM
egrullon

What is the best way to identify which tables ( or rows within tables if possible ) have in place alters ? Carlton Doe said today in a Informix Chat...

Floyd Wellershaus

09-14-2006 10:23 AM
Floyd Wellershaus

Mitja Udovè wrote: Rich

Rich or Kristín

09-14-2006 09:46 AM
Rich or Kristín

Hi all, I have a problem with a table. Doing an oncheck -cDI dabasename:tablename gives a problem in 2:346207. How can I check and repair that...

Danny De Koster

09-14-2006 06:36 AM
Danny De Koster

Hi informixer: My informix version is 9.40.FC2. It crash several times before. the messages in online.log like this: 11:16:49 Who: Session(7,...

roger@star2000.com.tw

09-14-2006 03:30 AM
Tsutomu Ogiwara

I have a string for eg: "12|A|B", and need a function that takes "|" as field delimeter and returns 2nd or say 3rd column. Is it possible to do this...

mohitanchlia@gmail.com

09-13-2006 01:46 PM
mohitanchlia@gmail.com

Hi all, Another question. How can I find the name of all the databases created in the INFORMIXSERVER?? thanks, Danny

Danny De Koster

09-13-2006 11:04 AM
Floyd Wellershaus

HI, We installed IDS 10 UC5 on AIX5.3. onstat -version: Program Name: onstat Build Version: 10.00.UC5 Build Number: N202

Quman

09-13-2006 07:07 AM
RoB via DBMonster.com

Hi Everybody, I have to write a Database Script, In which values from one tables are inserted into another table. Now the query format something like...

Prateek Jain

09-13-2006 04:46 AM
Rich or Kristín

HI everybody I need to interface PHP with Informix at the moment i have bypassed the crash problem using the adodb libraries, they work fine at the...

giulio

09-12-2006 11:17 PM
Jonathan Leffler

I have created my first form and 4GL report, but when navigating the form the up arrow key doesn't put the cursor to the previous field. I can only...

Chad

09-12-2006 11:13 PM
Jonathan Leffler

Hello all: I've got a question that is probably rhetorical, but it still makes no sense to me. I have been having some problems with...

Joe S

09-12-2006 06:10 AM
scottishpoet

--CELKO-- wrote: (www.joecelkothesqlapprentice.blogspot.com) header: ** This blog is not Joe Celko's but it is a collection of his answers...

Art S. Kagel

09-12-2006 01:39 AM
DA Morgan

Greetings, I'm faced with a project that deals with accessing databases by way of ini or config files. Basically the apps/scripts are sourcing...

Darren_Jacobs@carmax.com

09-11-2006 11:50 PM
Double Echo

I am upgrading from IDS 10.00.UC3 to UC5. I have installed UC5 into a new INFORMIXDIR and pointed the data devices from UC3 to the new version. Works...

tichman@excite.com

09-11-2006 03:17 PM
Art S. Kagel

hi.. I wanna create a trigger on to update a table in a normal database if a table in another multilingual database is updated. Source database ->...

vratesh

09-11-2006 11:42 AM
Fnu Gaurav

Hi, My developer environment: Informix Client 2.90 / Server 10.0 ADO 2.8 VB6 After I changed the Informix-Client and...

Michael Andreas

09-11-2006 08:02 AM
Rich or Kristín

Hi, my distant family. :-( A few years ago, I posted monitor-space.shar, a shell archive whose ceterpiece was dbspace-pages.sh. (It got posted as...

Beau Nanaz

09-10-2006 05:38 PM
Beau Nanaz

Hi, VB6, ADO2.8, Informix Client 2.90 / Server 10.0 with the following code I should be able to start a stored procedure. The right parameters are...

Michael Andreas

09-08-2006 05:18 PM
maccathuil

We recently encountered pretty severe dbimport bug when testing 10.00.FC5 with HP-UX 11i on a 4 processor server. The engine did an assert failure...

Jeff Davis

09-08-2006 04:52 PM
Southwell Schuyler

Hi, Thanks to some of you, we have contact information for about 120 journalists, in: France, Belgium, USA, Malaysia, South Africa, Sweden,...

Jean Georges Perrin

09-08-2006 03:52 PM
Jean Georges Perrin

Is there a way to generate a random number through an Informix SPL? If not is there any other way to generate a random number within a specified...

alkyr

09-08-2006 06:36 AM
scottishpoet

I use dbexport rootdbs -d stores7 common to export this db . so this is create stores.exp directory include "*.nul" and " stores7.sql " files...

sunqf

09-08-2006 06:34 AM
scottishpoet

IDS 7.31.FD7 Solaris 9 I have a 'old' instance that had been used for some P.O.C. work and I need to save the data for possible future evasluation....

Colin Dawson

09-08-2006 06:23 AM
Colin Dawson