BIGINT Support - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Preprocessor2
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-11-20
dita:mapPath
nyr1691484085721.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
xfi1470440464166
Product Category
Teradata Tools and Utilities

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;
	}