How to restrict no. of records in Informix. means i wana a procdure wich will no. of records returned by select statement. This can be be done by...

Kuldeep

04-13-2006 09:46 AM
Obnoxio The Clown

Someone can help me with a question about deleting a dbspace?? Rosibel P. Gonzalez System Specialist DHL Information Services DHL Express &...

Rosibel Gonzalez \(DHL PA\)

04-13-2006 01:47 AM
Superboer

Recently I found many lines of error in my online.log indicating that a connect attempt is failed because of invalid username/password. I guess that...

Merlin Ran

04-13-2006 12:51 AM
Merlin Ran

the hague event is a number of days and 2000 odd Euros however Informix Day Overview Join us for a special Informix Day on May 16 in The Hague,...

david@smooth1.co.uk

04-12-2006 11:27 PM
John Carlson

Merlin Ran <merlinran (AT) gmail (DOT) com> wrote: Recently I found many lines of error in my online.log indicating that a connect attempt is failed...

Anup Nair

04-12-2006 10:45 PM
Anup Nair

Not wanting to put down PPA as lots of IBM people have been very helpful getting PPA to work for my company. Interesting someone got it early march,...

PeterP

04-12-2006 10:05 AM
scottishpoet

Hi: For minutes, me key instance INFORMIX. Log indicates the following thing to me 10:13:43 Logical Log 47158 Complete. 10:13:52 Logical Log...

Juan Pablo

04-12-2006 06:28 AM
scottishpoet

I am trying to assist a friend in Africa with an IDS 9.4 FC3 problem on AIX 5.2 The server crashed with the following log information. 15:29:42 ...

Gary

04-12-2006 04:10 AM
Gary

Hi! IDS 9.40FC6 onstat -g mem | grep aio Pool Summary: name class addr totalsize freesize #allocfrag #freefrag aio V ...

zaiets

04-12-2006 01:57 AM
zaiets

May I remind you that I am running a 4GL survey and I welcome all participant to join and answer. More details on...

Jean Georges Perrin

04-12-2006 01:25 AM
Jean Georges Perrin

Can any body help me in finding out the reason why our Database Server access all of a sudden becomes extremly slow. ( "dbaccess" take a long time to...

dhaya.snidhi@gmail.com

04-11-2006 06:49 PM
Murray Wood \(IList\) \(Murray Wood \(IList\)\)

I thought I heard a while back about an environment variable setting to change the default isolation level to DR. Does anyone know about this, or...

Nick

04-11-2006 06:45 PM
david@smooth1.co.uk

I have just bought a new server runing HP-UX 11i. Can I just copy my informix directories from another UNIX Box and restore or I need to install it.

mchivaviro@okzim.co.zw

04-11-2006 01:08 PM
mchivaviro@okzim.co.zw

I have some timeseries data in a table called mytest- there are 9 rows and each row contains a timeseries which contains somewhere between 5,000,000...

Niall Macpherson

04-11-2006 07:31 AM
Rich or Kristín

I am connecting to informix via ODBC 2.90, the database is version 9.40. I execute this query, for example: SELECT ap_maximo/ap_minimo FROM...

agustincb

04-11-2006 05:48 AM
Rich or Kristín

One of hour guys deleted by mistake just a couple of records from database (IDS9.40). We do not want to restore the back up as it would create more...

Gentian Hila

04-11-2006 04:48 AM
TBP

Hi Gurus, a question for you. And sorry in advance if it has been already answered: I cannot find any previous reference to what I am looking for. I...

Rupan3rd

04-11-2006 03:07 AM
Davorin Kremenjas

idsexpert (AT) gmail (DOT) com wrote: UPDATE STATISTICS LOW has been ran, and is re-run on each table on a periodic basis. Along with HIGH on...

cgates

04-10-2006 11:06 PM
John Carlson

I received a mail from IBM regarding a table editor for Multiplatforms - even though this is for DB2, I was wondering if this could also be used as a...

Dirk Moolman

04-10-2006 12:35 PM
baba_jaga@tahiti.net

In December 2005, "Frank" <fmor... (AT) yahoo (DOT) com> asked: Back in December, people partially identified the problem - there was a stored...

Jonathan Leffler

04-10-2006 10:42 AM
Doug Lawry

I can confirm this. Had a similar issue about 2 months ago, with a procedure calling a 4gl, which crashed, and gave me the same result ... We...

Dirk Moolman

04-10-2006 10:20 AM
Dirk Moolman

1) Seo Elite: New Seo Software! The Grand Daddy of all Seo Software! Get A Top 5 Google Ranking In Under 30 Days! 2) Registry Toolkit - Registry...

cavendish32@yahoo.de

04-10-2006 08:05 AM
cavendish32@yahoo.de

PeterP wrote When you install IDS 9.40.XC8 , you might want to ensure this flash does not apply to you :...

Model-Bosch, Tilman

04-10-2006 07:14 AM
Model-Bosch, Tilman

Hi all: I at the moment have problems with my database server (SBD) INFORMIX. Of a little while to another one the parametros of the exit: onstat...

Juan Pablo

04-09-2006 04:10 PM
GatorMan

Hi, I'm searching considerations and opinios involved in transactions between two databases and different instances. The reason is that a few day...

rafapadilla@yahoo.com

04-09-2006 12:09 PM
david@smooth1.co.uk

