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
1 answer

SQL Adapter.Fill(dataTable) fetches wrong rows

I've encountered a problem in my class for fetching SQL (Ingres.Client lib) data. SQL query select works fine in SQL DBA client (VDBA) for Ingres Database. Rows gets fetched just right. But my code return shifted data, wrong rows. E.g. Im trying to…
Reddi3n
  • 23
  • 5
1
vote
1 answer

Oracle equivalent to Ingres inquire_sql or inquire_ingres?

I'm converting some legacy embedded-Ingres C code to work against Oracle. I've found references to functions "inquire_ingres()" and "inquire_sql()," which, per the docs at…
Jim Kiley
  • 3,632
  • 3
  • 26
  • 43
1
vote
1 answer

Ingres: how to read the database in a specified encoding in PHP?

I've to use CakePhp with ingres. The problem is that I've to use UTF-8 in the website and the database is provided in ISO-8859-1. So my question is, how to manage this charset problem? On MySql I know I can run a "SET NAMES UTF-8" request on the…
J4N
  • 19,480
  • 39
  • 187
  • 340
1
vote
1 answer

Php:ingres equivalent of mysql_insert_id()

I've to make some PHP interaction with an Ingres database. I need to get the ID of the last entry I inserted in the database. How should I proceed? I'm not an ingres expert, but I suppose there is also auto-incremented ID/Sequences/...? Thank you…
J4N
  • 19,480
  • 39
  • 187
  • 340
1
vote
1 answer

Use LINQ expressions or Specification pattern to access Ingres database?

I am working on a WCF project, which provides business information out of several data sources. To reuse the code, my BusinessContactService contains a generic repository dependency defined as: public interface IRepository { IQueryable…
tang
  • 13
  • 3
1
vote
1 answer

Unlock a table of a ingres database

I have the problem that I runned an sql statement but haven't comitted it. Now the table is locked and I don't know how to unlock an Ingres database table. I have searched for some information but I can't find anything. Can anyone help me? Thanks in…
dankoe
  • 51
  • 1
  • 7
1
vote
1 answer

SQL Subquery > 1 meaning

I've been looking over some old Ingress SQL code and I'm slightly curious as to the ' > 1' at the end of a subquery, such as : SELECT count(*) FROM table1 t WHERE t.col1 = 'TEST' AND t.col2 = 'TEST123' AND (SELECT count(*) FROM table2 ta JOIN…
SQLNoob
  • 25
  • 2
1
vote
1 answer

Do Ingres and Vectorwise Databases support functionality similar to TRUNCATE table in SQL Server? If so, what is the syntax?

Trying to find if there is something similar to TRUNCATE TABLE in these 2 database systems.
Shiv
  • 11
  • 2
1
vote
1 answer

Ingres multiplication gives wrong result

I have an Ingres table with following columns from_date ingresdate to_date ingresdate model_amt money The dates can reflect a period of any number of days, and the model_amt is always a weekly figure. I need to work out the the total model_amt for…
Ben Hamilton
  • 949
  • 3
  • 10
  • 21
1
vote
2 answers

ingres 10s sql row number

I have two simple one column tables like this: Table one: from_date 01.01.18 15.01.18 23.01.18 01.02.18 Table two: to_date 15.01.18 23.01.18 01.02.18 05.02.18 All I want to do is join them on a.row_number = b.row_number I can't find a way within…
Andrew Courtenay
  • 57
  • 7
1
vote
0 answers

How to migrate from INGRES to MS-SQLServer

we have serveral C (ANSI-C) processes on a intel-based solaris server which connect to an ingres db through embedded sql. Now we want to migrate the code to ms-sql server. I have already found OBDC drivers/libraries for solaris on the net,…
Guido
  • 11
  • 2
1
vote
3 answers

How do I determine if a column value has changed back and forth during a date range?

Background: We have a working query for selecting what type of access (d8_5_B.xpostaccessuse) a patient (column xpid in any table) has in use 90 days after the date they became chronic (d1.ddiadate +'90 days'). Output is two columns: one date, one…
Jackson
  • 217
  • 1
  • 15
1
vote
1 answer

left join and where condition in joining condition

I am using Ingres 11.0 DB not sure if it will have same behavior on other DB engines ,but here is it SELECT * FROM table1 t1 LEFT JOIN table2 t2 ON t1.id = t2.fk_id WHERE t1.code = 'CODE1' AND t2.id_number = 12174; does not return all…
Andrey
  • 1,629
  • 13
  • 37
  • 65
1
vote
1 answer

How can I select a max date from a selection of dates less than another table's max?

Question: How can I select the max(d1_10.dstartdate) (latest unit transfer date) for every xpid (patient ID) from a selection of dates in d1_10 that are less than each xpid's max(d8.start_date) (latest session date)? Info: Tables: d0 Patient List…
Jackson
  • 217
  • 1
  • 15
1
vote
1 answer

More than one SELECT in ingres report writer

Background Im trying to create a report via ingres where i provide 2 dates ($begin_date and $end_date) this report will provide me with errors from a system that occured between the two dates. If these dates are less than one day apart, I should…
Emil Nolin
  • 72
  • 8
1 2
3
…
10 11