Hello guys,
When i use the common-table-expression keyword WITH, where does the defined data reside? or DB2 just replaces the WITH table with the sql?
for example
with mytable as (select * from sysibm)
Select * from mytable
In DB2 v10, is there an easy way (like in oracle) to define father-child reletionship? or it is just a recursive function with the WITH clause.
Thanks alot,
P.S
Anyone encountered -725 sql error while rebinding the DRDA protocol?
select Col1
, Col2
, [...]
, Coln
from (select ColA as Col1
, ColB as Col2
, [...]
, ColX as Coln
from My_view
) as Derived_table