Release Notes › Known Issues › Endpoint Types › DB2 and DB2 for z/OS › Unable to Save a Date Datatype due to Data Type Mismatch

Unable to Save a Date Datatype due to Data Type Mismatch

Symptom:

When I set date type attribute on a DB2 endpoint (JDBC DB2 for IBM i), the following error is displayed:

Bad SQL Grammar: Data type mismatch. (YYYY-MM-DD)

Solution:

Edit the Connection URI on the endpoint page in Provisioning Manager and add date format=iso. The final URI appear as:jdbc:as400://<host>:CA Portal/<db>;prompt=false;date format=iso;. Note the spacing between date and format.