Hi
The db2 stored procedure is created with 3 parameters.&courtcode,&date1,&date2.
Since it is a daily run ,I have to use only 2 parameters.i.e &courtcode and &date1. The 3rd parameter should be put as default, which takes &date1.How to do it in Developer studio.
thanks for the help,
ram

This message has been edited. Last edited by: Kerry,

Using either the Dialogue Manager tool in the Procedure Viewer or the text editor, create a default for &DATE2:

-DEFAULTS &DATE2 = &DATE1

Or, just call the db2 procedure with parameters: &courtcode,&date1,&date1