BIGINT Support - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Product
Preprocessor2 for Embedded SQL
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

BIGINT Support

Beginning with PP2 9.2 and Teradata Database V2R6.2, there is increased byte support for integer operations. The limit has increased from 4 bytes (32 bits) to 8 bytes (64 bits). A 64‑bit integer can be specified wherever integers are defined.

A TYPEDEF BIGINT statement is also output for those C systems that do not have a native datatype of BIGTYPE. For example:

typedef BIGINT long long; 

In this example, the employee number field is specified as a larger binary integer:

struct employee
	{
			BIGINT			empnum;
			double			salary;
	}