I am new to Ingres, I am sure this must be an old issue but I am having trouble finding a solution. Using a 9.2 Legacy Ingres DB, I cannot get...

Ingres Forums

Yesterday 01:57 PM
Ingres Forums

We’re working to an understanding that there is an absolute table limitation of 8.3m pages (approximately 16Gb) . we have a customer who is now...

Ingres Forums

Yesterday 12:55 PM
Ingres Forums

On Tue, 31 Jan 2012, Paul White wrote: This may have been it!. I made user ingres owner of /ca_lic and everything in it except the CAMtype file,...

Lucky Leavell

01-31-2012 08:33 PM
Lucky Leavell

I just noticed that ESQLC insists that the (normally optional) keyword TABLE is mandatory in COPY TABLE foo ( ...) FROM .... i.e: E_EQ0070 Missing...

Roy Hann

01-25-2012 12:32 PM
Karl Schendel

Hi James, You are correct in your reading of *current* DUCET tables but as Kristoff said 9.2 Ingres is based on an *older* DUCET which did collate...

Dennis

01-24-2012 04:24 AM
Kristoff

Hi All, Can table procedures (or row producing procedures) use the execute procedure statement? Unless I'm doing something wrong (which is odds on)...

Martin Bowes

01-22-2012 03:50 AM
Roy Hann

http://www.linkedin.com/jobs?viewJob=&jobId=2431822 -- Roy UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012. The latest...

Roy Hann

01-20-2012 09:46 AM
Roy Hann

Hi All, In a DEP if an error occurs then a certain set of events occur. Things like: * no byref parameters are updated, * a...

Martin Bowes

01-20-2012 06:32 AM
Roy Hann

Hi All, Given a directly executed procedure has a possibility of executing code which will cause an error, how do I suppress the error message? I...

Martin Bowes

01-20-2012 05:47 AM
Roy Hann

Hi All, Can table procedures (or row producing procedures) use the execute procedure statement? Unless I'm doing something wrong (which is odds on)...

Martin Bowes

01-20-2012 04:38 AM
Martin Bowes

I've recently been on the look-out for news about Ingres Geospatial following the broad hints about the likely timeframe for delivery that were given...

Roy Hann

01-18-2012 09:44 AM
Emma K. McGrattan

Global Business Intelligence (BI) software vendor, Yellowfin, has released a new white paper that explores the need for, drivers and potential...

janette.pelletier@yahoo.com.au

01-11-2012 07:47 AM
janette.pelletier@yahoo.com.au

I could just try this to see, but I'm feeling lazy and someone probably knows the answer. If I write a query with one or more common table...

Roy Hann

01-05-2012 03:26 AM
Martin Bowes

Anyone know what iiridxtemp is for? Marty

Martin Bowes

12-14-2011 02:43 AM
Ingres Forums

I have just set up an Ingres 10.1 installation on a FC11 Linux box. The Ingres installation have any issues and Ingres starts up without any issues....

Dennis

12-12-2011 12:14 PM
Dennis

So here is the latest position.... Having fixed a few bugs in my configuration file editor... Realising that I just can't edit the hard-coded paths...

Martin Bowes

12-07-2011 05:19 AM
Martin Bowes

Hi Karl, Hey remember I said that I'd try the 'brute force and bloody ignorance approach' to editing the location paths embedded into the journal...

Martin Bowes

12-01-2011 08:53 AM
Martin Bowes

Hi All, I would have to agree with Karl's summation. I would also fully endorse the symlink method, I've used it extensively on UNIX systems and...

Ingres Forums

11-30-2011 07:35 AM
Ingres Forums

Hi, I have some Embedded SQL Ada code that I need to preprocess so that I am able to use it in an Ingres database that I am creating. I...

Jamie Everest

11-29-2011 08:16 AM
Ingres Forums

Hi Karl, Looks nasty, I'll go for the 'brute force and bloody ignorance' option...which has always been a personal favorite. A simple program can...

Martin Bowes

11-29-2011 08:08 AM
Martin Bowes

Hi All, Yes a table/index create has a hard coded path in it... Heres a quick auditdb -a Fcreate : Transaction Id 00004e3250108720 File...

Martin Bowes

11-29-2011 06:58 AM
Karl Schendel

Hi Andre, I'm using a Perl program with a cunning set of sysread/syswrite routines toget the data using unpack and then write it back after...

Martin Bowes

11-27-2011 01:43 PM
nikosv

Hi group, Is there any way to list the sessions currently connected to an Ingres installation that connected via the Ingres Data Access server...

Martin Crouch

11-17-2011 04:25 PM
Chris

Hi We have numerous batch jobs that run each night. Some jobs might run weekly. In the course of the week there are times when the batch jobs...

seldom isnice

11-07-2011 10:57 AM
Ingres Forums

