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..

Showing Answers 1 - 1 of 1 Answers


  • Oct 3rd, 2011

Use this db2 code-

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

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions