Re: Trees- Node Descriptions

[Jason Lipka <Jason.Lipka@GOV.AB.CA>]

Thanks. that did the trick.

Jason

> -----Original Message-----
> From: Blakeslee, Andy [SMTP:ALBlakeslee@HOMELOAN.COM]
> Sent: Monday, December 14, 1998 12:37 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Trees- Node Descriptions
> 
> 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 
> > 
> >   
> >