IBM Data and AI Ideas Portal for Customers
This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. 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
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
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.
IBM Employees should enter Ideas at https://ideas.ibm.com
Okay thanks.
Hello Benjamin, Below please find feedback from development. Thank you.
Alias can be added as in below. That allows customer to specify column name for the result of UNION.SELECT * FROM (SELECT C1,C2 FROM T1 UNIONSELECT C2,C1 FROM T1 UNIONSELECT C3,C4 FROM T1) AS TX(C1,C2)Hi,
Thanks, it seems the problem is an alias cannot be used. The column name returned is a number. For example,
SELECT
T1.C1 AS C1Alias
FROM
T1
UNION
SELECT
T2.C1
FROM
T2
benjamin
Hi Janet,
You are right that the query runs fine, but, Db2 assigns standard column names (Col1, Col2) for such result sets. Benjamin was looking for Db2 to assign the column names as C1 and C2 (as they are the column names for the first part of the query) for your example.
Hi Benjamin, I'm marking this delivered as it currently supported.
For example, the following SQL runs successfully on Db2.
SELECT * FROM (
SELECT C1,C2 FROM T1 UNION
SELECT C2,C1 FROM T1 UNION
SELECT C3,C4 FROM T1
);
Please let us know if you have any further questions. Thank you!
It is never required to have the same column name across union legs. It works as long as data type matches.
For example, the following SQL runs successfully on Db2.
SELECT * FROM (
SELECT C1,C2 FROM T1 UNION
SELECT C2,C1 FROM T1 UNION
SELECT C3,C4 FROM T1
);