Can I pass my input parameters to my drill down.
For example
TABLE FILE TABLENAME
SUM
CNT.UNIQUE_ID
WHERE DATE GE '&BEGDATE';
WHERE DATE LT '&ENDDATE';
.....
TYPE=DATA,
COLUMN=N1,
FOCEXEC=EXAMPLE(ID=N1),
$
...
I got it to pass ID, but I want the date to be able to pass to the example fex as well. So I add it by typing
FOCEXEC=EXAMPLE(ID=N1, BDATE='&BEGDATE', EDATE='&ENDDATE'),
But that doesn't work...
Has anybody done this b/4??
Thank you!!!
For example
TABLE FILE TABLENAME
SUM
CNT.UNIQUE_ID
WHERE DATE GE '&BEGDATE';
WHERE DATE LT '&ENDDATE';
.....
TYPE=DATA,
COLUMN=N1,
FOCEXEC=EXAMPLE(ID=N1),
$
...
I got it to pass ID, but I want the date to be able to pass to the example fex as well. So I add it by typing
FOCEXEC=EXAMPLE(ID=N1, BDATE='&BEGDATE', EDATE='&ENDDATE'),
But that doesn't work...
Has anybody done this b/4??
Thank you!!!