SAS calculations can return DOUBLE values smaller than Sailfish can store in a DOUBLE data type.
When a SAS dataset containing one of these values is written to Sailfish, the default datatype is DOUBLE and an error, SQL0405N, is returned. Sailfish DECFLOAT can store these values, but SAS cannot currently read this datatype from Sailfish.
Suggest a setting controlled option to request that Sailfish round or truncate very small values so that Sailfish DOUBLE can store them without failing with an error.
|Who would benefit from this IDEA?||Users of SAS statistical analysis software|
How should it work?
A numeric value is inserted or loaded into a column of type DOUBLE whose magnitude is smaller (closer to zero) than the smallest number that Sailfish's DOUBLE datatype can legally represent
The user has set the controlling option ("don't fail on DOUBLE type out of range") to TRUE
The value is silently rounded to the closest numeric value that a double can represent (or truncated to zero if that is easier to implement) prior to being stored in the DOUBLE column
|Priority Justification||SAS generates numeric values that cause DB2 to fail with an error|
|Customer Name||Cox Automotive|