Informix Server

Showing 447 of 15383

Support LIMIT clause in Common Table Expressions

Using LIMIT clause in a CTE gives a syntax error (with IDS 14.10.FC10) sf@toro (master):~/genero/devel/dbsync/dbsync$ cat x.sql WITH recent_rows AS (SELECT log_ordinal FROM dbsync_log WHERE log_table_name = 'stkitem' ORDER BY log_ordinal DESC LIMI...

5 months ago in Informix / Informix Server 0 Submitted

21 VOTE

Table level restore

To enhance functionality of ontape/onbar utility to enable table level restore.

over 8 years ago in Informix / Informix Server 1 Not under consideration

26 VOTE

Only in-memory Temp table

Temporary table only cached in the memory, it does not to write into the temp dbspace.Requirement from China mobile (CMCC), CMCC use lots of temp table in the following 2 ways:Create temp table ... with no log; select * from tab into temp tabname ...

over 10 years ago in Informix / Informix Server 1 Not under consideration

2 VOTE

Connection Manager should have an option to initiate failover if a shared memory dump is started.

In high transaction environments shared memory dumps could have enough impact they cannot be enabled.The connection manger should be able to detect that an instance is dumped shared memory and be able to initiate failover.

10 months ago in Informix / Informix Server 0 Submitted

6 VOTE

Data Masking in INFORMIX

Our objective is not to see any sensitive data outside the production systems. As an example here is our real requirement. In a PROD environment, we can see the table data as usual . For data protection purposes, the data of the same table needs t...

over 2 years ago in Informix / Informix Server 1 Future consideration

13 VOTE

IF NOT EXISTS should not be saved as part of stored routine source

When creating a stored procedure or function with the IF NOT EXISTS optional clause included, the option text is currently included in the saved source code for the procedure. This is not true of any other database object created with the IF NOT E...

over 5 years ago in Informix / Informix Server 2 Not under consideration

3 VOTE

Add DB2 zigzap scan capability to Informix

Add DB2 zigzap scan capability to Informix. Simliar to Db2 jump scan but on both indexes in a join.

about 1 year ago in Informix / Informix Server 0 Not under consideration

3 VOTE

Add DB2 jump scan capability to Informix

Add DB2 jump scan capability to Informix. Same use case as DB2. For indexes where not all the leading columns have predicates but non-leading columns have query predicates.

about 1 year ago in Informix / Informix Server 0 Not under consideration

28 VOTE

Consolidate free space across entire chunk or dbspace

I suggest a repack-like tool which consolidates free space in an entire chunk or dbspace in order to get few, big enough, free spaces to use efficiently. Being able to do so online and with little blocking is desirable

over 11 years ago in Informix / Informix Server 1 Not under consideration

4 VOTE

Trap and/or Report running sql query on resource overflow

Currently Informix kills the session before being able to report the running sql on a Memory resource overflow. Possibly the engine has a memory leak or query could be causing the problem.

over 1 year ago in Informix / Informix Server 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY