How to pass parameters in command line
How to pass parameters in command line:
We can use this to test procedure code from command prompt.
DECLARE GLOBAL TEMPORARY TABLE SESSION.MFS (
TABLE_ID INTEGER NOT NULL,
RUN_ID DECIMAL(10) NOT NULL,
BUSINESS_DATE DATE NOT NULL,
LOAD_TIME_START TIMESTAMP,
LOAD_TIME_END TIMESTAMP
)
WITH REPLACE
ON COMMIT PRESERVE ROWS
NOT LOGGED;
BEGIN ATOMIC
DECLARE busdate DATE ;
SET busdate = '2013-01-31' ;
insert into SESSION.MFS select table_id,run_id,business_date,load_time_start,load_time_end from liquidity.met_feed_status where business_date= busdate;
END
select * From SESSION.MFS
No comments:
Post a Comment