Brian, Try to make the server do the delete by index using the optimizer directive: delete --+AVOID_FULL(t1) from t1 where order_num = 203; In...

Alexey Sonkin

08-26-2004 02:33 AM
My Name Is Bruce and I'm A Sock Puppet

Hi, does Informix provide the ability to abort long-lasting queries via API for client programs? TIA Joachim Engel.

Joachim Engel

08-25-2004 12:26 PM
Joachim Engel

On Wednesday 25 August 2004 17:08, Julio Cesar wrote: Andreas sending to informix-list

Andreas Breitfeld

08-25-2004 12:07 PM
Andreas Breitfeld

Hey Madison, I thought I saw you were teaching some ER coolness at the conference in September. I am looking at the conference agenda and cannot...

Sam Gentsch

08-25-2004 11:24 AM
Madison Pruet

Umesh, Deleting record will not free any table space. So you will have to clean up this by hand. I don't know how onspaces works on windows but The...

aeg

08-25-2004 08:36 AM
aeg

I just spent the last 20 minutes going WTF to myself, but I finally figured it out. It seemed that a variable was changing values during a call to...

Wandering Child

08-25-2004 01:52 AM
Jonathan Leffler

hello, Is the following Stored procedure snippet valid in informix the input parameter LoanNo can have values like ('123', '456', '678') CREATE...

beginner

08-25-2004 01:45 AM
Jonathan Leffler

Hello, we have to restore about 60,000 records recently. Is there a utility to decode 'onlog -l' listing into readable format? I searched in the...

Denis Melnikov

08-24-2004 10:08 PM
Curtis Crowson

Hi. I'm trying to use a new server Blade C-API function in IDS 9.40 on XP called mi_get_transaction_id(). It appears to return a constant for the...

Clive Haworth

08-24-2004 06:32 PM
Clive Haworth

Hi, I'm newbie on Informix RDBMS. I would like to know the equivalent syntax for the following mysql query: SELECT...

Nicolas Mainczyk

08-24-2004 04:56 PM
My Name Is Bruce and I'm A Sock Puppet

According to the Docnotes for IDS 9.4 ISM cannot be used for dbpaces > 2Gbytes due to a limitation in Legato Networker 5. Would any of the Informix...

malcolm weallans

08-24-2004 01:06 PM
Neil Truby

Hi I want to catch running SQLs with their memory usage, time it was started and ended alongiwth username ,session id and if possible any information...

Shevkar, Mukund

08-24-2004 10:25 AM
Curtis Crowson

Hi Informixers, we have a legacy application that generates unique keys according to the following schema: YYLLNNNN where YY is two-digit year, LL...

Richard Spitz

08-24-2004 05:49 AM
Fernando Nunes

Hi everyone We have still got places available for following US-4GL-Training-workshops. (URL http://www.querix.com/events/index.php ) - in Grand...

Hubert Hoelzl

08-24-2004 03:12 AM
Hubert Hoelzl

Hi, Is there an easy way to search for a specific object within the database ? For example, I need to find where a specified function is being used...

N

08-23-2004 08:22 PM
gsturkenboom@lic.co.nz

Hi, all I´m using Informix Dynamic Server Version 9.40.UC2 and when i run a query in dbaccess, i get this error: -361 Column size too large My...

Wellidy Almeida

08-23-2004 04:03 PM
Art S. Kagel

Personally, I don't think "truncate" as a best practice... but: 1. As trucate is a delete without logging, why don't you consider using raw tables...

Jean Sagi

08-23-2004 12:38 PM
Rob Vorbroker

I've been trying to put Informix 7.31UD1 on a brand new Suse 9.1 PRO box, but I'm facing a lot of troubles. This version of Suse came with kernel...

julio@prodesmaq.com.br

08-23-2004 10:58 AM
Andreas Breitfeld

A couple of questions: We have a relatively old IBM RS6000. It's *really* pushed for disk space and upgrading it would be too costly. What I've...

Chris Funderburg

08-23-2004 04:04 AM
Simmons, Keith

Hi, I am trying to set up ISM on Informix 9.3 and I believe the pool names ISMData and ISMLogs are not being created when I run ism_startup...

Brett Sheeran

08-22-2004 05:49 PM
Brett Sheeran

;) I wonder the day when IDS and XPS syntax will be merged... Maybe it could be *** a lot dificult, if not imposible *** to do... but it would be...

Jean Sagi

08-22-2004 03:26 AM
Mark Townsend

rkusenet wrote: AD was something like Advanced Decision. But this is XPS as far as I know.. How long ago did he leave Informix? I don't recall when...

Jonathan Leffler

08-20-2004 10:36 PM
Jonathan Leffler

Hi, everybody, I have some useful information regarding MULTISET behavior on HDR secondary. It appeared, that the problem doesn't relate to...

Alexey Sonkin

08-20-2004 06:05 PM
Alexey Sonkin

You better think on dbexport/dbimport... It seems that some information in the database is corrupted. Juest to be safe do an dbimport. OTOH, use...

Jean Sagi

08-20-2004 04:39 PM
Jean Sagi

Hi how to find index createion timestamp? thanks Regards sending to informix-list

Shevkar, Mukund

