hello i need informations this sqlplu for using ever for extration querys, viewrs, and convinations the informations

rovkas@gmail.com

10-06-2005 11:01 AM
Obnoxio The Clown

Hello everyone. Last week we've had sort of trouble - one chunk went offline after two mirrored disk crashed simultaneously (which was admitedly our...

Davorin Kremenjas

10-06-2005 10:22 AM
Martin Fuerderer

IDS 7.31.FD7 Solaris 9 I've got a stored procedure that takes 2 input parameters, a datetime and a relational operator (ge,lte,gte). On it's own it...

Colin Dawson

10-06-2005 09:47 AM
Colin Dawson

With Sun's latest service prices on my old E4500 with two A1000's I can get a new Sun 490 with two 3510 fiber arrays and almost pay for it for free...

Gary Quiring

10-06-2005 09:28 AM
Beefman

I want to know the difference between BLOB and SMART BLOB.. Also bpagesize gives the page size of a blob... how do i find the pagesize of a smart...

prateek jain

10-06-2005 07:35 AM
Obnoxio The Clown

Hi. I would like to know what I have to do to modify an instance name in Informix Dynamic Server 7.3, including what files to modify and in...

Massoroto

10-06-2005 06:30 AM
Ben Thompson

I am working on a system monitoring tool which allows the capture of information from a system rather than just monitor the data. As part of this...

mweallans@panacea.co.uk

10-06-2005 05:56 AM
mweallans@panacea.co.uk

Hi, I tried to do a select NULL as... for an not existing column in an Union select statement. I have a problem with my solution in 9.3 when I try...

Michael Wimmer

10-06-2005 03:05 AM
Michael Wimmer

I will be upgrading to the latest 4GL version in the near future. We are currently running on a UC (32bit) version. Should I stick to 32bit, and...

Dirk Moolman

10-06-2005 12:57 AM
Jonathan Leffler

Running 9.40.FC6 on AIX 5.3. I am familiar with most ER messages which get logged to the message log but this one popped up and I don't know what...

Link, David A. \(Omaha\)

10-05-2005 10:15 PM
Link, David A. \(Omaha\)

I finally received my copy of version 10 (10.00 FC3R1). I just went through my "knowledge base" for the order of installation, as the...

Dirk Moolman

10-05-2005 09:03 PM
david@smooth1.co.uk

I have recently encountered some interesting problems with my remote monitoring software. My software is heavily reliant on the sysmaster database...

mweallans@panacea.co.uk

10-05-2005 08:34 PM
david@smooth1.co.uk

Hi, that's how ontape works. You can of course use no-rewind tape devices, but officially this is not supported. That means you then are yourself...

Martin Fuerderer

10-05-2005 11:01 AM
Martin Fuerderer

Hi. I would like to knwo whether is it possible or not to backup more than one instance in Informix IDS 7.31 on a single tape for later restore all...

Massoroto

10-05-2005 09:37 AM
Doug Lawry

Hi. I have a problem with some tables in IDS 7.31 whose data seem to be corrupted. When I do a Check on the table mark_translation it...

Massoroto

10-05-2005 09:25 AM
Martin Fuerderer

OS: RedHat Linux ES 3 IDS: 7.31.UD8 CSDK: 2.90.xC3 1 July 2005 I get that famous '-1829 Cannot open file citoxmsg.pam' error when connecting to...

Mikko J Partanen

10-05-2005 06:10 AM
Sandor Szabo

Is this a known issue that i cannot use RECORD LIKE definitions for tables containing lvchar type columns? Informix 4GL version used is 7.32.FC2 on...

spilker

10-05-2005 03:01 AM
scottishpoet

http://www.businessweek.com/technology/content/sep2005/tc20050923_0725_tc024.htm

Data Goob

10-05-2005 12:30 AM
DA Morgan

I am having some trouble initializing shared memory on Solaris 9 with Informix IDS 9.4. --------------- $ oninit -ivy Checking group membership to...

Jef

10-04-2005 11:23 PM
Jonathan Leffler

Hi All, We are facing a very strange issue while using FOREACH. The environment is as follows: HP-UX 11.11 Informix 4GL 7.30.HC4P1 Informix Dynamic...

Ravi

10-04-2005 11:07 PM
Ravi

Hi, We are facing an issue in our informix 4gl application. Details are as follows: Environment: ------------ HP-UX 11.11

rajeevkartha@gmail.com

10-03-2005 09:20 AM
Jonathan Leffler

No, this is not a bug, but most likely caused by the dirty read isolation. Remember that dirty read casues the cursor or select to return EVERY...

R.A. Reissaus

10-03-2005 07:57 AM
R.A. Reissaus

Informix User Forum 2005 Moving Forward With Informix A Two-Day User Group Technical Conference December 8-9 in Atlanta, GA I have been putting...

Lester Knutsen

10-02-2005 07:36 PM
Lester Knutsen

Previously in these hallowed halls I have queried the values for user and sys cpu as reported by sysmaster. The documentation says that it reports...

mweallans@panacea.co.uk

09-30-2005 02:05 PM
Madison Pruet

In Informix F1-F64 Function keys are there. If in options insert key F36 is used , then which function key is going to be used for this...

vanitabk@rediffmail.com

09-30-2005 10:44 AM
Konikoff, Rob \(Contractor\)

Hi. I have some chunks DOWN within my Instance in IDS 7.3. When an instance has any chunkd down it does not let me do backups at a Instance...

Massoroto

