
Connect by .qry passing its parameter to CR's
Hello all,
I have a qry that uses a connect by in its sql;
SELECT
ROWNUM,
LEVEL,
PART_NO,
PART_REV,
SUB_PART_NO,
SUB_PART_REV,
from IFSAPP.ENG_PART_STRUCTURE
CONNECT BY
PRIOR SUB_PART_NO = PART_NO
AND PRIOR SUB_PART_REV = PART_REV
START WITH PART_NO = 'K76046'
AND PART_REV='16'
I want to put this into A CR using
START WITH PART_NO = &PART_NO AND &PART_REV
Is this possible with SQL designer passing the results of the qry to CR