When connected to a DB2 UDB for iSeries database (v5r4) and a table for query view is opened, if there are rows where a date column has the value of "1000-01-01" the query display fails. The message "SQL0181 Value in date, time or timestamp string not valid" is displayed. This is a valid date for DB2. Because of the error, you cannot open the table for view.
Log in to post a comment.