469,331 Members | 5,129 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

How to pass the date parameter in the DB2 stored Procedure

Hi Experts,

Could you please help me in the below query?

Please help in the below situation, how can create the stored Procedure.

I need to create a stored procedure and need to pass date parameter.
whenever I execute my stored procedure,It'll extract the previous 4 days data.
e.g,If I can run on 16-11-2007 , It should extract 15,14,13,12 data
and main thing is here
If I can run on 20-11-2007(Tuesday) It should extract 19,16,15,14 data.
It can't extract data on saturday and sunday's data.

Lookforward for your Valuble suggetions.

Thanks Inadvance,
Satish Kumar.
Nov 22 '07 #1
0 2321

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Marc Pelletier | last post: by
7 posts views Thread by Zlatko MatiŠ | last post: by
5 posts views Thread by ěyvind Isaksen | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.