Yeap - but I'm worried on the current situation of European Informix Usergroups.. Are they interested ? So far, we had no feedback from them.

Hubert Hoelzl

04-09-2006 11:57 AM
david@smooth1.co.uk

On 4/7/06, Gentian Hila <genti.tech (AT) gmail (DOT) com> wrote: A simple column is a column name - such as customer_num or customers.customer_num...

Gentian Hila

04-08-2006 12:57 PM
Jonathan Leffler

I think we should have a thread name that really reflects what we are talking about. As you are all probably aware I do have some experience in this...

mweallans@panacea.co.uk

04-08-2006 08:01 AM
Double Echo

Hello everyone. I'm setting up ER on three servers in primary-target mode. All servers run Linux kernel 2.6 (Debian, Suse SLES 9 and Redhat RHEL 4)...

Davorin Kremenjas

04-08-2006 05:15 AM
tarod35

Dirk Moolman Database and Unix Administrator Digicare Technologies (HealthCorp) The other day I was trapped on an escalator for hours....the power...

Dirk Moolman

04-07-2006 09:48 PM
david@smooth1.co.uk

Hi all Just wondering if it is possible to trigger a java class from informix. The scenario is that I want to have a print queue table and once...

petereakin@gmail.com

04-07-2006 09:46 PM
david@smooth1.co.uk

We have both SQL server client and Informix client. The ideal solution will be maintain single set of sql statement for both. Do you know if .net...

fj

04-07-2006 11:19 AM
shekariyer@gmail.com

I have a test system utilizing ER on linux. What I am trying to do is to archive the target server late at night. The majority of the time it works...

hjohnson@keeneinfo.com

04-07-2006 02:22 AM
Superboer

Well - finally got the checksum UDR into developers works to enable v10.xC4 'cdr check'...

mpruet@comcast.net

04-06-2006 11:58 PM
mpruet@comcast.net

Hello all, I have this problem : 01:08:38 Found during mt_shm_free 4 01:08:38 Pool 'sscpool3' (0x7000000e0e22040) 01:08:38 Bad block header...

Vaclav Boura

04-06-2006 05:34 PM
Art S. Kagel

Dear Informixers, at least the more recent versions of the Informix CSDK and Connect for Windows contain a program called "DSN Migrate". I haven't...

Richard Spitz

04-06-2006 02:25 PM
shekariyer@gmail.com

I recently spent around 30,000 with an accredited IBM vendor to buy SE ISQL ESQL I have used these products on a RISC but have new hardware. I gave...

kjuliff@gmail.com

04-06-2006 11:47 AM
Marco Greco

This select returns nothing when in fact it should return 3 rows : create table t1(id int); insert into t1 (id) values(0); insert into t1 (id)...

smitin@gmail.com

04-06-2006 11:13 AM
eriegger

I am trying to find duplicate rows, and only want to return one rowid from the pair. If I do (rowid !=): SELECT i2.rowid FROM inv i1, inv i2 WHERE...

JaxenT

04-06-2006 10:44 AM
Rich or Kristín

Hello All, Anyone looking for an Sr. Informix DBA position, fulltime, for a financial company? Either in Manhattan or central New Jersey. Please let...

Jobman

04-06-2006 10:05 AM
Jobman

I hava a database that I want to move from one Informix server to another. They both reside on the same machine with the same...

Gary Andrus

04-06-2006 09:44 AM
reinaldo99@gmail.com

JaxenT wrote : SELECT FIRST 1 i2.rowid FROM FROM inv i1, inv i2 WHERE i1.h_num = 698 AND i2.h_num = i1.h_num AND i1.inv_date = i2.inv_date AND...

Model-Bosch, Tilman

04-06-2006 09:43 AM
Model-Bosch, Tilman

When I design tables, I normalise to the 3rd degree .... using lookup tables for entities with large text fields, eg. City: Code integer Name ...

Dirk Moolman

04-06-2006 07:24 AM
Obnoxio The Clown

Hi All Hope there is still a few people running or knowing something about this old dinosaur of ours. I am getting index corruption from...

Franz Grutzmacher

04-06-2006 07:16 AM
Obnoxio The Clown

I received a mail from IBM regarding a table editor for Multiplatforms - even though this is for DB2, I was wondering if this could also be used as a...

Dirk Moolman

04-06-2006 03:47 AM
Dirk Moolman

Dirk Moolman Database and Unix Administrator Digicare Technologies (HealthCorp) The other day I was trapped on an escalator for hours....the power...

Dirk Moolman

04-06-2006 03:47 AM
Dirk Moolman

Dirk Moolman Database and Unix Administrator Digicare Technologies (HealthCorp) The other day I was trapped on an escalator for hours....the power...

Dirk Moolman

04-06-2006 03:13 AM
Dirk Moolman

I received a mail from IBM regarding a table editor for Multiplatforms - even though this is for DB2, I was wondering if this could also be used as a...

Dirk Moolman

04-06-2006 03:13 AM
Dirk Moolman

After attempting to read the Trusted Hosts manual and going in several loops with all of the circular references in the documentastion, I am ready to...

Doug McAllister@Fidelity Investments

04-06-2006 12:47 AM
Jonathan Leffler

Dear 4GL Users, Like many people, I am convinced that 4GL has its place in the 21st century, between Java and .net or with Java and .net. Maybe the...

Jean Georges Perrin

04-05-2006 11:58 AM
Double Echo