R and OpenText™ Analytics Database data types
The following data types are supported when passing data to/from an R UDx:.
The following data types are supported when passing data to/from an R UDx:
| OpenText™ Analytics Database Data Type | R Data Type |
|---|---|
| BOOLEAN | logical |
| DATE, DATETIME, SMALLDATETIME, TIME, TIMESTAMP, TIMESTAMPTZ, TIMETZ | numeric |
| DOUBLE PRECISION, FLOAT, REAL | numeric |
| BIGINT, DECIMAL, INT, NUMERIC, NUMBER, MONEY | numeric |
| BINARY, VARBINARY | character |
| CHAR, VARCHAR | character |
NULL values in the database are translated to R NA values when sent to the R function. R NA values are translated into database null values when returned from the R function to the database.
Important
When specifying LONG VARCHAR or LONG VARBINARY data types, include the space between the two words. For example,datatype = c("long varchar").