Hi, all. I'm about to start a project to evaluate Ingres Replicator for a customer who wishes to implement a contingency plan between databases at...

jimwgramling@gmail.com

10-04-2005 05:40 AM
Paul Mason

Danny, According to this whitepaper Unicode works through ODBC http://www3.ca.com/Files/WhitePapers/unicode_whitepaper_final.pdf Peter T: +44...

Peter Gale

10-03-2005 07:06 AM
Peter Gale

Hi Danny, I can't answer your specific question regarding ODBC but I do know that Ingres R3 provides full Unicode support so it is possible that the...

Peter Gale

10-03-2005 02:00 AM
Peter Gale

Hi Grant et al, If you have a spare second or two.... Is there any difference between using the '?' place holder for an SQL statement and using a...

martin.bowes@ctsu.ox.ac.uk

09-30-2005 08:59 AM
martin.bowes@ctsu.ox.ac.uk

We have tables in our schema with columns of type VARCHAR, CHAR, TEXT and C If a join occurs between a column of type TEXT and a column of...

colin.hay@fintechnix.com

09-30-2005 07:12 AM
Betty & Karl Schendel

Hi Leandro Pinto Fava, Thanks heaps dude. That was totally spot on. The table in question had two system generated persistent indicies used to...

martin.bowes@ctsu.ox.ac.uk

09-30-2005 05:49 AM
martin.bowes@ctsu.ox.ac.uk

Good morning, Setup. 1/Unix server running Ingres 2.6. On solaris 9. 2/Image server running OpenROAD 4.1 on windows 2000. It uses a...

Zoe

09-30-2005 04:26 AM
Zoe

Ingres SPARC SOLARIS Version II 2.6/0305 (su9.us5/00) login Has anyone had experience with this error...? E_QE0258_ILLEGAL_XACT_STMT A...

Gareth Williams

09-29-2005 10:40 AM
izena@mixmail.com

I am unable to kill two sessions that iimonitor marks them as: cs_state: CS_COMPUTABLE cs_mask: CS_DEAD_MASK,CS_IRPENDING_MASK I have tried: -...

izena@mixmail.com

09-29-2005 07:07 AM
izena@mixmail.com

I was wondering what real-world uses there are for visual DBA? I am thinking in terms of monitoring large, reasonably stable, production systems,...

Steve McElhinney

09-28-2005 04:06 PM
Emiliano

Gang, For many years Caribou has hosted the NAIUA website. The time has come to renew the domain. This puts Caribou at a crossroads. Caribou is...

Michael Leo

09-28-2005 10:53 AM
Chip Nickolett

errr... any know what this means? E_DM92CB_DM1P_ERROR_INFO An error occurred while using the Space Management Scheme on table: user_location,...

Gareth Williams

09-28-2005 08:36 AM
Gareth Williams

Part of our batch work requires exclusive access to a livedb, so we need a UNIX script to remove all user sessions from the database. We currently...

Steve McElhinney

09-28-2005 06:31 AM
Jean-Pierre Zuate

Hi folks We have Ingres/Net running on a development server (HPUX 10.20) and we need to access a production database running on a production...

Norman Woo

09-28-2005 04:47 AM
franky.leeuwerck@gmail.com

Hi Norman, The choice of ports is entirely up to you. Typically Ingres/Net is configured on the server to use the Installation ID as the listen...

Peter Gale

09-28-2005 01:06 AM
Peter Gale

Hi dudes, I'm running IngresII2.6/0305 patch 9892 on a linux box. A weekend process to modify tables in a database caused some segmentation...

martin.bowes@ctsu.ox.ac.uk

09-27-2005 08:39 AM
martin.bowes@ctsu.ox.ac.uk

Hi Martin, To workaround the problem you can try use 'set trace point QE70'. I have an open issue with CA where a similar problem happens in R3...

Leandro Pinto Fava

09-27-2005 08:34 AM
Leandro Pinto Fava

Hi Everyone, I'm migrating a VM<S IngresII 2.0 box to 2.6. Is there a reserved word checker for VMS II 2.6? I cant find one. Martin Bowes

martin.bowes@ctsu.ox.ac.uk

09-26-2005 12:23 PM
martin.bowes@ctsu.ox.ac.uk

Some of us who have grown up with GUIs use it :) As programmers though it's mainly just to test some SQL or look up information on tables etc. Toad...

dean.madden@thespiritgroup.com

09-23-2005 08:22 AM
Paul White

Hi Everyone, We have a row producing procedure which works perfectly well most of the time - don't you love it - but every now and then it fails and...

martin.bowes@ctsu.ox.ac.uk

09-23-2005 07:41 AM
martin.bowes@ctsu.ox.ac.uk

Hi Eoin, Have you run verifydb in report mode on the table cttbeog? Could you post a help table. Marty

martin.bowes@ctsu.ox.ac.uk

09-23-2005 07:03 AM
martin.bowes@ctsu.ox.ac.uk

Here's an interesting one. Not being sure how Ingres handles LOBs, I started snooping around. I noticed for long varchar, Ingres creates a catalog...

Laframboise André

09-22-2005 02:05 PM
Laframboise André

Hi André, It seems not. This is the complete info from iimonitor Session 000000010ABFC580:29757 (Os_user ) cs_state:...

Yo Mismo

09-22-2005 12:14 PM
Yo Mismo

Is the state NOINT ? Maybe it's rolling back. Sometimes that can take a while. Andre -----Original Message----- From: info-ingres-admin (AT)...

Laframboise André

09-22-2005 11:55 AM
Laframboise André

