Problem Note 64049: You receive the message "ERROR: Numeric value out of range..." when loading a DB2 TIMESTAMP value into SAS® Cloud Analytic Services (CAS)
 |  |  |  |  |
When loading a DB2 TIMESTAMP data type and the table contains a LONGVARCHAR data type, you can receive the following error:
ERROR: Function failed.
ERROR: The action stopped due to errors.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
After applying the hot fix, you can add the option INVALIDDATE= to your caslib. Here are the valid options:
WARN: Causes a warning when the row data is intact and the invalid date/timestamp is set to missing
SILENT: Causes the data to convert to missing and not give warnings or errors
ERROR: Causes an error
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to DB2 | Linux for x64 | V.03.03 | V.03.05 | Viya | Viya |
An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesViya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-04-29 16:33:57 |
| Date Created: | 2019-04-17 09:59:31 |