We have a program for database upgrades that checks the current database structure, compares it to what it should be for this upgrade and executes...

Joachim Verhagen

12-12-2006 06:18 PM
Art S. Kagel

Hi I'm having some trouble with an Informix Query I hace the following: select * from table1 where datefield >= '20112006' and datetimefield...

luissol

12-12-2006 03:15 PM
Carsten Haese

Guys, Guys... The original post was serious. I hope the original guy is still reading these posts on his thread...... and is getting a feeling for...

Sebastian, Norma J.

12-12-2006 10:58 AM
Sebastian, Norma J.

Hi, I'm Mike Segel. My use of the "Gumby" alias has a long history within a certain segment of Informix users and employees. (And shareholders)....

Ian Michael Gumby

12-12-2006 04:02 AM
Jean Georges Perrin

Timmy! Is that you? Seriously dude, I did read your post. But lets get real here. How many situations did you walk in to where you had a clean...

Ian Michael Gumby

12-11-2006 09:54 PM
Ian Michael Gumby

First, note that not all of the e-mails are coming through the gateway. (Or is Hotmail bouncing them?) Anyways back to the point on hand.... 1)...

Ian Michael Gumby

12-11-2006 09:44 PM
Ian Michael Gumby

Hello all, Does anyone have a suggestion for a tool to validate data changes in a testing environment? Specifically, the testers are looking...

12-11-2006 07:52 PM
sualeh.fatehi@gmail.com

I have following sql to run on an IDS 9.40: select case when serv_type_id in (select serv_type_id from s_serv_type where type_name like "A%") then...

Merlin Ran

12-11-2006 06:59 PM
Art S. Kagel

Hi all, What should be the size of rootdbs .I mean the optimum size. How does the size of rootdbs affect the IDS performance? It is takijng a lot...

doitman

12-11-2006 05:41 PM
Ian Michael Gumby

Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop...

Prashant Shirude

12-11-2006 02:16 PM
Neil Truby

Wow, that was a seriously delayed message...it was fixed the 1st. -----Original Message----- From: informix-list-bounces (AT) iiug (DOT) org On...

Gentsch, Sam

12-11-2006 01:47 PM
Gentsch, Sam

Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop...

Prashant Shirude

12-11-2006 12:46 PM
Prashant Shirude

Hi all, I need the opinion or helps of You. I have a SUN Ultra Enterprise 3500 with solaris 8, Veritas 5 and Informix 9.21. Until before installing...

Omaluva

12-11-2006 10:43 AM
Superboer

Darren_Jacobs (AT) carmax (DOT) com said: Cut the guy some slack. Not everyone is perfect like you. -- Bye now, Obnoxio "I don't read newspapers...

Henry

12-11-2006 10:37 AM
Art S. Kagel

I am trying to run a SQL against system tables that will show me which tables are in each dbspace and then correlate their indexes to see if the...

Kennedy, Randy

12-11-2006 10:23 AM
Art S. Kagel

Hi all, I need the opinion or helps of You. I have a SUN Ultra Enterprise 3500 with solaris 8, Veritas 5 and Informix 9.21. Until before installing...

Omaluva

12-11-2006 10:14 AM
Omaluva

Informix: 9.40FC3 O/S: HPUX 11.11 We had a need to restore 2 tables that had all data deleted so we attempted a ontape -r -D dbspacename. However,...

Kennedy, Randy

12-11-2006 09:43 AM
Kennedy, Randy

Devaraj Takhellambam said: OK, so how about some platform information? Hardware / OS / IDS / Versions / RAM / disk / # of rows / dbschema of...

devaraj.takhellambam@gmail.com

12-11-2006 09:21 AM
macgillivary

"pretty good"..... ????..... keep us posted.... you will find it's far better than pretty good. Far from dead and still the best. I'm sure you will...

Sebastian, Norma J.

12-08-2006 07:42 PM
Sebastian, Norma J.

Is it a 'norm' that DBA's use a data model (both logical and physical) to design a database? or Are data models mostly used as a 'post-design'...

Urich Ann

12-08-2006 06:17 PM
Double Echo

Hi I am trying to create a generic drop procedure routine. Any help would be appreciated. Here is the code. -- This is test procedure CREATE DBA...

Bhru

12-08-2006 11:18 AM
b301

Hey I installing IDS 10 on my Ubuntu 5.10. 1. adduser informix informix 2. useradd -u 150 -g informix informix 3. passwd informix 4. addgroup -g...

Marco Schwarz

12-08-2006 08:29 AM
Marco Schwarz

Hi, Does anyone know how to redirect our logical logs backup from tape to disk? We currently use a storage manager and onbar and a seperate...

gsturkenboom@lic.co.nz

12-07-2006 06:02 PM
gsturkenboom@lic.co.nz

Wouldn't mind company for dinner... :-) -- Serge Rielau DB2 Solutions Development IBM Toronto Lab WAIUG...

Serge Rielau

12-07-2006 05:12 PM
Darren_Jacobs@carmax.com

Hello, I'm using Informix10 on Linux and I'm trying to use a simple UDR, I compile it as a shared library, gcc -fpic -c -DLINUX...

delta77@email.it

12-07-2006 05:45 AM
delta77@email.it

Hi, I need to insert all the dates in 2007-2009 into a table in the following format. calendar_date 20070101 Day_of_week MON The...

