Today I am prating on about query flattening: http://community.ingres.com/forum/blogs/rhann/61-flattening-query.html -- Roy UK Ingres User...

Roy Hann

03-30-2010 07:29 AM
Roy Hann

Hi, just to explain the printqry output: printqry measures the server, this explains, that the figures for the query via client or directly to the...

hans.weisenberger@mmm.com

03-27-2010 07:51 AM
Rob Leather

1.4TB and still unloading. It looked so small and cute all scrunched up in the VectorWise table space.... To while away the time I've done another...

Roy Hann

03-26-2010 07:42 AM
Roy Hann

I've not posted anything on my VectorWise blog for a few days but today is mostly going to be spent waiting for my database to unload so I...

Roy Hann

03-26-2010 04:34 AM
Roy Hann

In 9.3 there is ingvalidpam which supports LDAP/PAM integration. I can pass along the how to if anyone is interested, along with the how to for...

Greg Wilding

03-25-2010 01:33 PM
Paul Mason

Hello, we are working with an "old" Ingres II 2.6 and i wanted to create a new db user with "select" rights on 3 databases, so i started to create a...

Johannes

03-24-2010 04:07 PM
Johannes

INGRES REPORT Copyright (c) 1981, 1998 Computer Associates Intl, Inc. Reading report specifications and preparing query . . . E_OP03A2 consistency...

ajay_chadha@ttps.ntpc.co.in

03-24-2010 11:06 AM
Karl Schendel

I am getting to the last draft of the 4-th edition of SQL FOR SMARTIES. If anyone has some good SQL programming tricks they would like to see...

--CELKO--

03-19-2010 02:57 PM
--CELKO--

I will be out of the office now until Friday 19th March, and will respond to your e-mail as soon as I can upon my return. If the matter is urgent,...

Rob Leather

03-18-2010 11:40 AM
Rob Leather

I just posted a piece on VectorWise SELECT statements (and other oddments)...

Roy Hann

03-18-2010 11:22 AM
Roy Hann

Registrations have closed for the OpenROAD code sprint in Manila with 46 confirmed customers and partners attending (not including Ingres...

Paul White

03-17-2010 05:38 PM
Paul White

I've posted another item about getting started with vectorWise at http://community.ingres.com/forum/blogs/rhann/53-hello-world.html -- Roy UK...

Roy Hann

03-16-2010 05:33 AM
Paul White

I've now posted some notes on my first 20 minutes using...

Roy Hann

03-16-2010 05:25 AM
Roy Hann

Before reporting how I've been getting on with VectorWise I need to set out my objectives. Because of limited resources there was never any way I was...

Roy Hann

03-15-2010 06:18 AM
Roy Hann

I've been using a very early alpha-release of VectorWise for the last couple of weeks, and with a rumoured beta-release just around the corner I...

Roy Hann

03-15-2010 06:10 AM
Roy Hann

I have been informed that Chris Date will be running a two-day seminar in Scotland in May entitled "SQL and Relational Theory--How to Write Accurate...

Roy Hann

03-11-2010 04:30 AM
Roy Hann

Hi All, Anyone seen anything like this...Be warned that the query may produce a SIGSEGV which may harm your installation... 1. On a remote...

Martin Bowes

03-11-2010 04:05 AM
Kristoff

Dear Valued Ingres Customer: Information security is of utmost priority to Ingres. A new vulnerability has recently been identified in Ingres 9.1,...

Pamela Fowler

03-11-2010 03:53 AM
Kristoff

Hi Everyone, UK IUA is pleased to announce that the call for Community Award Nominees is now open. The UK Ingres User Association Conference...

Martin Bowes

03-10-2010 12:34 PM
Ingres Forums

Hi Everyone, I need an assistant! And the Boss has agreed to fund an extra DBA position! So if anyone would like to check it...

Martin Bowes

03-10-2010 06:42 AM
Martin Bowes

Hi All, Where can I find a structure which describes the IINODE_name file? IILOGIN_name would also be handy.

Martin Bowes

03-09-2010 03:39 PM
Ingres Forums

Hi All, I'm in the wonderful position of needing to do an audit trail based recovery of a data deleted from a table about a month ago. And Yes...

Martin Bowes

03-05-2010 03:49 PM
Ingres Forums

It seems another Ingres book was published at the end of January...

Roy Hann

03-05-2010 12:13 PM
Alexander Thiem

I will be out of the office now until Thursday 5th March, and will respond to your e-mail as soon as I can upon my return. If the matter is urgent,...

Rob Leather

03-04-2010 02:56 AM
Rob Leather

Couple of interesting articles on NoSQL this week NoSQL in the real world http://news.cnet.com/8301-13846_3-10451248-62.html Open-source evolution...

Paul White

03-03-2010 07:25 AM
Roy Hann

The Yellowfin BI team have produced a new paper on "Location Intelligence", the mashup of BI with GIS Extract More than 70% of your organizational...

JTP PR

03-03-2010 05:01 AM
JTP PR

Hot off the press. http://green.tmcnet.com/news/2010/03/02/4649834.htm Mentions two partners using the Cloud "software as a service" model Terry...

Paul White

03-02-2010 09:57 AM
Roy Hann

Hierarchical databases? Now that is new ... :) - Personally, I'm hoping for a document/relational database with forward and backward-chaining...

