Data Type - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
lvt1544831946862.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

The Data Type field specifies the type of data contained in a database column.

Name Type if non-nullable Type if Nullable Type if IN parameter Type if INOUT parameter Type if OUT parameter
BLOB 400 401 900 901 902
BLOB AS DEFERRED 404 405 904 905 906
BLOB AS LOCATOR 408 409 908 909 910
CLOB 416 417 917 916 918
CLOB AS DEFERRED 420 421 920 921 922
CLOB AS LOCATOR 424 425 924 925 926
VARCHAR 448 449 948 949 950
CHAR 452 453 952 953 954
LONGVARCHAR 456 457 956 957 958
VARGRAPHIC 464 465 964 965 966
GRAPHIC 468 469 968 969 970
LONGVARGRAPHIC 472 473 972 973 974
FLOAT 480 481 980 981 982
DECIMAL 484 485 984 985 986
INTEGER 496 497 996 997 998
SMALLINT 500 501 1000 1001 1002
BIGINT 600 601 1100 1101 1102
VARBYTE 688 689 1188 1189 1190
BYTE 692 693 1192 1193 1194
LONGVARBYTE 697 696 1197 1196 1198
DATE with DBCAREA Date-form 'A' 748 749 1248 1249 1250
DATE with DBCAREA Date-form 'T' 752 753 1252 1253 1254
BYTEINT 756 757 1256 1257 1258
PERIOD (DATE) 832 833 1332 1333 1334
PERIOD (TIME) 836 837 1336 1337 1338
PERIOD (TIME WITH TIME ZONE 840 841 1340 1341 1342
PERIOD (TIMESTAMP 844 845 1344 1345 1346
PERIOD (TIMESTAMP WITH TIME ZONE) 848 849 1348 1349 1350
XML Character 852 853 1352 1353 1354
XML Character-deferred 856 857 1356 1357 1358
XML Character-locator 860 861 1360 1361 1362
XML Binary 864 865 1364 1365 1366
XML Binary-deferred 868 869 1368 1369 1370
XML Binary-locator 872 873 1372 1373 1374]

The several values for each type are algorithmically related to the non-nullable value: the nullable value is one greater; the IN parameter value is 500 greater; the INPUT parameter value is 501 greater; and the OUT parameter value is 502 greater. Note that the three parameter values do not differentiate non-nullable from nullable.

Non-nullable refers to columns defined NOT NULLS.

IN, INOUT, and OUT refer to attributes for parameters on an SQL CALL statement.

The temporal data types (TIME, TIMESTAMP, TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE, INTERVAL YEAR, INTERVAL YEAR TO MONTH, INTERVAL MONTH, INTERVAL DAY, INTERVAL DAY TO HOUR, INTERVAL DAY TO MINUTE, INTERVAL DAY TO SECOND, INTERVAL HOUR, INTERVAL HOUR TO MINUTE, INTERVAL HOUR TO SECOND, INTERVAL MINUTE, INTERVAL MINUTE TO SECOND, INTERVAL SECOND) are given for the StatementInformation. When used elsewhere, these types are all indicated as the CHAR data type.