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
1
vote
2 answers

Setting table count to variable in shell script..?

I'm looking to return a numeric value within the "count" variable from my SQL I wrote. Unfortunately I am just getting an Ingres error message. Any ideas what I am doing wrong? See shell script code below: #!/bin/ksh ############### count=$(sql…
TCP
  • 33
  • 2
  • 8
1
vote
0 answers

java.sql.SQLNonTransientConnectionException: Communications error while establishing connection

I am trying to connect my Ingrees Database Workbranch to Ingres DB and resiving this error java.sql.SQLNonTransientConnectionException: Communications error while establishing connection. at…
Andrey
  • 1,629
  • 13
  • 37
  • 65
1
vote
0 answers

Firedac + Ingres get QEP

is there a way to get QEP (query execution plan) output from Firedac throught ODBC from Ingres database? I tried FDConnection1.ExecSQL('set printqry'); FDConnection1.ExecSQL('set Lock_Trace'); FDConnection1.ExecSQL('set…
Livius
  • 958
  • 1
  • 6
  • 19
1
vote
1 answer

How to convert ingresdate to timestamp (time elapsed since 1970)?

I have Ingres DB and a table with timestamp column (seconds since 01/01/1970). I need to find all entries which happened today. Possible solution is: SELECT * FROM table WHERE date(_date(timestamp)) = date('today') However, converting every…
Jaroslaw Pawlak
  • 5,538
  • 7
  • 30
  • 57
1
vote
5 answers

How to check for a blank date value in Ingres

I have an Ingres table with date field (data type ingresdate) which has a not null restriction. However blank i.e. empty values are allowed. How can you check for a blank value? Of course testing for null values using ifnull() does not work - as per…
Adrian
  • 6,013
  • 10
  • 47
  • 68
1
vote
1 answer

SQL partial field match using LIKE

I have two tables in an Ingres database table1 and table2. Both contain, amongst other things, the following fields ;- date_of_birth ingresdate forename c35 surname c35 I want to match people in one table to the other. The names come from different…
Ben Hamilton
  • 949
  • 3
  • 10
  • 21
1
vote
1 answer

How to find the sequence used for AUTO_INCREMENT?

Before you answer, let me emphasize that this is a question related to the Ingres RDBMS . As many other Ingres users who complained about in the past on forums, I also experience the access issue when AUTO_INCREMENT is used... I need to find out the…
DejanLekic
  • 18,787
  • 4
  • 46
  • 77
1
vote
3 answers

Ingres SQL, find the max value of one column based on the value of another column

I'm working on an Ingres DB with a script I've inherited from someone else. I need to change the script to pull out the action_times of the latest start_time and end_time event, and also the difference between the two. A sample of the DB is listed…
John Kilo
  • 123
  • 1
  • 9
1
vote
3 answers

SQL Update, incrementing value by 1

My mind has gone blank...I am missing something obvious trying to write a small script: I have one table with various ID's: TBL_USETHISID nextid int I have another table with references: TBL_REFS ref varchar(6) thisdate datetime nextid int I want…
n34_panda
  • 2,577
  • 5
  • 24
  • 40
1
vote
1 answer

Stuck on SQL query with multiple joins

Alright, the system I got is a pretty outdated ERP system based around an Ingres database. The database schema is ... well ... not very nice (not really normalized) but basically it works out. Please understand that I cannot change anything related…
Tom L.
  • 932
  • 2
  • 9
  • 30
1
vote
2 answers

Using SQL92 syntax for joining table to itself (moving from ingres specific to jOOQ)

I need help with a problem I've been scratching my head and so far I couldn't solve. This is not a specific question about jOOQ, but I refer it to explain why I have to use joins instead of the ingres specific syntax. That said: Imagine the…
Luis Matos
  • 347
  • 3
  • 14
1
vote
1 answer

how to get number of rows affected by an update in INGRES

How can you get the rows affected by an SQL UPDATE statement in INGRES? eg: SELECT COUNT (*) FROM ( UPDATE gare SET code_gare = 'AB-BV' WHERE code_gare = 'AB' ) RESULT count = 2 (something like this)
Thulasi
  • 23
  • 6
1
vote
1 answer

How to GROUP_CONCAT in Ingres?

Is there any easy way you can simulate GROUP_CONCAT functionality in Ingres 9.2? I have a table which has something like : OrderID LineNumber LineText 1 1 This is an example note which is trunc 1 2 ated…
dantefs
  • 174
  • 6
1
vote
1 answer

An attempt to place a null value in a non-nullable datatype

I'm using dbunit and unitils trying to get test sensitive dates on my dataset files. public void setUp() { String dataSetFile = "/Dataset.xml"; IDataSet dataSet; try { dataSet = new FlatXmlDataSetBuilder().build(new…
mjgirl
  • 1,214
  • 7
  • 24
  • 42
1
vote
2 answers

Repeated insert syntax for efficiency in vectorwise - any examples?

I need to speed up inserts into an Ingress VectorWise database, and the documentation shows this: http://docs.actian.com/ingres-vectorwise/2.5/sql-language-guide/5315-insert The INSERT statement inserts rows into a table. This statement has the…
John Humphreys
  • 37,047
  • 37
  • 155
  • 255
1 2 3
…
10 11