GeekInterview.com
Series: Subject: Topic:
Question: 7 of 24

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..
Asked by: Interview Candidate | Asked on: Sep 29th, 2011
Showing Answers 1 - 1 of 1 Answers
Sandeep

Answered On : 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.

  
Login to rate this answer.

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

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

CICS

COBOL

DB2

IDMS

JCL

VSAM

Interview Coaching

What will you do when you are not able to get your message across to your audience?

What do you do when things do not go as planned? Cite an example.

How to Overcome Employment Gap during interview.

Do you like working in a team or alone? Explain.

What was the most important decision you ever had to make?

Does a problem make you a better person?

What are the career options available in Software Testing Industry?

How productive are you?

Describe a time when you had to work under pressure.

Give me good reasons why should I choose you over others.

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe