Stack Overflow
Stack Overflow

Questions tagged [ingres]

Use this tag for Ingres / Actian X questions. The Ingres v11 RDBMS is now known as Actian X and in addition to supporting OLTP, also supports analytic workloads with X100 tables and Vector engine, making it a hybrid OLTP and analytic database.

The Ingres 11 RDBMS is now known as Actian X and in addition to supporting OLTP, also supports analytic workloads with X100 tables and Vector engine, making it a hybrid OLTP and analytic database.

Actian X combines a record breaking analytic engine with rock solid OLTP to enable enterprise applications with both OLTP and analytic features. The X100 component, from Actian’s Vector analytic database, lets you store Ingres and/or external data in X100 tables, which are processed using the specialized X100 engine, allowing faster performance for analytical database tasks. OLTP and analytic workloads can be run together and the queries and access methods you’re already using can also be run against the X100 data.

Ingres v11 / Actian X product documentation is available here.

Ingres / Actian X customer support forum is here.

151 questions
0
votes
1 answer

Connecting to Ingres and Oracle from C

My client given code is programmed in c language to connect to Ingres Database in Unix environment. This code is using API's such DBconnect(), DBExecSQL,DBRollback().... I want to confirm that whether these API's are Ingres database specific…
user566
  • 97
  • 1
  • 12
0
votes
2 answers

Counts for different criteria in one row per field

I have the following SQL select c.course_code, c.course_description, ri.defin, rm.defmaybe, ro.defout from applicant a inner join preference p on a.ref_num = p.ref_num and p.institution_code = 'UT' inner join course c on p.course_code…
Mia
  • 23
  • 5
0
votes
1 answer

Catch sql query result in file shell

I'm trying to capture the output of a sql query launched via script. The script : #!/bin/bash sql articledb <<< "select toppapier from table \g \q" The output: INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation Ingres Linux Version II 9.2.0…
Matieu
  • 39
  • 2
  • 10
0
votes
1 answer

Mapping one Entity class to two different databases (Oracle and Ingres)

I am newbie to ORM and JPA. I have a table called Table1 in Ingres. I need to copy Table1 from Ingres to Oracle. I have been successful in connecting to both databases. Is it possible to create only one Entity class called Table1 and then do this…
Pujan
  • 1
0
votes
1 answer

Using Sql parameters on Ingres Database error

Exception: Local variable/parameter ':your-param-name' can only be used within a database procedure. In MSSQL, the param character is @. In INGRES Database, really is : ? I cannot find official documentation for that... SELECT * FROM MyIngresTable…
Renato Mestre
  • 46
  • 6
0
votes
1 answer

Ingres SQL date difference

I need to find the difference between two dates in minutes. Here is the select statement I have been using: select date ('05.04.2017 11:12:00') - date('now'); It is returning -4 mins -21 secs but I want to see just 4 minutes. I could not find…
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
2 answers

capture process cannot access

There is the following line command: statdump -zdl %db% > "%ckpdb_dir%"\statdump_%db%.log the result of the Statdump is sent to the log file, but I would like that if there is some error, for example that the statdump is being used already by…
user461487
0
votes
1 answer

Error in Ingeres E_SC0520_SCS_BAD_DBV SCS_INPUT invalid DBV detected:

Please need help! Issuing this problem for couple days cannot understand and find any useful information on how to resolve it I am getting this error when I am trying to run procedure with call from php E_AD2005_BAD_DTLEN ADF routine found…
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
0 answers

Ingres appears to have a slow performance for inner joins in a subquery after update from version 10.0 to 10.2

Today a production issue was reported on a large corporate system that I work on whereby an export was taking over 4 hours to run. This export was previously tested on similar or larger amounts of data and usually completed in under 10 minutes. …
Chris
  • 678
  • 4
  • 6
0
votes
1 answer

Unexpected END OF FILE while processing row

Getting the following error when copying an input file into an empty db table. The input file only has 56732 rows, however I am getting an error on row 56733: continue * * * * * * * * * * copy table temptable ( abc = c(3), bcao = c(1), cba …
TCP
  • 33
  • 2
  • 8
0
votes
2 answers

bat file executing files against DB from folder

I have Ingres DB and I keep all my procedures files in folder, if i need to rebuild them on DB. There is a lot of procedures which related to eachohter (called one from another), so that mean ai have to run some proceudre first then run other. …
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
1 answer

Ingres DB error E_PS055B CREATE PROCEDURE

E_PS055B CREATE PROCEDURE: You may not create database procedure 'proc_name' because database procedure 'proc_2' invoked by it is dormant. Any database procedure attempting to invoke a dormant database procedure is itself dormant,…
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
1 answer

Extract days covered in contiguous period over multiple rows

I have data in an Ingres 10 table like the below :- ref, from_date, to_date A, 01/04/2016, 30/04/2016 A, 30/04/2016, 20/05/2016 A, 25/05/2016, 30/05/2016 B, 01/04/2016, 01/09/2016 B, 01/10/2016, 20/02/2016 The to_dates are exclusive-to. So some…
Ben Hamilton
  • 949
  • 3
  • 10
  • 21
0
votes
2 answers

Select address ignoring blank columns

Ingres DB, property data as below addr1 addr2 addr3 addr4 postcode Some address are short and so have no values in addr3 or addr4. E.g. addr1 : 14 Random Street addr2 : City addr3: addr4: postcode : LT1 5GH The postcode is always populated. How…
Ben Hamilton
  • 949
  • 3
  • 10
  • 21
0
votes
1 answer

conveert dd.mm.yy into YYYYMM in Ingres db

I have date as DD.MM.YYYY how I can convert it into YYYYMM tql CONVERT() function doesn't work in ingres MySQL DATE_FORMAT also
Andrey
  • 1,629
  • 13
  • 37
  • 65
1 2 3
…
10 11