64049 - You receive the message "ERROR: Numeric value out of range..." when loading a DB2 TIMESTAMP value into SAS® Cloud Analytic Services (CAS)

SUPPORT / SAMPLES & SAS NOTES

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: Numeric value out of range DATE_RESULT

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

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

Type:	Problem Note
Priority:	high

Date Modified:	2019-04-29 16:33:57
Date Created:	2019-04-17 09:59:31