Re: Trees- Node Descriptions

["Blakeslee, Andy" <ALBlakeslee@HOMELOAN.COM>]

Jason,  the problem is that you specified the join criteria within the
subselect instead of in the main query.  Try re-writing your query like
this:
(the only thing I added was a close paren after &gs.Seqno, then changed the
indentation to reflect the actual hierarchy.)

           WHERE  treenode.setid in (select extract_bus_unit 
                                       from ps_goa_extract_bu 
                                       where business_unit =
&gs.BUSINESS_UNIT 
                                       AND   extract_type  =
&gs.EXTRACT_TYPE 
                                       AND   seqno         = &gs.SEQNO )
               AND TNT.setid = treenode.setid 
             AND TNT.tree_node = treenode.tree_node 
	

> -----Original Message-----
> From: Jason Lipka [SMTP:Jason.Lipka@GOV.AB.CA]
> Sent: Monday, December 14, 1998 1:18 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Trees- Node Descriptions
> 
> Hello All, 
> 
> Hope this one proves interesting. 
> 
> I'm trying to modify the TREES.sqc extract to print out the DESCR field
> from the PS_TREE_NODE_TBL in the Tree-Node-Information procedure. Here is
> what I've attempted so far:
> 
> 
> do Tree-Node-Information 
> treenode.SETID                  
> treenode.TREE_NAME              
> treenode.EFFDT                  
> treenode.TREE_BRANCH            
> treenode.TREE_NODE_NUM          
> treenode.TREE_NODE              
> treenode.TREE_NODE_NUM_END 
> treenode.TREE_LEVEL_NUM         
> treenode.TREE_NODE_TYPE         
> treenode.PARENT_NODE_NUM        
> treenode.OLD_TREE_NODE_NUM 
> TNT.Descr 
> 
> let $........ 
> write#1 from ....... 
> 
> FROM PSTREENODE  TREENODE, 
>            PS_TREE_NODE_TBL TNT 
>    
>    WHERE  treenode.setid in (select extract_bus_unit 
>                                from ps_goa_extract_bu 
>                                where business_unit = &gs.BUSINESS_UNIT 
>                                AND   extract_type  = &gs.EXTRACT_TYPE 
>                                AND   seqno         = &gs.SEQNO 
>                                AND TNT.setid = treenode.setid 
>                          AND TNT.tree_node = treenode.tree_node 
> Everything runs just fine till it hits the node, then SQRW dies. I'm
> pretty sure I need to use dynamic sqr, but I haven't figured out where to
> start.
> 
> I've checked out the archived questions on the web site, but couldn't find
> anything relevant. 
> 
> Thanks in Advance 
> Jason Lipka 
> 
> IMAGIS Project 
> 
>   
>