In this blog post, let’s learn about the error message “385 Data value out of range.” in Hydra and the description of the error.
Error Message
385 Data value out of range.
Error Details
This statement attempts to put data into a view that was defined WITH CHECK OPTION, so new data has to satisfy the tests in the WHERE clause in the view. However, one or more of the data values in this current statement does not meet that test, so the alteration was not performed. Roll back the current transaction. To see what tests new data must satisfy, display the definition of the view, as follows:
SELECT seqno, viewtext FROM sysviews, systables WHERE systables.tabname = ‘viewname’ AND systables.tabid = sysviews.tabid ORDER BY seqno