We have a burgeoning list of Informix clients in the UK (and a couple in continental Europe), and consequently have permanent and contract...

Neil Truby

12-06-2004 07:35 PM
Obnoxio The Chav

main define x char(10) let x= "P2" case upshift(x) when "P2" display "P2" otherwise display "otherwise" end case

Witek

12-06-2004 04:38 PM
Witek

Hola, general information like which log is in use, has it been backed up, what logical log unique ID does it have, how full is it, etc. you can get...

Martin Fuerderer

12-06-2004 11:04 AM
GDES Tapia La Torre Pedro

Hi I am not much aware of how the Redbrick database stores its data. We are planning to Use TSM to backup our RS6000 boxes. So If we take regular...

Krishna

12-06-2004 10:35 AM
Brice

An Informix user has asked me the following question: "I am desperately in need ofinstallation media for an Informix SQL Editor. The product we have...

Neil Truby

12-06-2004 06:20 AM
Ben Thompson

How can I test that an ontape backup has been successfully completed ? Can I run a verify or a listing from the tape ? .... dependant on what...

superboer

12-06-2004 04:38 AM
Martin Fuerderer

--0-862397491-1102185480=:47842 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi all I am using For J´s Software...

Luis Carlos Díaz Otero

12-05-2004 08:25 PM
Bryce Stenberg

I am trying to use ISQL to get a list of rows from a database. I use the command : isql -Sservername -Ublah -P -d dbname -Q \"SELECT DELIVERABLE_ID...

Ryan Ritten

12-05-2004 11:52 AM
Michael Peppler

wonder what would need so much log space when dropping syscdr ... non empty sendq (trg_send_stxn table), ... ??? Bug basically I think adding log...

Andreas Legner

12-05-2004 12:17 AM
mpruet

