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.