Hi, The Queensland Ingres User Group (that's Queensland in Australia) is hosting a visit from John Ryan (the Asia Pacific Marketing Manager...

Qld Ingres User Group

11-03-2011 12:48 AM
Qld Ingres User Group

On Nov 2, 9:47*am, David Brooks <dbro... (AT) visionsystemssoftware (DOT) com> wrote: Both Ingres/Star and the Microsoft SQL Server Gateway...

Chris

11-02-2011 12:40 PM
Chris

Hi All, OK heres an interesting one.... I have an insert rule on a table. The rule is a statement level rule. The table in question is prone to...

Martin Bowes

11-02-2011 09:33 AM
Martin Bowes

On Nov 2, 2011, at 7:48 AM, Martin Bowes wrote: Oops. I guess this is one situation where some sort of multiple or nested transaction might...

Karl Schendel

11-02-2011 07:39 AM
Martin Bowes

Hi All, I have a database procedure which uses a for loop to control a large amountof processing. The body of the for loop has places where status...

Martin Bowes

11-02-2011 07:24 AM
Roy Hann

Hi All, I have a database procedure which will produce messages. In DBI how do I execute the procedure and trap the messages? Martin Bowes

Martin Bowes

11-01-2011 06:03 PM
James K. Lowden

We have rather a lot of OpenRoad Code. Our DB Admin likes it a lot. It works fine but I'm expecting a demand for access from non-PC devices. I'm...

David Fetrow

11-01-2011 02:23 PM
David Fetrow

If you just want 1 or 2 Macs to have that functionality with VMware Fusion, Parallels or the free Oracle Virtualbox. They all run Windows on a Mac...

David Fetrow

11-01-2011 02:13 PM
David Fetrow

I'm getting acquainted with my new Mac and would like to try putting Ingres on board. Is there a recent distribution available or do I need to build...

Paul White

10-31-2011 10:26 AM
Ingres Forums

I think the name compares in dmu create use MEcmp rather than collation compares, but I couldn't rule it out completely without a code audit. I do...

rthdavid

10-31-2011 09:56 AM
rthdavid

Hi Ian, My vi won't do ^K but my vim will! In vi and xvile I've found that ^V is the way to go. .. By decimal value: ^Vnnn (with 000 <= nnn <=...

Ingres Forums

10-29-2011 03:01 AM
Ingres Forums

Ingres 10 seems to be available for the usual range of platforms except I see nothing yet for this version running on OpenVMS. Does anyone know why...

Ingres Forums

10-28-2011 06:12 AM
Ingres Forums

I'm getting an error from this: * select * from points p * where not exists ( select * * from spent_points sp * ...

Artemus Ward

10-26-2011 08:33 PM
Ingres Forums

An interview with Roy : http://www.i-programmer.info/professional-programmer/i-programmer/3231-ingres-becomes-actian-some-questions-answered.html

nikosv

10-26-2011 03:29 PM
nikosv

Yes, we have an Ingres 10 for VMS Integrity port on our roadmap. The port will be based on 10.0.1 and will be available in 2012. We have been...

Emma K. McGrattan

10-24-2011 04:18 PM
Ingres Forums

Hi All. With Ingres 10 on windows...where do I find the API stuff? I thought it was iilibapi.lib. Martin Bowes -----Original Message----- From:...

Martin Bowes

10-21-2011 11:55 AM
Ingres Forums

Hi All, Trying to install VW1.6 with a charset of ISO88591...and much to my horror I find out that this is not possible. In fact its documented that...

Martin Bowes

10-21-2011 02:37 AM
Ingres Forums

Oh and thanks for the suggestion I was 90! BTW the card had hugs and kisses on it ... but who wrote 'yick'? I bet it was Magda! That's the sort of...

Lee

10-20-2011 09:42 AM
Ingres Forums

FaceBook? How the hell did that end up there? Marty -----Original Message----- From: Paul White Sent: 23 September 2011 13:40 To: 'Ingres and...

Sørensen.Henrik Georg HGS

10-19-2011 01:03 PM
michaelnewport@yahoo.com

Yellowfin, the leader in easy-to-use Business Intelligence (BI), has been recognized in Gartner’s annual Who’s Who in Mobile BI report. The 2011...

Jan

10-18-2011 08:51 AM
Jan

Hi Kevin, I managed to make a test case yesterday and attach it to issue 152671. Christian Challot has picked it up. As you mentioned, I had to...

Martin Bowes

10-12-2011 03:40 AM
Martin Bowes

PSD to XHTML - Xhtmlchamps - provide psd to xhtml/html, cms, joomla, wordpress, drupal, vbulletin, phpbb conversion, psd to xhtml/css conversion...

xhtml champs

10-12-2011 03:06 AM
xhtml champs

Hi Martin, Typically with these parallel thread issues one of the threads has finished and tidied up before the unfortunate remaining thread...

Kevin Smedley

10-11-2011 06:06 AM
Kevin Smedley

Hi All, On Ingres II 10.0.0 (a64.lnx/132)NPTL + p14139 We have a procedure which when we execute it several times in succession fails with a...

Martin Bowes

10-10-2011 09:39 AM
Martin Bowes

Hi All, OK, I'm a little bit thick I grant but...why isn't this working? $sth = $dbh->prepare("execute procedure test_proc(a = ?)"); $a =...

Martin Bowes

10-07-2011 12:31 PM
Chris

Hi All, Continuing my investigation of table procedures....how do you raise an error? Should you? Here's an example. create procedure...

Martin Bowes

10-05-2011 08:49 AM
Martin Bowes