Statement of Problem: I have an Informix SQL procedure running against an Informix-4gl database which is getting a deadlock error (-239). My...

KLD

06-28-2006 05:11 PM
Art S. Kagel

We have an ALTER TABLE statement that will change VARCHAR(30,0) to VARCHAR(80,0), The table has 99M rows. When running a test it looks like it is...

Colin Dawson

06-28-2006 09:07 AM
TBP

Hi: I need the value for SHMBASE for more than 4 Gb RAM with IDS V10 UC3 I have Red Hat Enterprise Server 4.0 with 2.6 kernel Only have 2.5 Gb...

lossanchez

06-28-2006 07:35 AM
lossanchez

I am facing some problem while executing the process thru cron. My execution scripts (KORN shell) will be something as below: echo U$(tput...

yy4 via DBMonster.com

06-28-2006 05:44 AM
Mike Aubury

Hi, 1) Can someone please tell me the differences between Byte and BLOB data type in Informix. (Reading through the manual, both sound similar to...

AT

06-27-2006 11:22 PM
Madison Pruet

Hi all, OPTCOMPIND 2 # To hint the optimizer for oltp do not set it to 2 set it to 0...

tomcaml (AT) yahoo (DOT) com

06-27-2006 05:25 PM
Madison Pruet

I've just uninstalled IDS10 from my laptop, now Data Direct and ALL my ODBC connections now work. So re-install IDS10 and the ODBC is still broken ...

Paul Watson

06-27-2006 11:38 AM
scottishpoet

We recently copied data from IDS 7.x to IDS 9.40 and we discovered following SQL statements does not return any data even after couple of hours on...

AT

06-27-2006 10:37 AM
Michael Krzepkowski

I am trying to setup a DSN for MS Access using ODBC 2.9-TC5 on a IDS 9.4 engine. I have never used a DSN before. After setting up the DSN all I get...

Gary Quiring

06-27-2006 09:39 AM
Gary Quiring

-- http://www.demon-du-midi.com/

loliekate

06-27-2006 03:28 AM
loliekate

Greetings, I'm looking for some SQL help. I have two tables: Table 'h8_address' has approximately 370,000 rows; Table 'land_records' has...

Mike Badar

06-26-2006 05:36 PM
Mike Badar

Gonzalo Melero González wrote: In 4gl you can call function ascii(<number>) which will return ASCII character represented by that number. In 4gl to...

AT

06-26-2006 03:52 PM
AT

I have an application I'm trying to figure out what the results are at the database level when certain functions are executed. Is there a way,...

William Fields

06-26-2006 10:55 AM
Glyn Balmer

I need an idea of the number of customers who are using blobspace blobs as opposed to smart blobs. That is - how many customers are using BYTE/TEXT...

Madison Pruet

06-26-2006 04:08 AM
Davorin Kremenjas

Jean Georges Perrin said: Jean Georges, forgive me, but I must disagree with you. There are many DB2 UG events where people can go to learn about...

Lester Knutsen

06-24-2006 09:40 AM
Double Echo

hi, when starting replication manager i got an error : invalid sqlhosts format, i changed INFORMIXSQLHOSTS to may machine name, but after...

Maumas

06-24-2006 01:47 AM
Jonathan Leffler

Don't remember seeing a post on this, I got the file a while ago, but only just got a www link. PAGE 7, potential? new features: I like the Idea of...

PeterP

06-23-2006 09:12 PM
AT

Solaris 10 introduces a new way for handling the services: SMF (service management facility)....

Rupan3rd

06-23-2006 08:42 PM
AT

I am runnind IDS 7.31 on HPUX 11 and my check points a taking too long. What do I need to change. 12:03:10 Checkpoint Completed: duration was 21...

AT

06-23-2006 08:40 PM
AT

Hello, I use the ODBC Driver 2.90 TC4 (server IBM AIX client Win2000 Box). Everything works fine. But how can I make that the driver translates...

cosmoxx

06-23-2006 12:52 PM
Claus Samuelsen

Just for information if people are interested :-) The system is a 4way HP with direct storage, ontape via STDIO and gzip to disk is giving us 40GB...

Paul Watson

06-23-2006 11:50 AM
Gentsch, Sam

hello, does somebody know a direct link to browse all the manuals by version ? looking for ids sql syntax version 7.31. thanks

AT

06-23-2006 09:55 AM
Priyadarshi Jena

I have some problems with replicates using ER and triggers on IDS 10 FC4/Rhel 4 platform. So, I'm replicating the table1 on serv1 to another table2...

cristizaharioiu

06-23-2006 02:31 AM
cristizaharioiu

Hi,i have a database with 80gigabytes of data with 360users and up to 400 when at peak.I use IDS 7.31 running on HP-UX 11.0 and 8 Gig of memory.The...

PapaKiKi

06-22-2006 10:41 PM
John Carlson

I am using IDS 7.31 and my databaseis 80gig, running on HP-UX 11.0 and 8 Gig of ram.My backup is taking around 8hrs to finish and i suspect my tape...

PapaKiKi

06-22-2006 09:19 AM
mjldba

Material on Win runner, Load Testing, Unit Testing and Much More... Articles, Methodologies, Q&A on Software Testing Techniques &...

