RE: Valid dates allowed by the operating system

They are real date fields. That DSPPFM can't handle them is weird.

Paul Nelson
Cell 708-670-6978
Office 409-267-4027
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Berendt
Sent: Thursday, December 21, 2017 7:36 AM
To: Midrange Systems Technical Discussion
Subject: Re: Valid dates allowed by the operating system

Have you tried "real" date fields?

CREATE TABLE QTEMP/PAUL (MYDATE DATE NOT NULL WITH DEFAULT)

Table PAUL created in QTEMP.

INSERT INTO QTEMP/PAUL (MYDATE) VALUES(date('2096-12-31')) WITH NC

1 rows inserted in PAUL in QTEMP.

SELECT * FROM qtemp/paul

SELECT statement run complete.
MYDATE
2096-12-31

However, you must also ensure this is set correctly:
STRSQL
F13=Services
1. Change session attributes
Date format . . . . . . . . . *ISO

With SQL embedded into RPG you would use
set option datfmt = *iso



Rob Berendt