dbTalk Databases Forums  

Sponsored Links


comp.databases.ingres comp.databases.ingres


Discuss in the comp.databases.ingres forum.



Post New Thread
Threads in Forum : comp.databases.ingres Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
I have two queries which when run standalone produce the correct results but when unioned produce extra rows. query 1 : select aa_qeshs=...
nikosv
07-24-2010 07:41 AM
nikosv Go to last post
2 43
What may be happening is the extra columns might reveal that you have eliminated rows in the original union. Try running the union with UNION ALL...
Ian Kirkham
07-22-2010 06:20 AM
nikosv Go to last post
2 33
Hi all, I've been experimenting with C2 security auditing and - thanks to some good KB documentation - have got it working very well. Now I am...
Paul White
07-21-2010 01:37 AM
Roy Hann Go to last post
1 33
On Jul 16, 2010, at 5:35 AM, Martin Bowes wrote: No, the IVW ingres-side code is a sort of pre-release 10 that is rather older. The beta level 10...
Ingres Forums
07-16-2010 10:35 AM
Ingres Forums Go to last post
6 243
Hi All, This sounds like a case for IMA. Given that we already have access to a lot of cache stats all we really need is a list of db_id, relowner,...
rthdavid
07-16-2010 04:24 AM
Martin Bowes Go to last post
5 232
Hi peeps, Just a test Sorry for inconvenience Uncle JL
Hampton, Jean Luc
07-16-2010 03:57 AM
Grant Croker Go to last post
2 174
Hi All, Silent/unattended installs of 9.2.1. can only take place if you use ingbuild -acceptlicense See...
rthdavid
07-15-2010 06:28 PM
Paul White Go to last post
1 1,149
We're migrating an old database from Ingres II 2.0 which contains many tables we believe are obsolete. Is it possible to ascertain when a table was...
NorthWalesYorkie
07-15-2010 03:04 AM
Ingres Forums Go to last post
3 44
Apologies fellow Ingres professionals, but I'm looking for Ingres work. Ideally I'm looking for a permanent post, but would consider long-term...
l_jackson
06-18-2010 02:59 AM
l_jackson Go to last post
2 235
________________________________ From: Corey Bouvier Sent: Friday, 12 September 2008 11:04 PM To: openroad-users (AT) sealion (DOT)...
Paul White
05-31-2010 07:57 PM
Ingres Forums Go to last post
2 201
On 26/11/09 20:22, Jean-Pierre Zuate, La Fage Conseil wrote: based frameworks such as Pylons and Turbo Gears....
2402
05-30-2010 09:05 PM
Ingres Forums Go to last post
4 405
Hi All, Has anyone got any experience with the createdb -rlocation_name flag? Care to share some insights? I've been hacking around trying to...
Martin Bowes
05-28-2010 09:31 AM
Martin Bowes Go to last post
2 219
Hi All, On 9.2 try this... First set up some data...
Martin Bowes
05-28-2010 08:15 AM
Karl Schendel Go to last post
1 177
Hi (Karl and others), "I'm forgetting something", perhap's : 1/ Both databases must have the same location name and area (due to aaaaaaaa.cnf...
Ingres Forums
05-19-2010 10:27 AM
Jean-Pierre Zuate, La Fage Conseil Go to last post
5 179
Is there way of checked thoroughly integrity of journal files, without actually run database recovery? Auditdb bekkons, but how exhaustive check...
Non scrivetemi
05-14-2010 12:24 PM
Ingres Forums Go to last post
2 207
Hi All, On II 9.2.0 (a64.lnx/143)NPTL + 13767 When I try: extenddb iidbdb -Uwork -lii_work_2
Martin Bowes
05-14-2010 09:02 AM
Paul Mason Go to last post
3 161
Hi all, a simple question I hope. If I have a journaled table with data compression enabled will records in the logging system & journal files...
David Stephens
05-14-2010 09:00 AM
Karl Schendel Go to last post
1 192
Hey experts, I'm getting a packed decimal overflow multiplying high precision decimals.š It seems I can't multiply two decimal numbers if the sum...
Paul White
05-13-2010 07:13 AM
Ingres Forums Go to last post
2 259
Hi All, I have an installation II 9.2.0 (a64.lnx/143)NPTL + 13556. On some databases, when catalogs are optimized (-zk -zc), the result...
Martin Bowes
05-13-2010 04:48 AM
Martin Bowes Go to last post
2 176
Hi, I have successfully used the attached SQL against imadb to find blocking sessions. In most up-to-date Ingres releases, for example 9.2.1 on...
Gerhard Hofmann
05-12-2010 04:46 PM
Karl Schendel Go to last post
2 204
Hi All, Does anyone have a demo of using nvarchar types with OAPI handy? I've looked in $II_SYSTEM/ingres/demo/api with no success on a...
Martin Bowes
05-12-2010 09:57 AM
Grant Croker Go to last post
3 224
Hi All, This monster got stuck in the optimizer overnight...at least 10 hours before I killed it off. I have no idea if it works or not, I don't...
Martin Bowes
05-11-2010 02:02 AM
Roy Hann Go to last post
3 191
Build 123 of Ingres 10.0 is now available on http://esd.ingres.com/ and is the first public release to support the column encryption feature. For...
Michael Touloumtzis
05-09-2010 09:41 AM
Mike Leo Go to last post
4 208
Hi All, Does anyone have a list of the environemnt variables that control the optimizer. I can't find anything in the SYS reference guide for 9.2...
Martin Bowes
05-07-2010 04:53 AM
Martin Bowes Go to last post
3 198
This seems somewhat counter-intuitive to me We have a Transaction table that contains 1 record per person per week, and holds a 5 year history We...
Tim Ellis
05-06-2010 05:18 AM
Ingres Forums Go to last post
7 300
Hello, this might help: http://community.ingres.com/forum/comp-databases-ingres/2990-re-ingres-2-6-cktmpl-def-file.html Jürgen
Jürgen Cappel
05-05-2010 06:52 PM
Newlands, Graham Go to last post
1 171
Hello, is this possible? How would I have to tweak the cktmpl.def file? Which compressing programm could be used (7-zip, RAR etc.)? Regards Gerhard
Gerhard Hofmann
05-05-2010 03:43 PM
Gerhard Hofmann Go to last post
7 199
Hello, The following is a call for participation in database research at the University of Toronto: http://bit.ly/alxhLm Participation takes 30-60...
Andrew Ross
05-04-2010 10:34 AM
Andrew Ross Go to last post
1 184
Hi all, As the subject says I'll be performing server maintenance on the machines that are behind (lists,code,inspect,lxr,bugs).ingres.com....
Grant Croker
05-03-2010 02:49 AM
Grant Croker Go to last post
1 178
Hi everyone, I'm having trouble installing IngresII 2.6 on an elderly Linux box. I get the message: gtar failed with exit code...
martin.bowes@ctsu.ox.ac.uk
04-29-2010 03:34 PM
Ingres Forums Go to last post
2 360
Hi John et al, Thanks for that reminder ... I'd forgotten. Marty -----Original Message----- From: John Smedley Sent: 21 April 2010 15:57 To:...
Martin Bowes
04-29-2010 11:38 AM
Roy Hann Go to last post
11 299
Hi All, Here's some fun...select first 0 * from iitables; Returns all the rows in iitables...Why are my users so inventive? They were...
Martin Bowes
04-28-2010 08:06 PM
James K. Lowden Go to last post
17 318
Long name support has been available for some time now in a special version of Ingres 10 community edition build 115. That support is now available...
Ingres Forums
04-28-2010 10:58 AM
Ingres Forums Go to last post
1 190
FYI. The problem was that I had II_NUMERIC_LITERAL set to float. ergo... select trunc(1.99,-1), trunc(1.99, 0), trunc(1.99,1); Is equivalent to...
Martin Bowes
04-22-2010 04:10 PM
On net Go to last post
8 252
This e-mail and any files transmitted with it are the property of the London Borough of Havering, are confidential, may be subject to legal...
Rob Leather
04-19-2010 01:14 PM
Roy Hann Go to last post
1 186
Good day! Help me, please. Solaris 10. Igres Sparc Solaris Version II 9.2.0(su9.us5/143)(patch13711). When I execute command INGMENU on database with...
Vera
04-13-2010 10:31 AM
Ingres Forums Go to last post
2 162
Hi All, I have a server which has thrown the following errors: E_DM927F_DCB_INVALID An error closing database ldb22 has made it unavailable by...
Martin Bowes
04-12-2010 05:11 AM
Martin Bowes Go to last post
2 118
Hi All, I have a table which has 5 system generated indexes. AFAIK only constraints which do not specify an index can have a system...
Martin Bowes
04-08-2010 10:05 AM
Martin Bowes Go to last post
3 101
Hi All, Has any got an explanation (or ideas) for this.... On a Linux box I have two vnodes, call them WIN and LIN. WIN points to a windows...
Martin Bowes
04-07-2010 08:10 AM
Martin Bowes Go to last post
4 116
"M Buckle" <markbuckle30 (AT) hotmail (DOT) com> wrote What? Are you an old RATFOR programmer? :-) I must say I do rather like the...
Roy Hann
04-06-2010 04:43 PM
Ingres Forums Go to last post
1 327
Hi All, Why are my programmers so invetive? I have a Linux box running: II 9.2.0 (a64.lnx/143)NPTL + 13695 It has a vnode (call it XX) pointing to...
Martin Bowes
04-06-2010 08:45 AM
Paul Mason Go to last post
4 91
So I did this instead: http://community.ingres.com/forum/blogs/rhann/62-baseline-results-part-1.html My wife *was* pleased. ;-) -- Roy UK Ingres...
Roy Hann
04-03-2010 11:57 AM
Ingres Forums Go to last post
1 121
We implement our SQL queries in our applications using embedded SQL/C and the esqlc precompiler. We now have serious performance problems on the...
Christopher
03-31-2010 05:58 PM
Chris Go to last post
3 199
I am sure I recently saw a page on the wiki listing the new features introduced in each rev of Ingres going back...a long way. I am totally unable...
Roy Hann
03-31-2010 01:42 PM
Ingres Forums Go to last post
6 108
Hi All, The round() function in 9.2 has got me stumped to the point I think it's a buggy version.... Has anyone got a quick primer with...
Martin Bowes
03-30-2010 07:38 AM
Martin Bowes Go to last post
4 104
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 06:51 AM
Rob Leather Go to last post
4 222
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 12:33 PM
Paul Mason Go to last post
17 423
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 03:07 PM
Johannes Go to last post
22 691
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 10:06 AM
Karl Schendel Go to last post
5 378
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 04:38 PM
Paul White Go to last post
1 105
Post New Thread

Display Options
Showing threads 351 to 400 of 2491
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.