I have a query with several nested table.
For every selection, I have to select all the columns of the previous nested
tables plus other columns I create.
For example:

select
field1,
field2,
field1/field2 as field3
from (
select
field1, field2
from mytable.
In the real query I have many columns to select and so in order to avoid to
repeat all the fields names in every selection, I'd like to make this selection:

select
*,
field1/field2 as field3
i.e. I want to select all the columns of the previous table plus the new
created column.
How can that be done?
Thank you.
Anna - Verona (Italy)

You will need to be using DB2 for z/OS V8.1. Common table expressions do not exist in DB2 V7 for z/OS (still supported by IBM).

"SELECT *" does not allow you to specify additional columns besides you use a correlation name with the *.


SELECT D.* , field1/field2 as field3
FROM (
SELECT field1 , field2
FROM my.table ) as D ;

should work.