iseries issue

ratheeshknair · #1 (**permalink**) 09-16-09, 03:24

Hi Experts,

We have an issue with db2 in iseries as we are not able to get date before 1940.We are getting the value as NULL but stil the data is there in database.

Please Help
TIA

tonkuma · #2 (**permalink**) 09-16-09, 04:05

iSeries DB2 Universal Database for iSeries SQL Reference Version 5:

Quote:

Date
A date is a three-part value (year, month, and day) designating a point in time
under the Gregorian calendar16, which is assumed to have been in effect from the
year 1 A.D. The range of the year part is 0001 to 9999. The date formats *JUL,
*MDY, *DMY, and *YMD can only represent dates in the range 1940 through 2039.
.....

So, you may want to use the date format *ISO, *USA, *EUR or *JIS.

ratheeshknair · #3 (**permalink**) 09-17-09, 05:21

How to use the date format date format *ISO, *USA, *EUR or *JIS.

tonkuma · #4 (**permalink**) 09-17-09, 09:49

Quote:

How to use the date format date format *ISO, *USA, *EUR or *JIS.

I don't know exactly.
Please see manuals including "DB2 Universal Database for iSeries SQL Reference Version 5".
The SET OPTION statement may help you.

ratheeshknair · #5 (**permalink**) 10-08-09, 01:47

Thanks Tonkuma,

Can you please tell me where and how to execute the set option i tried
SET OPTION DATFMT=ISO and getting error

Internet Services

Web Development

Digital Marketing

Consumer Tech