m00n, I have uploaded a DLL for PHP 5.0.5 to http://www.ingres.co.uk/files/php/php-5.0.5-ingres_dll.zip. You should know that the code has been...

Croker, Grant

09-21-2005 01:21 PM
Croker, Grant

Hello World I've recently installed Apache 2.0.54 and then installed ingres r3 3.0.2 using the ICE option. Has anyone managed to do this...

m00nminkey@hotmail.com

09-21-2005 12:05 PM
m00nminkey@hotmail.com

Hi, I'm getting an intermittent, non-reproduceable error when running the copydb command. Example copydb command and error included below....

Eoin

09-21-2005 08:12 AM
Eoin

I can see the headlines now:- "Ingres Guru accused of arson flees country" déjà...

David Richard

09-21-2005 07:25 AM
Tonyd08068@netscape.net

Hi If you are using the apache module that comes with Ingres then it will probably not work. It was built using Apache 1.3 and I believe is...

Grant Croker

09-21-2005 07:08 AM
Grant Croker

Dear All, I am using Ingres R3 Open Source on W2K platform . My problem : Boxes and Lines of Tables and Programs are not appearing perfectly, Instead...

N.V.Mandlik

09-21-2005 06:34 AM
m00nminkey@hotmail.com

If you set the connect_limit in CBF to 256 - do you really get 256 connections available to you, or are part of those used up by internal system...

Winkler, Teisha

09-21-2005 06:00 AM
m00nminkey@hotmail.com

I want to find all rows with a '\n' in a varchar column: where message_text like '%\n%' does not work as the backslash is not being interpreted...

colinhay66@hotmail.com

09-15-2005 06:32 AM
Roy Hann

Hello, Just a little help needed from the kind people who knows thoroughly about ingres, so I can proceed with new dbms settings to empower...

Patrick COURANT

09-15-2005 02:49 AM
Patrick COURANT

Does anyone know where I be able to view ukiua agenda? I've had registration leter, but doing not know what will being happening.

ULR77596

09-14-2005 06:10 AM
Roy Hann

Steve, See the following entry to which Roy helped me suss out...We quite happily remove server sessions with IMADB on a nightly basis...

Newlands, Graham

09-13-2005 07:39 PM
Newlands, Graham

Hi there, In case there are Ingres users in Scotland (or nearby !) who aren't on my mailing list, just a quick note to let you know that the...

Tonyd08068@netscape.net

09-13-2005 10:01 AM
Tonyd08068@netscape.net

Hi there, we are running an ERP application using IngresII 2.0. As a result of a routine job, the error.log reported the error below. 0000045c ...

Sam Haidar

09-12-2005 10:37 AM
Winkler, Teisha

I've noticed that there's no unsigned data types in ingres sql. This is a problem for us as we need to allow access to a table usign unsigned 64-bit...

morgan brickley

09-12-2005 09:41 AM
morgan brickley

Hi, I know most of the people on this list are active on most of the ingres forums and are very well experienced in ingres especially the likes...

Newlands, Graham

09-07-2005 09:01 PM
Newlands, Graham

I've been luck enough to walk into, and inherit, an site that is running an unsupported version of Ingres. My first week here has handed me three...

Rob McKenzie

09-07-2005 12:15 PM
Gibson Jonathan

I'd like to think I can set a default value to apply only to records inserted from this point on. If I wanted to modify old records which are...

Paul White

09-07-2005 09:30 AM
Betty & Karl Schendel

Hi Paul, I looked at: http://www3.ca.com/Solutions/ProductsAZ.aspx and I did not find it.

Johel

09-06-2005 03:01 PM
johelsouzafilho@uol.com.br

Hey Johel, I've been running Ingres clients on Win9x for years, connecting to both Unix and Windows Ingres servers. Clients include OpenROAD, Access,...

Paul White

09-06-2005 11:25 AM
Paul White

Hi All, Is there a way to connect Windows native apps running on Win9x workstations to IngresR3 running on WinXP Pro SP2 servers? I did all that I...

johelsouzafilho@uol.com.br

09-06-2005 10:29 AM
johelsouzafilho@uol.com.br

Hi all, I installed Ingres 3.0.2 on Win XP Pro. I created a table like this: create table mytab (col1 varchar(10) not null default 'WERT', col2...

Gerhard Hofmann

09-06-2005 10:10 AM
Betty & Karl Schendel

Thanks to all who responded previously to my request for help. I have now resolved the issue. Hurrah. The problem lay in the fact the underlying...

jeffrey.duffy@gro-scotland.gsi.gov.uk

09-06-2005 08:06 AM
jeffrey.duffy@gro-scotland.gsi.gov.uk

Hello, I have noticed that my ESQLC connection to an Ingres database works asynchronously. Is this the default behavior? When issuing dozens of...

Walter Quirtmair

09-03-2005 11:19 AM
Roy Hann

Hi Everyone, I'm running IngresII2.5 on a true64. I've just noticed for the last few days that a logstat shows a status line with the message...

martin.bowes@ctsu.ox.ac.uk

09-02-2005 05:01 AM
Roy Hann

I'm still waiting for the first Ingres trojan/virus. -----Original Message----- From: info-ingres-admin (AT) cariboulake (DOT) com On Behalf Of Roy...

Paul White

09-01-2005 09:12 PM
Paul White

I am writing a proposal and I got bored, so I dropped in to see how the inmates were doing over in comp.databases.theory. As usual the nurses...

Roy Hann

09-01-2005 10:56 AM
Roy Hann