Question about common table expression and father-child



IBM's flagship relational database management system

Question about common table expression and father-child

Postby KofKof » 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?
KofKof
 
Posts: 1
Joined: Tue Nov 20, 2012 9:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Question about common table expression and father-child

 

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post