Search results: Informix

Showing 24

Improve Stored Procedures features

We are trying to increase the usage of SP in our system environment. Migrating business code from 4GL to the database.But this process becomes very painful for our developers since the support for SPL is limited. Mainly the inexistence of a native...

over 6 years ago in Informix / Informix Server 0 Future consideration

20 VOTE

Implement LIMIT clause in DELETE Statement

Expand DELETE syntax implementing LIMIT clause and maybe also ORDER BY. Delete syntax can be like: DELETE [FROM] tbl_name [WHERE where_condition ] [ORDER BY ...] [LIMIT row_count ] This limit + order by syntax is already implemented in other major...

about 4 years ago in Informix / Informix Server 1 Future consideration

35 VOTE

Ability to sync tables to HDR & RSS secondaries when converting from RAW to STANDARD mode.

It is significantly faster to load a table in TYPE(RAW) mode than TYPE(STANDARD) mode. However, this option is not practical for sites using HDR and/or RSS secondary servers for replication as RAW mode tables do not replicate forcing the site to b...

over 8 years ago in Informix / Informix Server 0 Future consideration

11 VOTE

enhancements to sysprocedures table and dbschema utility

Currently, there does not appear to be anything in the sysprocedures table to identify which procedures are provided by Informix (system routines) vs those created by users (user routines). The mode column does not appear to address this particula...

about 3 years ago in Informix / Informix Server 0 Future consideration

14 VOTE

Unload to file should have option that prevents over writing of an existing file

A customer writes some SQL that captures the pre-data to an unload file and then does the updates/deletes etc. If the SQL is successful and inadvertently run again the initial pre-data will be lost.

over 4 years ago in Informix / Informix Server 3 Future consideration

32 VOTE

Character length semantics instead of byte length semantics

We want to store UTF8 text data into our database but using byte length semantics is counter intuitive on the char and varchar types. We are using Fourj's Genero tool to develop our application and Genero is able to switch to character length sema...

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

25 VOTE

Allow "group commit" as other RDBMS

For high use OLTP systems, there can be a lot of I/O pressure on the logical log due to intense rate of logical log buffer flushing (most customer don't ant data loss so they use UNBUFFERED LOG). Setting BUFFERED LOG at session level would hardly ...

over 11 years ago in Informix / Informix Server 3 Future consideration

7 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 3 years ago in Informix / Informix Server 1 Future consideration

23 VOTE

Improve performance of L1/L2 backups

Current, for L1 (or L2) backups we need to read all pages. This is highly inefficient and there are alternatives for implementing this.In the PMR we've been told this matches old FEA idsdb00010525. In this the proposed solution was to maintain a t...

about 11 years ago in Informix / Informix Server 0 Future consideration

8 VOTE

Convert Log "Raw" data into SQL Statements

archecker and onlog should be able to output analyzed onlog raw information and convert it to SQL Statements

over 4 years ago in Informix / Informix Server 0 Future consideration

Please enter your email address

FILTER BY CATEGORY