Monday, April 22, 2013

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