Question about common table expression and father-child
Posted: Wed Nov 21, 2012 4:31 pm
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?
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?