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

Update in ingres

UPDATE m SET m.class_code = 'new cod' FROM models as m inner join type a on m.model_number = a.model_number WHERE a.type_number NOT IN ( 1, 10 ) AND m.class_code = 'UN' I have this query and in Ingres DB it doesn't want to run.…
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
1 answer

Need GUI tool for querying INGRES database

Have to work with Ingres DB right now, it has very uncomfortable GUI interface called Visual DBA. Is there any other interfaces which I can use to fork with this DB? need some think like SSMS, or may be there is some plugins which can be used in…
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
2 answers

Ingres SQL select multiple rows into one column

Our database is on Ingres II 10.0.0 (su9.us5/132). As such, it is missing many useful functions like stuff, coalesce, etc that make merging multiple rows of data into one column supremely difficult. There was this: How to GROUP_CONCAT in Ingres?…
Mia
  • 23
  • 5
0
votes
1 answer

How to split a column by the number of white spaces in it with SQL?

I've got a single column that contains a set of names in it. I didn't design the database so that it contains multiple values in one column, but as it is I've got to extract that information now. The problem is that in one field I've got multiple…
Tomislav Mikulin
  • 5,306
  • 4
  • 23
  • 36
0
votes
1 answer

Multiple aggregates in Ingres SQL

I have a large table which is split into school years, sch_year_id i4 name c20 addr1 c20 teacher c20 etc. etc.. sch_year_id is an integer, 23 represents the 13/14 school year, 24 represents the 14/15, etc. etc. So there are normally thousands of…
Ben Hamilton
  • 949
  • 3
  • 10
  • 21
0
votes
1 answer

Select a maximum value within a date range

Task: Append/edit the currently working code below to return only one row per patient, the maximum value of d1_10.xtransfer (datatype int) with the restriction that this row's d1_10.dstartdate <= glob_End_Date. Caveats: There are similar…
Jackson
  • 217
  • 1
  • 15
0
votes
1 answer

I can't connect to Ingres with php 5.4

I have windows xp with xampp installed and the problem is at moment to connect with ingres DB show me this error **Fatal error: Call to undefined function ingres_connect() ** I read about it and I tried to load the extension php_ingres.dll and edit…
JOSE0219
  • 9
  • 5
0
votes
0 answers

when using delete join pop out E_US09C4 Syntax error on line 1

I am using Vector Version VW 4.2.2. When I use delete join, one error pop out, E_US09C4 Syntax error on line 1. Could anyone help solve this? Thanks very much. Below is my sql script: delete T.* from table1 T join table2 F on T.collective_Id =…
sophia_kkw
  • 1
  • 1
0
votes
1 answer

Does blobstor hava an opposite command, Ingres?

I am using the blobstor command to load jpeg images into an ingres db, which is fine. But at some point I need to develop a manual way to copy them back out again. I can find some examples of this that uses BCP, however these are for sql server…
John Paul
  • 772
  • 1
  • 6
  • 17
0
votes
0 answers

How to connect Xampp v3.2.1(php) with Ingres

I want to connect php with the Database located in INGRES. Now, when i try to connect show me it. I copied the file php_ingres into the folder php/ext and added the filename into the file php.ini. The version: PHP 5.5.28 Xampp v3.2.1 Any idea…
JOSE0219
  • 9
  • 5
0
votes
0 answers

Ingres sql - Syntax error on 'then', the correct syntax is:

I have some code in ingresql that doesn't seem to work. I tried this out in Postgres using the same type of problem and it ran just fine. Now when I try it out in ingres it has huge problems. select sum(case when date_part('year', order_dt) = 2015…
Padagomez
  • 1,114
  • 5
  • 14
  • 35
0
votes
3 answers

Grails automatically reopen connection on fail

I have a Grails app communicating with an ingres database via domain classes. When the database crashes or I restarted it while the application is running I get an Exception: | Error Caused by: java.sql.SQLTransactionRollbackException: Connection…
Sebastian Barth
  • 4,079
  • 7
  • 40
  • 59
0
votes
1 answer

How to add jdbc driver for accessing Ingres database in Grails

I'm trying to access an Ingres Database via Hibernate/GORM in my Grails app. I'm failing at the point integrating the correct jdbc driver. How do I add the jdbc driver for ingres databases?
Sebastian Barth
  • 4,079
  • 7
  • 40
  • 59
0
votes
1 answer

Syntax error on ALTER COLUMN - Ingres

I have an sql script that I am running in via PUTTY to update an ingres DB It is having errors with the following query (which work fine in Squirell SQL Client) ALTER TABLE address ALTER COLUMN address2 VARCHAR(100); \p\g Where I am trying to…
gio10245
  • 37
  • 2
  • 13
0
votes
1 answer

Enable log in ingres

I need to understand enable logging in Ingres stored procedure. I read a lot about "printqry", DBMS Server Query Tracing or security auditing. My requirement is does Ingres db gives option of custom logging where I can log custom…
Sam
  • 747
  • 1
  • 8
  • 14
1 2 3
…
10 11