-SET &bu_id ='1'; -SET &analystid='5'; -SET &depcode='NPX16,NPX23,PSX11'; -SET &depcode_status='1'; -SET &citypair='CFRPME,PMESDR'; -SET &citypair_status='1'; -SET &startdepdate='2012/03/25'; -SET &enddepdate='2012/03/25'; -SET &depdate_status='1'; -SET &capture_date='2012/03/26'; -SET &resource='P'; -SET &resource_status='1'; -SET &equipment='M,N'; -SET &equipment_status='1'; -SET &level='0'; -SET &timeperiod='0'; -SET &return_code='0'; -SET &return_message='0'; -SET ECHO = ALL; SET SQLENGINE=SQLMSS -*SQL EX rts_po.DBO.KPI_Load_Factor_KV '1' ,'5' ,'NPX16,NPX23,PSX11' ,'1' ,'CFRPME,PMESDR' ,'1' ,'2012/03/25' ,'2012/03/25' ,'1' ,'2012/03/26' ,'P' ,'1' ,'M,N' ,'1' ,'0' ,'0' ,'0' ,'0'; SQL EX RTS_PO.DBO.KPI_Load_Factor_KV '&bu_id','&analystid','&depcode','&depcode_status','&citypair','&citypair_status','&startdepdate','&enddepdate','&depdate_status','&capture_date','&resource','&resource_status','&equipment','&equipment_status','&level','&timeperiod','&return_code','&return_message'; TABLE FILE SQLOUT PRINT * ON TABLE HOLD END -RUN
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
Your request did not return any output to display. Possible causes: - No data rows matched the specified selection criteria. - Output was directed to a destination such as a file or printer. - An error occurred during the parsing or running of the request. -SET &bu_id ='1'; -SET &analystid='5'; -SET &depcode='NPX16,NPX23,PSX11'; -SET &depcode_status='1'; -SET &citypair='CFRPME,PMESDR'; -SET &citypair_status='1'; -SET &startdepdate='2012/03/25'; -SET &enddepdate='2012/03/25'; -SET &depdate_status='1'; -SET &capture_date='2012/03/26'; -SET &resource='P'; -SET &resource_status='1'; -SET &equipment='M,N'; -SET &equipment_status='1'; -SET &level='0'; -SET &timeperiod='0'; -SET &return_code='0'; -SET &return_message='0'; SET SQLENGINE=SQLMSS -*SQL EX rts_po.DBO.KPI_Load_Factor_KV '1' ,'5' ,'NPX16,NPX23,PSX11' ,'1' ,'CFRPME,PMESDR' ,'1' ,'2012/03/25' ,'2012/03/25' ,'1' ,'2012/03/26' ,'P' ,'1' ,'M,N' ,'1' ,'0' ,'0' ,'0' ,'0'; SQL EX RTS_PO.DBO.KPI_Load_Factor_KV '1','5','NPX16,NPX23,PSX11','1','CFRPME,PMESDR','1','2012/03/25','2012/03/25','1','2012/03/26','P','1','M,N','1','0','0','0','0'; TABLE FILE SQLOUT PRINT * ON TABLE PCHOLD END -RUN