Page 1 of 1

Question about common table expression and father-child

PostPosted: Wed Nov 21, 2012 4:31 pm
by KofKof
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?