Sean Thrower

03-02-2010 09:37 AM
Roy Hann

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

03-01-2010 08:43 AM
Mia

When trying to compile an ABF application on a Red Hat Enterprise Linux Server release 5.4,Intel(R) Xeon(R) and II 9.1.2 (int.lnx/ 100)NPTL, I get...

nikosv

03-01-2010 07:01 AM
nikosv

This is weird. Earlier today I moved the directory containing II_SYSTEM (/opt) to a new drive. Afterwards I was able to start Ingres just fine...

Roy Hann

03-01-2010 05:14 AM
Roy Hann

Hello all, I'm trying to rollforward incrementally from an old checkpoint because I'm missing checkpoint 6. This command is rejected rollforwarddb...

Paul White

02-26-2010 12:57 PM
Michael Flower

Hi All, Try this.... sql bowtest << SQL_END

Martin Bowes

02-26-2010 09:38 AM
Roy Hann

Hi all, in my opinion the new MSI-based 9.x installation system is much worse than the old one from Ingres 2.5/2.6 when it comes to uninstallation...

Ingres Forums

02-25-2010 01:22 PM
Ingres Forums

Hi Greg, You might want to ask this question at the Ingres forum and you will get a much better response. The address I use is info-ingres (AT)...

Paul White

02-22-2010 08:17 PM
Michael Touloumtzis

This webcast is open to all interested community members. If you install, configure or work with Ingres and related products be sure to jump in...

Paul White

02-12-2010 07:17 AM
Roy Hann

Basing it on dm0c.h etc is obviously the Opensource thing to do! But at the moment I'm hacking a perl module togethor ... as proof of concept if...

Martin Bowes

02-11-2010 04:58 AM
Martin Bowes

Hi All, LO, LO, LO, whats all this then? I've been getting occassional SIGSEGVs whose line 0 is:

Martin Bowes

02-10-2010 12:15 AM
Ingres Forums

Hi All, I have a windows installation (I'm sorry...) II 9.2.0 (int.w32/143) + p13595. The system just bevaed in a very strange manner over...

Martin Bowes

02-08-2010 09:27 PM
Paul White

There's a significant posting on the Ingres forums that doesn't seem to have been posted here (yet): "Two webcasts are scheduled to expose Ingres'...

Roy Hann

02-07-2010 01:01 AM
Ingres Forums

Hi all, I have always hated that "user does not have privileges in the config.dat" problem when it comes to changing vnode entries on...

Gerhard Hofmann

02-05-2010 07:13 AM
Gerhard Hofmann

I have always told people that the only way to turn off strict SQL-92 compliance is to de-install and re-install Ingres. But is that true? Assuming...

Roy Hann

02-02-2010 07:06 AM
Roy Hann

Hi Karl, Thanks for that. My message is generated on the first pass but not the second. On the second pass the E_US0A94 is generated. No idea why...

Ingres Forums

02-01-2010 07:00 AM
Martin Bowes

Has anyone out there done any work on an Ingres-specific Handle object for perl DBIx? -- Roy UK Ingres User Association Conference 2010 will be on...

Roy Hann

01-29-2010 09:06 AM
Roy Hann

We are trying to upgrade to Ingres 9.2 and looking for a stable patch version. We are currently using patch 13667 (the newest) on a Solaris 10...

jimmythegeek44720@yahoo.com

01-28-2010 04:05 PM
Ingres Forums

I use the computer and the Net on a regular basis but I don't know a whole lot about it all, especially when it gets technical. I have an Acer...

Virgina Hernandez

01-28-2010 10:05 AM
Ingres Forums

For easier "alter table" in our Company I've developed this ABF/4GL-program that handles Issues for a number tables that needs to be changed since...

Roy Hann

01-27-2010 09:37 AM
Sørensen.Henrik Georg HGS

.. Ingres 2.6/0305 on AIX 5.2 6 x DBMS's running OS threads. We are getting MUTEX problems on one of our busy (1800+ user) systems. Typically one...

Steve McElhinney

01-25-2010 07:55 AM
Steve McElhinney

Hi Roy, They were introduced with the support for CLOBS in 9.2.0 as it provided a more LOB efficient means of saying: lob LIKE pata OR lob LIKE...

Ian Kirkham

01-25-2010 04:38 AM
Ingres Forums

Hi All, Since upgrading to 9.2.0 (a64.lnx/143)NPTL + p13643 we've had a bizarre situation with reading longs with a cursor in an API program. ...

Martin Bowes

01-20-2010 08:18 AM
Martin Bowes