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