In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
-DEFAULT &SERVER_NAME = 'xx.x.x.xxx'; -SET &CONNECTION = IF &SERVER_NAME EQ 'x.x.x.xxx' THEN 'development' ELSE 'prodution'; -*------------------------------------------------------------------------ -* Call Stored Procedure #1 -*------------------------------------------------------------------------ SQL SQLMSS SET SERVER &CONNECTION SQL SQLMSS EX DataBase.DBO.SQL_Stored_proc1 '&VAR1', '&VAR2', '&VAR3', &VAR4; -*------------------------------------------------------------------------ -* Read the data into a hold file. -*------------------------------------------------------------------------ TABLE FILE SQLOUT SUM COLUMN1 COLUMN2 COLUMN3 ON TABLE HOLD AS PASS1 FORMAT ALPHA END -RUN -READ PASS1 &COL1.AXX. &COL2.AXX. &COL3.AXX -*------------------------------------------------------------------------ -* Call Stored Procedure #2 -*------------------------------------------------------------------------ SQL SQLMSS SET SERVER &CONNECTION SQL SQLMSS EX DataBase.DBO.SQL_Stored_proc2 '&VAR1', '&VAR2', '&VAR3', &VAR4; -*------------------------------------------------------------------------ -* Read the data into a hold file. -*------------------------------------------------------------------------ TABLE FILE SQLOUT SUM COLUMN1 COLUMN2 COLUMN3 ON TABLE HOLD AS PASS2 FORMAT ALPHA END -RUN