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
0 answers

How to use LISTEN/NOTIFY with ECPG

I'm trying out ECPG for work as we plan to switch from Ingres to Postgres. We have multiple C applications that uses DBEVENTs from the database to trigger different actions. Now I want to use the Postgres function LISTEN to subscribe to events from…
Sebastian Olsson
  • 51
  • 2
0
votes
2 answers

Kafka integration with Ingres database

I am trying to integrate Ingres database with Kafka. What I am looking for is, as soon as a record gets inserted/updated/deleted in Ingres database, it should publish this record in a Kafka topic. Is there any such product/framework available which…
Ajinkya Relekar
  • 1
0
votes
1 answer

Ingres stored procedure to delete multiple records from table

I am creating a SP in Ingres to delete multiple records from single table by comma separated id's, but it is not working. Though when I execute it in a separate query (without storedprocedure) then it is deleting records. create procedure sptest ( …
Deepika
  • 5
  • 3
0
votes
0 answers

How to create DSN in Ingres using Ubuntu?

I got the message error below when i try to test the DSN. I verified the Path of the driver I verified the permission of the driver Could someone know what mean this error or any Ideas for the solution?
JOSE0219
  • 9
  • 5
0
votes
0 answers

How to fix 'Connection aborted due to communications protocol error.' while executing query from Java to Ingres?

I am trying to connect the Ingres DB through .jsp page using Java code. I am able to establish connection successfully, however when I am trying to run any query on this DB connection created, the connection is getting aborted. And I am getting the…
user5891930
  • 51
  • 6
0
votes
1 answer

How to use Aliases or Variables to compare values in SQL

I'm setting up SQLs Aliases as variables to replace the excel formula below =+IF((O2+Z2)=0,0,+IF(AA2=0,(O2*-1),+IF(AND(AA2>0,(((R2*O2)/(O2+Z2))+H2)<= (O2*-1)),(O2*-1),(((R2*O2)/(O2+Z2))+H2)))) The above is the formula for 'Borough Tax Paid' but I…
Ben
  • 1
0
votes
1 answer

I can't connect to Ingres with php 7

I have to build a php website which has to connect to an Ingres database server. I have downloaded sourceforge pjbs JDBC-PHP bridge. I installed this in the project folder and tried to connect to my ingres database. I don't understand which…
yolande
  • 1
  • 1
0
votes
1 answer

Ingres fetching select into SQLDA

I am trying to use Embedded SQL in C to fetch rows from an Ingres database and return the results into the SQLDA structure. I will be selecting ints, longs and strings. So far my program fetches the strings fine, but I have issues with the ints…
Zooloo10
  • 45
  • 1
  • 8
0
votes
1 answer

Using NOT, MIN, AND in SQL having clause creating error

I am working on Ingres9.2 version. When I execute a query like select col1 from table1 group by col1 having not((5=min(col1)) and (0 = 1)) it raising an error as: bad select or subselect target list has been found. But the error not occurring if…
UserB
  • 39
  • 3
0
votes
1 answer

Zope Legacy Code - Accessing DA Functions

We're working with an older zope version (2.10.6-final, python 2.4.5) and working with a database adapter called ZEIngresDA. We have an established connection for it, and the test function shows that it is totally functional and can connect and run…
Hermano23
  • 11
  • 7
0
votes
2 answers

How to migrate Ingres database with tables, relationships along with data to MS SQL Server

I would like to know the best way to migrate Ingres database completly with tables, views, relationship along with data to MS SQL Server using any Windows application. If not possible is there any tools that provide this feature along with Ingres…
user600296
  • 1
  • 1
0
votes
1 answer

Migrating and Ingres Data Base to SQL Server 2008

I have a cline that is looking to convert an Ingres Database into SQL Server 2008. WE can easily convert the tables but there are a large number of views and procedures that are complex. Does anyone know of a method or tool that can convert these…
Lee Tedstone
  • 1
  • 2
0
votes
1 answer

delete first X row Ingres ANSI

I have 730000+ records which I need to delete in Ingres db which work with ANSI92 and I need to delete then without overload db, simple delete where search condition, doesn't work, DB just use all memory and trowing error. thinking to run it …
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
1 answer

date difference in minutes for Ingres

I have DB (ingres 11) which works with ANSI i need to findout difference in minutes between dates, I have statement SELECT top 10 date('now') - '06.07.2017 10:20:02' itscalculating and returning me this 186 days 22 hrs 43 mins how i can…
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
0 answers

connect to ingres database from windows

How do I connect to a Ingres DB using SQuirrel SQL Client. I am getting the following exception java.sql.SQLException: Unable to create connection. Check your URL. at…
user3671807
  • 33
  • 1
  • 4
1 2 3
…
10 11