09-30-2005 10:16 AM
Doug Conrey

4GL run-time error number -4518. The 4GL program cannot allocate any more space for temporary string storage. what to do reg this erro

calyanram@hotmail.com

09-30-2005 09:43 AM
Moi

If you're a first-rate - and I mean first-rate - Informix DBA with strong UNIX sysadmin skills, are comfortable working both in the back-room and...

andrew.watson@ardenta.com

09-30-2005 02:40 AM
Neil Truby

Washington Area Informix User Group meeting Date: Wednesday, October 5, 2005 Time: 9:00-5:00 Location: IBM, Bethesda offices. Building 6710, Wing B...

Lester Knutsen

09-29-2005 10:03 PM
Lester Knutsen

hello, regarding lock mode wait behavior, if i set lock mode wait to 10 - does informix wait for 10 before re-trying it or does it keep hitting...

tomcaml@yahoo.com

09-29-2005 06:18 AM
Fernando Nunes

Hi, - PTS-B 54311 couldn't be reproduced a long time ago, much before 7.31.UC5. - PTS-B 146032 has been fixed in 7.31.UD6, so it surely still exists...

Martin Fuerderer

09-29-2005 04:51 AM
Martin Fuerderer

IDS 10.0FC3 on Solaris 2.9 This is a brand new server which we are preparing to migrate a v9 system to. Over the past few weeks I have run multiple...

Neil Truby

09-29-2005 03:11 AM
Simmons, Keith

HP-UX 11i, IDS 9.30HC5 Afternoon chaps We have an SPL which is failing to run here - it's a fairly simple one used to call a shell script when...

malc_p@btinternet.com

09-28-2005 10:02 PM
Jonathan Leffler

Hi, I've constructed below after researching from the cdi archive. Initially it worked for a small db and now it fails for larger. dbexport mknod...

Alkin Tezuysal

09-28-2005 07:32 PM
Alkin Tezuysal

Hi all, IDS 7.31 UD4 SCO Unix 3.2 5.0.6 In the syscdr db are two tables "trg_receive_sbuf" and "trg_receive_stxn" which contains only on one server...

Heinz Weitkamp

09-28-2005 03:08 PM
Madison Pruet

Hi, all. This question is not directly related to Informix, more a generic one. Still, I always had received very good help in this ng. Thing is, I...

andris_sh@yahoo.com

09-28-2005 12:10 PM
andris_sh@yahoo.com

Querix Hydra 4.2 Takes 4GL to New Levels Software developer Querix (UK) is taking 4GL to new levels with the release of version 4.2 of its Hydra...

Hubert Hoelzl

09-28-2005 05:50 AM
Hubert Hoelzl

IDS 9.40 on Suse Linux SLES8. We backup IDS to disk using onbar and ISM. We then backup the whole Linux disk using cpio. And we have recovered this...

malcolm weallans

09-28-2005 04:32 AM
scottishpoet

I'm trying to get the media for Informix SE on AIX. Unfortunately I can't get it from Passport Advantage. I've looked on the IBM Partner "Value...

Neil Truby

09-28-2005 01:50 AM
Neil Truby

Greetings, My group is considering using ISM for archiving our XPS 8.5 instances. I'd like to configure it so the archives are written to disk...

Bob Kruse

09-28-2005 12:49 AM
Milton J. Vidrine, Jr.

Dear all, I intuitively understand what this message in online.log means, <>11:02:56 chunk reserve page extent is allocated from non-root...

Rastislav Janac

09-27-2005 06:06 PM
Madison Pruet

I usually use MS SQL Server, but am working on a project where I also have to integrate with a legacy Informix box. I do not have write priveleges...

wheresjim

09-27-2005 05:07 PM
Art S. Kagel

Fellows, This is a short story (actually long for Usenet) on the quest for a development tool from an old Informix user. I manage a 4GL shop...

Andrea De Angeli

09-27-2005 09:55 AM
sdurity@cornercap.com

It could impact the "KAIO disabled" performance which was mentioned in the backup and restore comments. --- scottishpoet <dryburghj (AT) yahoo (DOT)...

DL Redden

09-27-2005 08:12 AM
Dirk Moolman

IDS 7.31.FD7 Solaris 9 We have a query that rans in <1 sec using a 2 column composite index (id & date). I fragmented the table (it was getting...

Colin Dawson

09-27-2005 04:53 AM
Richard Harnden

Yes. It works correct all the time. l /informix/WFZ/etc/LO* -rwxr-xr-x 1 informix informix 3962 Mar 17 ...

Heinz Weitkamp

09-27-2005 03:19 AM
Heinz Weitkamp

Hi all, I am planning to upgrade IDS 9.21 to IDS 10.0 on Sun Solaris 2.8 platform. I know IDS 9.21 is already end of services. I wonder if anyone...

ngte4-db@yahoo.com

09-27-2005 01:20 AM
Davorin Kremenjas

Have installed IDS 10.0 on Windows XP. From the local host (that IDS 10.0 is installed on) I can connect to the stores7 sample database using...

koreilly@emangoe.com

09-27-2005 01:12 AM
Guy Bowerman

Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 ...

Heinz Weitkamp

09-26-2005 05:38 PM
david@smooth1.co.uk

Hi, - your IDS version actually is out of support. - you should upgrade to IDS 9.40.UCx or 10.00.UCx. Regards, Martin -- Martin Fuerderer

Martin Fuerderer

09-26-2005 10:48 AM
Martin Fuerderer