Hi All. I have pdi screen,i am trying to execute a query through ODBC setup.
Can anyone suggest how can pass the sysdate 1 as input paramter along with another ID as a input parameter..the query is used to populate a trend.I have few options on my pdi screen and select of a option,the query takes it as an input and executes teh query and based on teh output the trend varies.
SELECT TO_CHAR(SCHED_ENERGY),0 FROM
(BID_STATUS = 'BID ACCEPTED' and
MARKET_CODE ='NYISO' and SCHEDULE_DATE = To_Date(Sysdate +1) and MARKET ='DAM' and (PTID = '?'));