mc

12-06-2006 08:12 PM
bozon

Well Established Company in West St. Louis, Missouri ( Saint Louis )needs a Lead Developer (Programmer Analyst) to join it's staff. You will be...

Bill Law

12-06-2006 12:29 PM
Bill Law

Greetings Friends, I'm unloading a rather large table using HPL via. command line and was wondering about the syntax to use a filter so I only...

Tam OShanter

12-06-2006 10:54 AM
Tam OShanter

Greetings, Thanks in advance for your help. Mike Badar ESRI Professional Services 1 International Ct. Broomfield, CO 80021 mbadar (AT) esri (DOT)...

Mike Badar

12-06-2006 08:37 AM
Mike Badar

We are upgrading from 9.3 to 10.0 and have found the BTSCANNER defaults to be a must change. Based on the recommendations in a post from Alexey...

Andrew Ford

12-05-2006 02:53 PM
Mark Jamison

Hi all, I have a problem, i did dbexport on informix 9.30 - Windows 2000, then pass by ftp to Informix 9.30 on Unix Solaris, here, when i try to...

Omaluva

12-05-2006 11:30 AM
Art S. Kagel

Omar que tal Verifique si en el Solaris hay un comando dos2unix, este, convierte el formato dos a unix. Otra opcion, Con sed hagalo asi: Creen...

Carlos Alberto Correa Fayad

12-05-2006 10:44 AM
Carlos Alberto Correa Fayad

Hello. I'm preparing a move of my database (IDS 7.30 on HP-UX 10.20) to a new server (IDS 9.40 on SUSE Linux 8.2). On both system we're using...

emmermacher@hotmail.com

12-05-2006 02:01 AM
emmermacher@hotmail.com

Hi, I am trying to install an application that use Hibernate as RO persistence. To create the tables, the application use the mapping of types of...

sergio@moredata.pt

12-04-2006 04:06 PM
Fernando Nunes

Does anyone know how to get the current value of a sequence without incrementing it? If you have an existing sequence created with CREATE SEQUENCE...

Doug Lawry

12-04-2006 02:51 PM
Art S. Kagel

Hi all; Whats the preferred way to embed version control into SPL. I have a fairly basic string that I test for, in my "install/rollback", but...

ian

12-04-2006 10:50 AM
Zachi

All my customers seem to have lost the ability to download IDS v10 from Passport Advantage. This apparently is a known problem and the IBM software...

Neil Truby

12-04-2006 09:40 AM
Neil Truby

I have another funny video ;-) --> http://www.youtube.com/watch?v=pDRRe_1J2XE jgp ________________________________________ From:...

Jean Georges Perrin

12-04-2006 08:33 AM
Jean Georges Perrin

Hi all, I want to use my informix database with PHP. But with the compilation I get this. Any solutions? Thanks, Danny

Danny De Koster

12-04-2006 06:25 AM
Roland Wintgen

A two-day Informix User Group Technical Conference - Friday and Saturday, December 8-9, 2006 The Washington Area Informix User Group (WAIUG) based...

Lester Knutsen

12-03-2006 07:04 PM
Lester Knutsen

Hi, My box has singel processor , NUMCPUVPS =1 . A lot of user will access this server, maximum will be 1500 user threads. How shoud I set up the...

roger@star2000.com.tw

12-03-2006 05:40 AM
TBP

I am pleased to announce a new release of InformixDB, the Python API module for developing Informix applications in Python. The list of changes...

Carsten Haese

12-01-2006 11:37 PM
Carsten Haese

Hi, When I define an array inside GLOBALS statement in two modules the linker tells me that the symbol is multiply defined. This just happens to...

sergio@moredata.pt

12-01-2006 04:07 PM
Jonathan Leffler

Hi - I need to take a 4gl training class ASAP. There doesn't seem to be much available after a Google-ing of "4gl training" or "4gl class". IBM...

debbie@diversifiedmetals.com

12-01-2006 02:43 PM
Sebastian, Norma J.

Eleven FAQ's About comp.databases.informix and informix-list (AT) iiug (DOT)...

Jonathan Leffler

12-01-2006 01:11 PM
Jonathan Leffler

Appologies from the Board. The voting website is password protected right now. We should have this fixed and working by 1:00pm Eastern US...

Tomchik, Kate

12-01-2006 12:04 PM
Tomchik, Kate

IDS 9.40 FC2XA HPUX 11.11 Greetings, I have a very interesting situation that started about a week ago. My onbar logical log backups are being...

Darren_Jacobs@carmax.com

12-01-2006 11:06 AM
Sebastian, Norma J.

Hi, Use the RETURNING of the RUN statement. Bellow you have an example that works. -------------------------- MAIN DEFINE retVal INTEGER DEFINE...

samruddhiv@gmail.com

12-01-2006 10:57 AM
minnickbrian@aim.com

Hey! I was up last night around 11:00pm Central and I just happened to go to the IIUG site. They had a link up for the voting so I thought hey! Why...

Ian Michael Gumby

12-01-2006 10:35 AM
Paul Watson

I don't mess about:- Rootdbs is 2Gb in all my production instances, as is physical log and all logical log dbspaces Regards

Colin Dawson

12-01-2006 09:39 AM
Colin Dawson