SP WITH INPUT DATE PARM

[Ann28]

Hello everyone -

DB2 UDB 8.2
CR 9

Any help is appreciated!!!

I am trying to create a SP with input parameters.

parms:
?date, ?from high (from DOHIGH to DOSTAN) / from standard (from DOSTAN to DOHIGH)

Data:

MEMBER_SSN END_DATE BENEFIT_PLAN

---------- -------- ------------

99999999  2003/01/31 DOSTAN      
99999999  2004/01/31 DOHIGH      

99999999  2005/07/31 DOOPTI      

99999999  2005/07/31 DOHIGH

The user enters the date parm, need to select fields from the table where the date = or the next highest to the entered date
Check the BENEFIT_PLAN and if DOSTAN (standard) or DOHIGH (high) then display:

For example, the user entered : '07/2002' , from_standard

Display the change:

HIGH: 99999999 2005/07/31 DOHIGH
STANDARD: 99999999 2003/01/31 DOSTAN

Thanks a lot,
Ann

 

[Ann28]

Apologize for the obscure question
Please disregard….
Ann