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 |