Application Development

Showing 70

WHERE/GROUP BY clasue on column alias

Would be very userfull to wite WHERE/GROUP BY clasue on column alias. Very usefull for developers who are using OLAP Functions or other operations on column.

over 7 years ago in Db2 / Application Development 0 Not under consideration

3 VOTE

Default of for read only for all select statements

As you might have noticed, the "for read only" clause of the select statement in DB2 is not widely known nor used. Most standards select statements going through the DB2 engine have the risk of becoming an ambiguous cursor with sub-optimal perform...

almost 4 years ago in Db2 / Application Development 1 Not under consideration

1 VOTE

Index support for "expression op expression"

In our environment, we have many queries with predicate: "expression op expression". As they don't use indexes they're performing a table scan. We would like DB2 to be able to use indexes to resolve this type of predicate. Examples: SELECT [id], [...

over 1 year ago in Db2 / Application Development 0 Future consideration

4 VOTE

TRY_CAST for DB2 LUW (CAST without error)

"New" scalar-function TRY_CASTReturns a value cast to the specified data type if the cast succeeds; otherwise, returns null.

almost 6 years ago in Db2 / Application Development 0 Not under consideration

1 VOTE

External Stored Procedure sub modules to be loaded from same path as 'external name;

DB2 supports multiple (in our case development) databases within a db2 Instance and External Stored Procedures (in our case COBOL) can be developed in parallel by using different qualifiers in the external name e.g. alter procedure cxjjp.UIXN01 ex...

over 1 year ago in Db2 / Application Development 0 Future consideration

5 VOTE

SELECT * FROM FINAL TABLE (MERGE ...)

SELECT * FROM FINAL TABLE (MERGE ...) - It would be very usefull to select records that were just merged. The same way like with DELETE / UPDATE and INSTERT: SELECT * FROM FINAL TABLE (DELETE / UPDATE / INSERT)

over 7 years ago in Db2 / Application Development 1 Not under consideration

2 VOTE

Update APPLNAME from properties and other ways

The application name in many environments is limited to db2jcc_application and db2bp, just because the development of the application did not take into account this. However, it will be great to change the application via properties file and/or s...

over 3 years ago in Db2 / Application Development 0 Not under consideration

2 VOTE

Deploy new/unused packages without causing performace impacts

With current DB2(V11.1 FP2, FP4), Deploying a new or an unused packages causing variation and catalog locks impacting performance. HOLDHDL WAITHDL HOLDER WAITER HOLDMODE OBJTYPE TABNAME SCHEMA SECS STMTTEXT ---------- ------- ---------- ----...

over 3 years ago in Db2 / Application Development 0 Not under consideration

2 VOTE

Save exceptions in FORALL statement (PLSQL)

Oracle PL/SQL supports save exceptions in FORALL statement, but Db2 PL/SQL doesn't. For smooth oracle migration, the feature is required .

over 3 years ago in Db2 / Application Development 0 Not under consideration

4 VOTE

Document the client_prdid for each Fix Pack release of db2jcc.jar and db2jcc4.jar drivers

When Java applications connect to DB2 via the JDBC Type 4 JCC driver, the only version-specific identifier visible from the DB2 server (via an application snapshot) is the client product ID of the driver, such as JCC03000. This value is currently ...

almost 8 years ago in Db2 / Application Development 2 Not under consideration

Please enter your email address

FILTER BY CATEGORY