AT

06-22-2006 09:04 AM
AT

Hi friends: I am using the following version of informix 4gl: -- IBM INFORMIX-4GL Version 7.32.FC2 I tried to use "CASE" in the conditional...

AT

06-22-2006 05:27 AM
Obnoxio The Clown

Hello All, Been a while since I've worked with Informix (Pre Big Blue...). Wondering if anyone has any recommendations or insight on some good...

Tam O'Shanter

06-21-2006 05:50 PM
tomcaml (AT) yahoo (DOT) com

----- Forwarded by Darren Jacobs/7001/Carmax on 06/21/2006 04:34 PM ----- Scott Walters/7001/Carm ax ...

AT

06-21-2006 04:35 PM
AT

Does anyone have any experience in running IDS 10 (or 9.4) on Sun T1 or T2? If so, were there any special configurations used for IDS or the O/S? I...

informix_guy

06-21-2006 02:17 PM
informix_guy

Here's a snippet from the Informix 10 Manual: "When you create a view, PUBLIC does not automatically receive any privileges for a view that you...

Chris S

06-21-2006 01:44 PM
Chris S

Hi all, I have a korn shell script which executed using the "system" command in a stored procedure. Everything works fine when I ran the stored...

AT

06-21-2006 12:07 PM
Art S. Kagel

We have a custom Warehouse Distribution system written in 4GL (Fourjs BDL) using an IDS database. About 150,000 part numbers and 10 years of...

Brian Grellinger

06-21-2006 11:50 AM
Daniel Richardson

Create trigger blabla Referencing new as <correlation name> Is there a default for correlation names in IDS, so that it is not necessary to specify...

Dirk Moolman

06-21-2006 11:46 AM
Art S. Kagel

-----Original Message----- From: informix-list-bounces (AT) iiug (DOT) org On Behalf Of TBP Sent: Tuesday, June 20, 2006 3:13 PM To: informix-list...

Ford, Andrew G

06-20-2006 03:43 PM
Ford, Andrew G

Is there a way to determine how "messed up" an index is after a large number of deletes have been done to a table? I searched here and didn't see...

bozon

06-20-2006 01:35 PM
Neil Truby

Help? We made a physical move, and after some looking / poking around, decided to move 1GB of RAM from our db server and put it into our...

Anthony

06-20-2006 09:18 AM
ChrisSalch

Hi. We are experimenting with the Informix Web Data Blade on a Red Hat Linux Enterprise 4. Not got to far so far. Running the ./install script we...

trev

06-20-2006 05:34 AM
trev

mchivaviro (AT) okzim (DOT) co.zw wrote Try to increase LRU_MAX_DIRTY and LRU_MIN_DIRTY to 2 and 1 It might just be that the checkpoints take...

Model-Bosch, Tilman

06-20-2006 05:34 AM
Model-Bosch, Tilman

Hello friends, I have got a code which is executing fine in one machine but not within the other maching *EXECUTE cusor_name into...

Prateek Jain

06-20-2006 02:33 AM
Jonathan Leffler

Hi , I am not new in installing informix products, But I have failed on installing i4gl new product which is just arriving. I4GL: 7.32.FC2 AIX:...

roger huang

06-19-2006 09:33 PM
vincent yeung

I've just upgraded a server to 9.40.FC8 (from 7.31.FC7) and dostats works fine when running on table but crashes when run against stored...

Colin Dawson

06-19-2006 06:14 PM
Art S. Kagel

Thanks a lot everybody. This was very helpful. As very new to Informix I had no idea what DB-Access is. Now I think it will open a lot of other...

Gentian Hila

06-19-2006 10:08 AM
Gentian Hila

david (AT) smooth1 (DOT) co.uk wrote Connect to sysmaste database: select s.partnum, hex(s.flags) flags , f.indexname from sysptnkey s,...

Model-Bosch, Tilman

06-19-2006 08:06 AM
Model-Bosch, Tilman

IDS 9.40FC4W2 Trying to alter a table IDS generates the error: -898 Cannot alter a table which has associated violations/diagnostics tables. The...

Habichtsberg, Reinhard

06-19-2006 04:53 AM
Habichtsberg, Reinhard

Hello All. I have recently used ALTER FRAGMENT to move a table from one dbspace to another, and this table had a unique constraint defined in a...

reitota (AT) gmail (DOT) com

06-19-2006 03:52 AM
Superboer

Apologies if this has been round before. Does anyone know a way of setting PDQPRIORITY through an ODBC connection? I've found a way to SET ISOLATION...

Colin Dawson

06-19-2006 02:29 AM
Sheshnarayan Agrawal

Hi , I am not new in installing informix products, But I get a installaion failure this time. the 4gl version is 7.32.FC2. AIX : 5.2.0.0 #...

roger huang

06-18-2006 11:56 PM
Tsutomu Ogiwara

since I can't use the LOAD command inside a stored proc in informix...how can I load a datafile into a table within a proc?

AT

06-16-2006 12:55 PM
Jonathan Leffler

I reproduced the error on a test table and found out that the internal index which exists to implement the UNIQUE constraint has been modified to a...

Model-Bosch, Tilman

06-16-2006 09:52 AM
Model-Bosch, Tilman