Hello all, Sorry to sound like a dolt (I'm always apologizing for this) but has IDS version 9.5 been released? If so, where is the...

Brice Avila

12-04-2004 07:42 PM
Jonathan Leffler

Hi all. I know some restictions about the sql DML use on prodedure/functions writed with SPL. This restrictions denied the use...

Isidre

12-04-2004 07:25 PM
Jonathan Leffler

Hello there, i would like to ask how to emulate the SHH client to work with my application. My application i wrote it in 4GL and i used F14 and...

Muthana

12-04-2004 07:22 PM
Jonathan Leffler

The results of the recent election to determine the IIUG Board of Directors for the 2005 term are now...

Neil Truby

12-04-2004 11:46 AM
Neil Truby

Hello, I'm looking for a way to get data out of a legacy system built with Informix 4.3.2 on an RS/6000. Is ODBC an option? Can anyone give me any...

Ned Lilly

12-04-2004 02:48 AM
Jonathan Leffler

Solaris 9. Java app using jdbc. client -> router -> 9 x T1 -> router -> server 2 second operations locally, take the client between 30 seconds and...

ethermion

12-03-2004 06:00 PM
Clive Eisen

Hi All Can anyone give me some advice as to the best way to implement replication with the workgroup version of Informix? Also does anyone have any...

Ian Logan

12-03-2004 01:00 PM
Neil Truby

I'm using 'char' type host variabile to insert data into a VARCHAR(20,0). I do the following: char x; strcpy(x,""); But I see that value inserted...

Gianluca

12-03-2004 12:30 PM
Abhishek Mathur

rkusenet said: I *think* the issue is setting the unique constraint number/name. However, I'm personally hugely reluctant to do any kind of diddling...

Obnoxio The Chav

12-03-2004 12:05 PM
fellfrosh

How can I audit only one table with onaudit? I work with Informix 7.31 on HP-UX 11.11 Thanks in advance

cbaffigi@apsf.com.ar

12-03-2004 09:40 AM
Obnoxio The Chav

Engine V9.3 on linux jdbc V 2.21.JC3 or clientsdk the dyn_sql.ec When i create a table like create table clobtest ( a int, b clob) ; create table...

superboer

12-03-2004 05:34 AM
superboer

--0-1490076988-1102057434=:45685 Content-Type: text/plain; charset=us-ascii Hi! IDS 9.30.UC3 on Sun Solaris 8. Does anybody now what is 'VX' shared...

Jack Miller

12-03-2004 04:56 AM
Andreas Legner

Hi! Guys please help!!! I've tried everything with this shared memory segment(rebooted), but nothing helped. still doesn't want to do oninit...

Sergey

12-03-2004 03:18 AM
Martin Fuerderer

I'm trying to connect to an Informix database server on a Unix machine from Windows XP. I'm using Informix ODBC Driver ver. 3.2.81 TC2. I can connect...

jded

12-03-2004 02:27 AM
superboer

Hi everybody! Could someone tell me if Red Hat Linux 7.0(Guinness) work with Informix 9.4? do these two programs have any problems when they work...

Sergey

12-02-2004 09:31 PM
Tsutomu Ogiwara

I am trying to compile a full list of the reasons why an INSERT INTO tab1 SELECT ... FROM tab2,tab3, tab4, OUTER tab5 WHERE .....etc might fail. Let...

malcolm weallans

12-02-2004 05:35 PM
Olaf Gustafson

IIUG Insider (Issue #53) November 2004 Just a few hours left - Don't forget to vote for the next IIUG Board of...

emailer@iiug.org

12-02-2004 05:30 PM
emailer@iiug.org

I'm trying to connect to an Informix database server on a Unix machine from Windows XP. I'm using Informix ODBC Driver ver. 3.2.81 TC2. I can connect...

jded

12-02-2004 02:55 PM
jded

rkusenet wrote: In theory it should not, in real life you will facing strange results in some cases. Not in simple Joins with two tables, but my...

Michael Klessmann

12-02-2004 09:31 AM
Martin Fuerderer

What storage manager are you using? I've had problems in the past with logical restore using Tivoli. Bill sending to informix-list

Bill Dare

12-02-2004 08:56 AM
David Buchholz

Gene Sais wrote This is one that works for me and compresses on the fly. To restore, unzip the file first, and then do normal ontape -r. ( It...

Colin Bull

12-02-2004 07:26 AM
janssen10

The election for the 2005 Board closes today, Thursday 2nd December, at 2359 GMT. The candidates' statements are available for inspection...

Neil Truby

12-02-2004 03:22 AM
Neil Truby

I downloaded IDS 9.4 for win xp from IIUG site but was unable to install it completly. When was installation almost completed i got error:...

onyx

12-01-2004 08:58 PM
Guy Bowerman

I know you can enter something like "2004-12-01 00:00:00..2004-12-31 23:59:59" and 4GL's construct will convert it to BETWEEN "2004-12-01 00:00:00"...

Olaf Gustafson

12-01-2004 05:16 PM
Olaf Gustafson

I have IDS940.UC2-1 and want to install it on SuSE 9.1. I have found at http://www-306.ibm.com/software/data/informix/linux/ids.html#94 that SuSE...

Zvuk

12-01-2004 05:12 PM
Olaf Gustafson

Hi , This is related to datawarehouse , data mining . We are told that data mining tools such as spss or sas , need a large table which has lots of...

utkanbir

12-01-2004 04:54 PM
Savio Pinto \(s\)

Hi! I am glad to introduce World's First Book on Professional Data Recovery Programming. Book also Includes a FREE CD, which contains complete...

Author Tarun Tyagi

12-01-2004 11:56 AM
Author Tarun Tyagi

I have some code in a Perl DBI script very similar to this which takes a British phone number and splits it up into two parts using the...

Ben Thompson

12-01-2004 05:51 AM
Ben Thompson

Hi guys! Need some help with informix... here is what happens. on our Linux Red Hat 7 machine we have 3 versions of informix(7.3, 9.2, 9.4) 7.3 and...

Sergey

12-01-2004 05:25 AM
Tsutomu Ogiwara

I have been researching some problems we are having with software since our upgrade from IDS 7.31 on AIX 4.3 to IDS 9.40 on AIX 5.2 (64-bit). We are...

Beefman

12-01-2004 04:59 AM
Andreas Legner

Hi , This is related to datawarehouse , data mining . We are told that data mining tools such as spss or sas , need a large table which has lots of...

utkanbir

12-01-2004 04:34 AM
utkanbir

Hello all, Our DB has noticeably gotten slower over the past few months . I checked, and our Read Utilization is down around 95%, which is rather...

Anthony Presley

11-30-2004 11:27 AM
Anthony Presley

I've been running HDR on Solaris at 4 sites for several years using the same port number and never had any problems. I don't even recall ever...

Jeff

11-30-2004 09:58 AM
Fernando Nunes

Please help me. I use IDS 9.4. I do not know ,How to set rawdevice on Fedora Core3(Kernel2.6xxx). /etc/sysconfig/rawdevices,...

dolphin

11-30-2004 07:11 AM
Ben Thompson

Elections are now open to select the Board of Directors of the IIUG for the 2005 term. There are 14 candidates standing for 11 places on next year's...

Neil Truby

11-30-2004 04:14 AM
Neil Truby

Hi, I'm currently learning how to administer Informix. I'm using v. 9.21. I was trying to find an administration tool, similar to Sql...

Steverino

11-30-2004 01:19 AM
Jonathan Leffler

Hi We offer you E-mail addresses databases (or called Bulk E-maillists) for online advertisement. we provide you with a free listof email addresses...

Jack Moradi

11-29-2004 03:03 PM
Jack Moradi

Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo...

Dooku Maul

11-29-2004 12:53 PM
Dooku Maul

hi, in order to have datas replicated on two IDS DBs , without using HDR or IER (too easy :)))) ), i wondered if it is possible to restore logical...

__toto

11-29-2004 12:07 PM
__toto

rkusenet said: Write a script to po ... oh. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"

Obnoxio The Chav

11-29-2004 08:22 AM
Esteban Casuscelli

Hi All, I would like to know what user privilege is needed to query Informix SMI tables. can any informix user query SMI tables? Pls...

Manoharan

11-29-2004 03:57 AM
Colin Bull