CICS Date Validation

I get " date of birth " details through CICS Maps from the user and i store the DD, MM , YYYY separately in different variables. I need to check whether the date entered is correct or not.. ie. Feb should've 28 days in ordinary year and 29 during leap yr.. 31 days fr jan, mar, etc and 30 days fr d other months so on.. can any1 provide a sample code for this.. or help me how to do it easily.. i need to validate this and if it is correct i need to store it in database..

Interview Candidate
Sep 29th, 2011
3
8761

CICS

Answer

Showing Answers 1 - 3 of 3 Answers

Sandeep

Oct 3rd, 2011

Use this db2 code-

exec sql
select 1 from sysibm.sysdummy1 where (provided date) < current date
end-exec

compare the entered date (yyyy-mm-dd) with the system date.