17.10 - Data Type - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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

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 INOUT 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 are given for StatementInformation. When used elsewhere, these types are all indicated as the CHAR data type.

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
BLOB AS DEFERRED BY NAME 412 413 912 913 914
CLOB 416 417 916 917 918
CLOB AS DEFERRED 420 421 920 921 922
CLOB AS LOCATOR 424 425 924 925 926
UDT 432 433 932 933 934
Distinct UDT 436 437 936 937 938
Structure UDT 440 441 940 941 942
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
ARRAY - one dimension 504 505 1004 1005 1006
ARRAY - multiple dimensions 508 509 1008 1009 1010
BIGINT 600 601 1100 1101 1102
NUMBER 604 605 1104 1105 1106
VARBYTE 688 689 1188 1189 1190
BYTE 692 693 1192 1193 1194
LONGVARBYTE 696 697 1196 1197 1198
DATE with DBCAREA Date-format 'A' 748 749 1248 1249 1250
DATE with DBCAREA Date-format 'T' 752 753 1252 1253 1254
BYTEINT 756 757 1256 1257 1258
TIME 760 761 1260 1261 1262
TIMESTAMP 764 765 1264 1265 1266
TIME WITH TIME ZONE 768 769 1268 1269 1270
TIMESTAMP WITH TIME ZONE 772 773 1272 1273 1274
INTERVAL YEAR 776 777 1276 1277 1278
INTERVAL YEAR TO MONTH 780 781 1280 1281 1282
INTERVAL MONTH 784 785 1284 1285 1286
INTERVAL DAY 788 789 1288 1289 1290
INTERVAL DAY TO HOUR 792 793 1292 1293 1294
INTERVAL DAY TO MINUTE 796 797 1296 1297 1298
INTERVAL DAY TO SECOND 800 801 1300 1301 1302
INTERVAL HOUR 804 805 1304 1305 1306
INTERVAL HOUR TO MINUTE 808 809 1308 1309 1310
INTERVAL HOUR TO SECOND 812 813 1312 1313 1314
INTERVAL MINUTE 816 817 1316 1317 1318
INTERVAL MINUTE TO SECOND 820 821 1320 1321 1322
INTERVAL SECOND 824 825 1324 1325 1326
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 Text 852 853 1352 1353 1354
XML Text Deferred 856 857 1356 1357 1358
XML Text Locator 860 861 1360 1361 1362