AnsweredAssumed Answered

Hi All. I have pdi screen,i am trying to run aquery 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 a

Question asked by divyasreeb on Aug 20, 2015
Latest reply on Aug 21, 2015 by Eugene Lee

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.

 

Current query:

 

SELECT TO_CHAR(SCHED_ENERGY),0 FROM

LIPA_MART.TERT_GEN_SCHEDULE

WHERE

(BID_STATUS = 'BID ACCEPTED' and

MARKET_CODE ='NYISO' and SCHEDULE_DATE = To_Date(Sysdate +1) and MARKET ='DAM' and (PTID = '?'));

Outcomes