08-20-2004 04:27 PM
Dave Griffen

Hello everybody, today we brought our dbase down to finetune our onconfig. After it, it couldn't get started anymore. So we placed our old...

Bjorn De Waele

08-20-2004 01:19 PM
Bjorn De Waele

Hi people, I have some problem with moving data from IDS on Windows 2000 to IDS on Unix (HP-UX). We have some application which can run on both...

rowos@atlas.cz

08-20-2004 03:57 AM
Claus Samuelsen

Hi all, Environment: Informix 7.31FD5 HP-UX 11.11 GCC for HP-UX 3.4.1 I am getting error below when I try to compile myschema.mk.norcs. Does anybody...

Ricardo

08-19-2004 04:52 PM
Ricardo

Hi, everybody, I'm in a deep frustration about HDR quality and implementation in 9.40uc4 In fact, 9.40 HDR is totally unusable: by creating a set...

Alexey Sonkin

08-19-2004 03:15 PM
Ajay Gupta

The following simple query I have , is returning 38 rows , although I know that it should return me 40 rows. select * from ledgdet where lindex...

Hakan Bardavid

08-19-2004 12:17 PM
Art S. Kagel

I am totally new to Informix and Unix. I have been presented with a database system running Unix and is using an IBM Informix v5.1 database. I need...

Lionel Chin

08-19-2004 12:14 PM
Art S. Kagel

Thanks Jonathan, I thought the same.... May be two different people implemented the same function but forgot to talk to each other... Or Marketing...

Hubert Hoelzl

08-19-2004 05:02 AM
Hubert Hoelzl

IDS 9.40FC3W2 on HP-UX11.11 I'm running an onpload (HPL) run job which is loading 35m rows to a table then enabling the indexes. The index...

Neil Truby

08-19-2004 04:21 AM
Neil Truby

Could anyone please explain me about the difference between fgl_winbutton() and fgl_winquestion(). I think I miss something.... fgl_winbutton(title,...

Hubert Hoelzl

08-19-2004 12:29 AM
Jonathan Leffler

Hi DBA's, I have an installation of informix 9.40 FC1. Every time we run the nightly backup onbar -b -w , it adds three processes to the list of...

zombie

08-18-2004 11:38 PM
Jonathan Leffler

I am looking to for any timing info on SELECT's from a blob column versus a varchar column of the same size. Is there any advantage of using a...

Scott

08-18-2004 05:39 PM
Scott

Greetings All, Many moons ago I worked on an Informix data warehouse system where each row had an integer hash total check digit. I cannot recall...

Tim

08-18-2004 02:22 PM
Curtis Crowson

Block meaning that I'm having a mental block... I have a db where customer group information is kept in a separate table from customer. Customer...

John White

08-18-2004 02:15 PM
June C. Hunt

Is there something in Informix thats analagous to the truncate function in MSSQL Server truncate? Looking for a way to very quickly get rid of every...

sumGirl

08-18-2004 01:30 PM
Curtis Crowson

**only for Informix 4GL/D4GL/Esql/C users from the UK & Ireland Hi everyone We have still got three places available for the UK workshop...

Hubert Hoelzl

08-18-2004 08:02 AM
Hubert Hoelzl

Hi, If anyone worked on migrating from Informix database to Oracle database, request you to please give some inputs on this regarding the procedure...

Madhury

08-17-2004 06:17 PM
David E. Grove

What could I do if the w2k server, which is the informix server (7.31tc1), from a workgroup has been taken into a domain? It doesn't answer by the...

Olivia Custodio

08-17-2004 06:03 PM
Murray Wood (IList)

I want to create a new database in a specific DBspace so that all data is written into that dbspace in the future....what is the command line options...

Geezer From The Freezer

08-17-2004 03:55 PM
Gary Child

Hi All , I need some help as I am have dicfficulty finding any examples of Tivoli dsmc commands to see what has been backup up. Informix...

Traveller2003

08-17-2004 11:24 AM
Steffen Herold

New releases of my packages, myexport and utils2_ak, have been installed in the IIUG Software Repository. Details of the update are found...

Art S. Kagel

08-17-2004 08:25 AM
Art S. Kagel

Ugh. Trying to restore an ontape backup and getting the following error. ---start error info Read/Write End Of Medium enabled: blocks = 99542 Please...

sumGirl

08-17-2004 03:58 AM
Simmons, Keith

My customer is on 7.2x on HP-UX 10.20. Informix support patched one of his chinks better a couple of months ago. Now (and probably then) he is...

Neil Truby

08-17-2004 03:56 AM
Simmons, Keith

Is anyone else experiencing this ? I am quite sure I am loosing e-mail from this list. Example, I find replies to posts, but the posts being replied...

Dirk Moolman

08-16-2004 08:03 PM
June C. Hunt

We have recently run into a failure condition several times when we have IDS 9.40 UC3 configure for data replication. We do not seem to see the...

Rick Colonello

08-16-2004 12:47 PM
Esteban Casuscelli

Hi! I need a better way to compare tables. This works, but it only shows the number of rows and will show 0 if the replication has been...

Tor Stormwall

08-16-2004 12:43 PM
Esteban Casuscelli