We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Post your ideas
Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Help IBM prioritize your ideas and requests
The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.
Receive notification on the decision
Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.
MERGE INTO statement failed with SQL0104N (inconsistent with DB2 Z/OS)
he following query, which works well on DB2 Z/OS, failed with the syntax error(sql0104n) ................................................ MERGE INTO SME.MEC_GNRL_PRDT_BRNH_BLNC A USING ( VALUES ( :H_iinou_date, :w_irltvr_enty_id, :w_iprdt_id, :...
CASE with EXISTS in UPDATE returns SQL0582N, which is inconsistent behavior with db2 z/OS
db2 "update test_tab set c1=case when exists (selectc2 from test_tab where c2=1) then 'A' else 'B' END" DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it r...
Support compilation of PL/I and COBOL programs without an active DB2 connection
The compilation of PL/I and COBOL programs on the z/OS mainframe is possible without an active database connection.This does not work on the AIX platform, which requires a database connection during compilation and a DB user withsufficient privile...
Remote DB2 connections via Universal Diver T4 not well balanced.
Sysplex workload balancing does not guarantee that executions are distributed among the available systems. It depends on the capacity of the systems (WLM choose systems with more CPs/ZIIPs), performance index of enclaves, and DB2 system health (fr...
PL/SQL compatibility - default values of procedure parameters
Currently DB2 does not fully support Oracle-style definition of default parameters in PL/SQL stored procedures (including those in functions).The following definition works in Oracle, but requires modification in DB2:CREATE OR REPLACE PACKAGE mysc...
DB2 z/os supports the 'MINDIVSCALE 9' , which makes the decimal scale up to 9 for any arithmetic operations. However DB2 luw supports up to 6 using 'DB2_MIN_DEC_DIV_6=YES' in registry.User applications are bounded with GENERIC 'MINDIVSCALE 9' In K...
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)
Do not place IBM confidential, company confidential, or personal information into any field.