17.10 - NUMBER - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

C Data Type Definition

typedef struct NUMBER
{
   int length;
   short scale;
   BYTE mantissa[NUMBER_MAX_MANTISSA_SIZE];
} NUMBER;

Usage

The layout of NUMBER is the same as that of the NUMBER data type when transferred to or from the client: a two byte scale followed by the significand. The maximum length is 19.

Here is an example using NUMBER in a UDF definition and C function declaration.

SQL Function Definition Equivalent C Function Declaration
CREATE FUNCTION F1(
  A NUMBER(30,2) )
RETURNS NUMBER
 ...;
void f1( NUMBER *a,
         NUMBER *result,
   ... )
{  ... }