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?
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.
Anyone encountered -725 sql error while rebinding the DRDA protocol?