IBM Power Ideas Portal
Hide about this portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

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:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Add a new idea Subscribe
Status Not under consideration
Workspace IBM i
Categories Db2 for i
Created by Guest
Created on Feb 28, 2025

RELATED IDEAS

Sql Update using Common Table Expresions

See this idea on ideas.ibm.com

Currently an UPDATE statement that attempts to update a field with the selected value from a Common table expression causes an SQLCODE -199 with SQLSTATE 42601: "Illegal use of KeyWord UPDATE. Token ( SELECT VALUES was expected" --or something similar, sorry my available IBM i is in Spanish-- :

With T1 as ( SELECT  ... FROM Mo@Test/Tabl ), T2 as ( Select ... From T1 )
Update Mo@Test/Tables Tabl
  Set RawData = ( Select T2.Fld2 FROM T2 Where ( T2.Fld_1 = Tabl.Fld_1 );

you can achieve that using nested-table-expression:

Update Mo@Test.Tabl
Set RawData = ( Select T2.Fld_2
From ( Select ... From ( SELECT ... FROM Mo@Test.Tabl ) as T1 ) as T2
Where ( T2.Fld_1 = Tabl.Fld_1 );

but is less clear and harder to maintain






Idea priority Medium
  • Guest
    Reply
    |     Mar 21, 2025
    While we embrace the use of Common Table Expressions to make SQL statements easier to understand, we do not plan to implement this request at this time. The database team has a very long list of requests that are considered higher priority. It is unlikely that we would be able to implement this any time soon so it is being closed. We will keep track of this request internally so that it can be considered in the future.

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.