Numeric Type Double Precision for Empty Table Not Consistent with R - Aster R

Teradata Aster® R User GuideUpdate 3

Product
Aster R
Release Number
7.00.02.01
Published
December 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
fop1497542774450.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
fbp1477004286096
lifecycle
previous
Product Category
Software

RODBC displays NA for blank values and tables containing no data. R on the other hand, will return a message. This issue is caused when data is returned from the Aster Database to R, numeric columns in an empty table are recognized as "character" data types, which is a limitation of RODBC.

The NA value reported by RODBC is the result of the Aster Database returning NULL for a query with a function against an empty table that RODBC then converts to NA.