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

Installing Ingres Database on Mac OS X 10.10

I need help - I am using MacBook Pro with Yosemite installed. I started next year in College and we have subject about databases. My tutor wants us to use Ingres database, but there is no release for Mac (there is release for Windows, Linux and even…
XSorcery
  • 83
  • 1
  • 10
0
votes
1 answer

Equivalent to "ALTER SEQUENCE" that is usable in a Stored Procedure

I need to produce a stored procedure in Ingres capable of taking a list of IDs and producing a new set of IDs which are unrelated to the first set (but where we store each pair). My initial plan was to sort by random(), and use a sequence to simply…
littlefeltfangs
  • 396
  • 2
  • 17
0
votes
1 answer

Ingres - query "WHERE tid IN (...)" ignores the lowest value in the list

We have found in our a system an SQL query which looks like this: SELECT *, tid FROM x WHERE tid IN (213, 214, 215, 216, -1) The actual numbers come from somewhere else, but we always append -1 at the end of the query so I tried removing it. After…
Jaroslaw Pawlak
  • 5,538
  • 7
  • 30
  • 57
0
votes
0 answers

how to interpret session waite reason in ingres ipm?

I am using ipm for monitoring an ingres database (Ingres 10 on RedHat). In the Wait Reason of the session I notice : DIOR, DIOW, LIOR, LIOW, BIOR, BIOW, Log, Lock, LGEvnt, LKEvnt. I have searched the documentation and googled the net but I can't…
mtbadi39
  • 448
  • 6
  • 18
0
votes
1 answer

UNION clause in embedded SQL

I'm using ingres 10S SQL, and I'm trying to write the following SQL statement in an embedded SQL C program. It works fine as a standalone SQL script, but compiling the eSQL program gets the error %% Error in file localtask.sc, Line 498: …
rojomoke
  • 3,765
  • 2
  • 21
  • 30
0
votes
1 answer

How to filter out data with special character in vectorwise

There is a column named Prod_code in my product table. I need to select only valid prod_code from product table and load it into another table. valid prod_code are the codes which don't have any special characters in it. VALID prod_code: WER1234,…
shra
  • 1
0
votes
1 answer

Python ingresdbi: Install under different directory

I would like to install the ingresdbi python package (http://code.ingres.com/ingres/drivers/python/main/) under a project I am creating. So I would like to specify the directory of my choice (inside the python project hierarchy) instead of the…
George Tseres
  • 498
  • 6
  • 19
0
votes
1 answer

Ingres nested query

I try this: select fielda from tableA A left join (select fieldB from tableB ) B where A.fielda = B.fieldB I have this error : Une erreur s'est produite lors de l'exécution de la requête. ERROR [42500] [CA][Ingres ODBC Driver][Ingres]Table…
Sworios
  • 37
  • 1
  • 9
0
votes
1 answer

Getting the Rolling Average

I have a list of Dates which appear in a dropdown box, I need to get the 12 month rolling average for each month. The list of dates are in the column called date_end. SELECT total_subs, cust_region, cust_phone, date_end FROM table_customer where…
user3399863
  • 151
  • 1
  • 1
  • 7
0
votes
1 answer

How to change identifier quote character in SSIS for connection to ODBC DSN

I'm trying to create an SSIS 2008 Data Source View that reads from an Ingres database via the ODBC driver for Ingres. I've downloaded the Ingres 10 Community Edition to get the ODBC driver, installed it, set up the data access server and a DSN on…
William Rose
  • 971
  • 1
  • 6
  • 13
0
votes
3 answers

SQL Join / Union

I have two statements that I want to merge into one output. Statement One: select name from auxiliary_variable_inquiry where inquiry_idbr_code = '063' Returns the following list of…
Jon Lavercombe
  • 3
  • 2
0
votes
1 answer

NFC or NFD - what is the difference?

In Ingres, the DBA has two options when creating Unicode-aware Ingres databases. createdb has the -i flag for NFC (Normalization Form C) and -n for NFD (Normalization Form C). Documentation makes no distinction between them, the description is…
DejanLekic
  • 18,787
  • 4
  • 46
  • 77
0
votes
2 answers

Capture Ingres createdb command in a variable

Not quite sure how to do this but I need to get the input from createdb, which is an Ingres command, and pass it to a variable in the wrapper script and then write to log file. #!/usr/bin/bash # createdb_wrapper.scr # Log information about user of…
Christian Watts
  • 77
  • 1
  • 9
0
votes
1 answer

How to define the size of the "memory pool"?

In the psf_memory and opf_memory we give percentage of the memory pool that we want to be available for these two facilities. However, it is still unclear how to control the memory pool itself. I understand it changes with number of allowed…
DejanLekic
  • 18,787
  • 4
  • 46
  • 77
0
votes
1 answer

Find rows where a certain value ends with a specific string

I need to do something like this SELECT * from table1 where name ='TEST_2014.xml' But in the column 'name' the values are saved in format like ../data/flux/TEST_2014/TEST_2014.xml I need help to remove or edit ../data/flux/TEST_2014/ and take…
Thulasi
  • 23
  • 6
1 2 3
…
10 11