Validating the date

Sriram K · New User Joined: 17 Feb 2009 Posts: 32 Location: Bangalore

Hi,

I want to validate whether the incoming date is valid or not for that i m using the below query

EXEC SQL
SELECT DATE(:WS-CHECK-DATE)
INTO :WS-TEST-DATE
FROM SYSIBM.SYSDUMMY1
END-EXEC

Is ther any other way to check the date instead of using SYSIBM.SYSDUMMY1 . Will it affect the performance if we use execute this for each record.

Ketan Varhade · Posted: Thu Aug 20, 2009 11:58 am

You can check for the return code -180 and -181 to check weather the date format and the date value is porper or not.

Sriram K · New User Joined: 17 Feb 2009 Posts: 32 Location: Bangalore

But many progarms do check for the below query often

EXEC SQL
SELECT DATE(:WS-CHECK-DATE)
INTO :WS-TEST-DATE
FROM SYSIBM.SYSDUMMY1
END-EXEC

Any idea when we should go for this. Any other way to check for valid date instead of checking the bad return code

ashimer · Posted: Thu Aug 20, 2009 12:18 pm

Do it programmatically ..

Escapa · Posted: Thu Aug 20, 2009 12:35 pm

These are threads discussed recently

www.ibmmainframes.com/viewtopic.php?t=42794&highlight=validate+date
www.ibmmainframes.com/viewtopic.php?p=192595&highlight=#192595

Raghu navaikulam · Posted: Thu Aug 20, 2009 4:46 pm

Hi Sriram

What you have coded is correct. But here also you have to check for the bad SQLCODE (-181, -180). You can also use programming technique instead of using SQL to check the validity of the date value.

Regards
Raghu