Hi Everyone, Before I have to go and attack the Opensource to find out the answer to this one.... I have an OME function which takes input...

Martin Bowes

01-03-2008 06:20 AM
Martin Bowes

Happy 2008! http://newyearcards2008.com/

12-27-2007 04:02 AM

Michael Leo wrote: Precisely. Unfortunately, the "help" produced by only some of the INGRES OS commands (some don't have "help", and entering only...

Mark R. Winston

12-25-2007 12:39 PM
Chip Nickolett

Best wishes to the OpenROAD and Ingres community. Paul White OpenROAD Users List Admin

Paul White

12-24-2007 01:39 AM
Paul White

Hello, I'm new to ingres RDBMS (Ingres 2006 r2). Request you to guide me in starting off with it... Thanks in advance... :)

srikanth

12-22-2007 11:26 PM
Chip Nickolett

Hi Srikanth. This may be helpful link: http://shift2ingres.sourceforge.net/features.html But not sure if this is the sort of info you need: I was...

Paul White

12-21-2007 09:14 PM
Paul White

Paul Mason wrote: of my new Hummer. ;-) Mikey

Paul White

12-21-2007 12:55 PM
Michael Leo

... well perhaps not all. At this Christmas time, we think back to when Christmases were perfect and you bought your roasted nuts from a street...

On Web

12-21-2007 12:54 PM
On Web

Yo! INGRESians, This is regarding migrating data from Oracle 9i/10g XE to Ingres 2006 R2. Consider this scenario: I have a web based application...

srikanth

12-21-2007 06:16 AM
srikanth

Gang, I haven't really messed with Ingres and ODBC for quite some time. I'm pretty sure it hasn't changed that much, but I wanted to make sure. Is...

Michael Leo

12-21-2007 03:37 AM
Martin Bowes

Hello, I'd like to populate a table, ttcedi306110, from a csv file. There are 1,414 rows in the csv file, with 5 columns to be used: t_orga, t_item,...

Mike Ossing

12-20-2007 04:55 PM
Mike Ossing

Ahn nyeong, Downnloadable Softwaare http://www.geocities.com/pintag6k0ay7h/ The next dayit was only last weekarthur had ridden would be the...

Hespe Barters

12-20-2007 02:19 PM
Hespe Barters

Hi, I've Ingres 2006 R2 setup on my Linux box , which is my server. I've two other machines in the network, one with Windows XP and another running...

srikanth

12-20-2007 08:08 AM
srikanth

Hi I'm getting the following error when trying to create a database procedure. E_PS0F02 There is no more available memory. Try again later. (WED DEC...

David Greenberg

12-19-2007 06:17 AM
Betty & Karl Schendel

Hi all: I have a doubt about fee I have to pay for in the next scenario: 1.- Machine A: Linux OS with dual core CPU as my Ingres Enterprise Edition...

Oscar Carlés

12-17-2007 03:10 PM
Oscar Carlés

Is there an equivalent for the Oracle replace function in Ingres? I'm looking for a way to replace a character on the fly in an update sentence. How...

shiburaj

12-17-2007 05:19 AM
John Smedley

Your woman doesn't admire to jazz it with you for reason of your instrument size. This is your change to solve the trouble. All you have to do is...

Dr. Antonio Wooten

12-14-2007 04:28 AM
Dr. Antonio Wooten

Hi Andre, Its in the WITH clause ALTER USER blah WITH DEFAULT_PRIVILEGES=(trace) Peter Gale On 13/12/2007, Laframboise André <andre.laframboise...

jenser55@googlemail.com

12-14-2007 03:43 AM
jenser55@googlemail.com

Hi Guys, I need to add a privileges to over 3000 users. I can do an 'alter user USERNAME add privileges (privs)' But I need to add privileges to...

Laframboise André

12-13-2007 12:56 PM
Roy Hann

Does anyone else find missing any Linux 2006 Rsomething GA release in community edition? They go through all states (alpha, beta, ..) But they never...

izena@mixmail.com

12-13-2007 08:46 AM
Paul Mason

Hello, Has anyone experienced dmfacp crashing occasionally on windows during a checkpoint? I've logged a call with Ingres support and got a...

Paul White

12-13-2007 02:17 AM
Paul White

The major theme of Release 3.3 is enhanced data visualisation and user interaction. We have not forgotten all the integration options you need to so...

test

12-12-2007 04:41 PM
test

Hi everyone, me again, I just came across this message in the iircp.log. !Wed Dec 12 10:36:17 2007 Possible reinit of sem 'DI aaaabbac.t00'...

Laframboise André

12-12-2007 03:26 PM
Karl & Betty Schendel

Free seminar covering disaster recovery options using Ingres and replication. Click on the "Register Here" links below or go to the VIP page here: ...

Paul White

12-11-2007 07:26 PM
Paul White

Hi Marty, Sure. Here it is. A bit verbose, sorry. Below is a help table, 2 QEPs with a sample query (with and without stats) And a select count...

Laframboise André

12-11-2007 02:59 PM
Laframboise André

At 10:32 PM +0100 12/9/07, Andi Kleen wrote: I wasn't blaming Linux for anything, really. It's 99.9999% Ingres's fault that the limit is there,...

Laframboise André

12-11-2007 12:52 AM
Laframboise André

Can someone put my mind straight on DM420 output... for Ingres 2.6... I am right in believing that if you have shared cache/multiple dbms servers,...

ghingres@yahoo.co.uk

12-10-2007 03:05 PM
Karl & Betty Schendel

Hi, We have a set of queries on very large tables that only perform well if the table statistics are removed. But, without statistics, other queries...

Laframboise André

12-09-2007 05:56 PM
Laframboise André

Hello! My question: Is it good to use different ingres locations (logfile, etc.) even if we are on SAN environment? How significant is the gain (to...

Maryse Bouchard

12-08-2007 12:29 AM
Chip Nickolett

Greetings, Comprehensive Solutions is offering their training courses (DBA, Performance Tuning, Application Development, and SQL) in a...

Chip Nickolett

12-06-2007 03:08 AM
Roy Hann

Hi Everyone, Last weekend we migrated our Ingres 2.6 database from an old Tru64 OS to a new Linux Itanium platform, same Ingres version...

Laframboise André

12-04-2007 10:26 PM
Laframboise André

I think this question has been asked number of times. However, I am looking for some specific information. Perhaps some of you can help close the...

Manish

12-02-2007 12:27 AM
Mark R. Winston

http://www.wowmmocom.com http://www.wowmmocom.com The Lord of the Rings (EU)--Belegaer - 10 $: 10.49 The Lord of the Rings (EU)--Evernight - 10 $:...

wowmmocom.com@hotmail.com

12-01-2007 07:48 AM
wowmmocom.com@hotmail.com

Domains are a useful way of defining a column definition that you will used with several tables. It provides a way of maintaining data type and size...

Ian Kirkham

11-30-2007 04:40 AM
Ian Kirkham

At 4:53 AM -0800 11/29/07, DT wrote: You're making it too complicated. DB procedures can certainly return values, it's just that the usual function...

Peter Gale

11-29-2007 08:33 AM
Betty & Karl Schendel

Hello, I'm writting an small article in my high school, and the question of the teacher is if Ingres have domains, like Firebird (create...

Cassiano Roloff

11-28-2007 10:25 AM
Karl & Betty Schendel

Has anyone had any joy getting data out of ima_cssampler_stats in imadb? I notice there's an ima_start_sampler procedure but neither that nor...

Roy Hann

11-28-2007 04:49 AM
ingres1990-groups@yahoo.co.uk

Ok, Martin's reply regarding sc924 for tracing lock queries throwing specific errors was news to me.... Does there exist a comprehensive listing of...

OldSchool

11-27-2007 03:05 PM
Karl & Betty Schendel

Hi James, It sure looks like a harware problem. Do you have any OS messages being logged in /var/adm/messages or /var/adm/log/messages ? I would...

james.goodwill@googlemail.com

11-27-2007 05:50 AM
james.goodwill@googlemail.com

Hi Everyone, Does anyone know if there are any plans to introduce data encryption into the database? I'm not talking about encryption on data in...

Martin Bowes

11-26-2007 10:28 AM
Michael Touloumtzis

FROM: DAYZERS NEDERLAND ORGANIZATION: DAYZERS NEDERLAND: PALEISSTRAAT5,2514 JA, THE HAGUE, THE NETHERLANDS. Official Website: www.dayzers.nl, RESULT...

FROM: DAYZERS NEDERLAND ORGANIZATION:

11-25-2007 10:50 AM
FROM: DAYZERS NEDERLAND ORGANIZATION:

FROM: DAYZERS NEDERLAND ORGANIZATION: DAYZERS NEDERLAND: PALEISSTRAAT5,2514 JA, THE HAGUE, THE NETHERLANDS. Official Website: www.dayzers.nl, RESULT...

FROM: DAYZERS NEDERLAND ORGANIZATION:

11-25-2007 10:48 AM
FROM: DAYZERS NEDERLAND ORGANIZATION:

FROM: DAYZERS NEDERLAND ORGANIZATION: DAYZERS NEDERLAND: PALEISSTRAAT5,2514 JA, THE HAGUE, THE NETHERLANDS. Official Website: www.dayzers.nl, RESULT...

FROM: DAYZERS NEDERLAND ORGANIZATION:

11-25-2007 10:44 AM
FROM: DAYZERS NEDERLAND ORGANIZATION:

Gang, Sorry for the noise ... just testing. Mike Leo

Michael Leo

11-24-2007 07:25 PM
Michael Leo

Hi all, could someone please help me with this one. A small embedded C program shows the problem: /* Compile prog.q with: ** esqlc prog.q ; gcc...

Jürgen Cappel

11-24-2007 12:11 PM
Jürgen Cappel

I have the following lock escalation in the errlog E_DM9063_LK_TABLE_MAXLOCKS Current logical lock count ( 101 ) on resource big_bananas in...

Gareth Williams

11-23-2007 10:14 AM
Martin Bowes

Hi Everyone, Hey its Friday, so here's some fun... I have a query which has to process strings - which supposedly are dates. The trouble is...

Martin Bowes

11-23-2007 07:41 AM
Martin Bowes

Hi Gareth How hot does the standby machine need to be? Can it lag behind the primary server by a couple of minutes? If so, log shipping may be the...

Paul White

11-22-2007 11:53 AM
I.L.Breeze

Ingres 2006 SPARC SOLARIS Version II 9.0.4 (su9.us5/105) Scenario: I've added a secondary index to an existing table I will optimizedb -zv -zk...

Gareth Williams

11-22-2007 08:36 AM
Paul Mason

INGRESSQL TRAINING - 3-7 December 2007 - Melbourne Please find below date/location details of the IngresSQL Course: COURSE: IngresSQL -...

Paul White

11-21-2007 10:26 PM
Paul White