Import Code |
CONNX Data Type |
SQL Data Type |
SQL Length |
VMS Equivalent Data Types |
Description |
43 (1044 for backward compatibility) |
Text Date (YYMMDD) |
DATE |
6 |
|
Text Date in the specified format. Handles years between 1900 and 1999. |
44 (1055 for backward compatibility) |
Text Date (YYYYMMDD) |
DATE |
6 |
|
Text Date in the specified format. |
45 (1050 for backward compatibility) |
Text Date (MMDDYY) |
DATE |
6 |
|
Text Date in the specified format. Handles years between 1900 and 1999. |
46 (1051 for backward compatibility) |
Text Date (MMDDYYYY) |
DATE |
6 |
|
Text Date in the specified format. |
47 (1035 for backward compatibility) |
Long Date (DDMMYY) |
DATE |
6 |
|
Longword Date in the specified format. Handles years between 1900 and 1999. |
48 (1036 for backward compatibility) |
Long Date (DDMMYYYY) |
DATE |
6 |
|
Longword Date in the specified format. |
49 (1037 for backward compatibility) |
Long Date (YYMMDD) |
DATE |
6 |
|
Longword Date in the specified format. Handles years between 1900 and 1999. |
50 (1038 for backward compatibility) |
Long Date (YYYYMMDD) |
DATE |
6 |
|
Longword Date in the specified format. |
51 (1048 for backward compatibility) |
Long Date (MMDDYY) |
DATE |
6 |
|
Longword Date in the specified format. Handles years between 1900 and 1999. |
52 (1049 for backward compatibility) |
Long Date (MMDDYYYY) |
DATE |
6 |
|
Longword Date in the specified format. |
53 |
Pack Date (DDMMYY) |
DATE |
6 |
|
Packed Decimal in the specified format. Handles years between 1900 and 1999. |
54 |
Pack Date (DDMMYYYY) |
DATE |
6 |
|
Packed Decimal in the specified format. |
55 |
Pack Date (YYMMDD) |
DATE |
6 |
|
Packed Decimal in the specified format. Handles years between 1900 and 1999. |
56 |
Pack Date (YYYYMMDD) |
DATE |
6 |
|
Packed Decimal in the specified format. |
57 |
Pack Date (MMDDYY) |
DATE |
6 |
|
Packed Decimal in the specified format. Handles years between 1900 and 1999. |
58 |
Pack Date (MMDDYYYY) |
DATE |
6 |
|
Packed Decimal in the specified format. |
59 |
Text Date 2000 (DDMMYY) |
DATE |
6 |
|
Text Date in the specified format. Handles years between 1941 and 2040. |
60 |
Text Date 2000 (YYMMDD) |
DATE |
6 |
|
Text Date in the specified format. Handles years between 1941 and 2040. |
61 |
Text Date 2000 (MMDDYY) |
DATE |
6 |
|
Text Date in the specified format. Handles years between 1941 and 2040. |
62 |
Long Date 2000 (DDMMYY) |
DATE |
6 |
|
Longword Date in the specified format. Handles years between 1941 and 2040. |
63 |
Long Date 2000 (YYMMDD) |
DATE |
6 |
|
Longword Date in the specified format. Handles years between 1941 and 2040. |
64 |
Long Date 2000 (MMDDYY) |
DATE |
6 |
|
Longword Date in the specified format. Handles years between 1941 and 2040. |
65 |
Pack Date 2000 (DDMMYY) |
DATE |
6 |
|
Packed Decimal Date in the specified format. Handles years between 1900 and 1999. |
66 |
Pack Date 2000 (YYMMDD) |
DATE |
6 |
|
Packed Decimal Date in the specified format. Handles years between 1900 and 1999. |
67 |
Pack Date 2000 (MMDDYY) |
DATE |
6 |
|
Packed Decimal Date in the specified format. Handles years between 1900 and 1999. |
68 |
Maxcim Key Date |
DATE |
6 |
|
Maxcim special key date format. |
69 (1046 for backward compatibility) |
Text Currency |
CURRENCY |
21 |
|
Numeric money value stored as ASCII text with implied decimal point. |
70 (1031 for backward compatibility) |
Word -> Currency |
CURRENCY |
21 |
DECODBC Word |
The Word Currency data type is identical to the Word Decimal data type, except the data is converted to a SQL Decimal instead of a SQL Double. This may provide greater precision. |
71 (1032 for backward compatibility) |
Longword Currency |
CURRENCY |
21 |
|
|
72 (1033 for backward compatibility) |
Quadword -> Currency |
CURRENCY |
21 |
DEC ODBC Quadword |
The Quadword Currency data type is identical to the Quadword Decimal data type, except the data is converted to a SQL Decimal instead of a SQL Double. This may provide greater precision. |
73 (1047 for backward compatibility) |
Packed Decimal -> Currency |
CURRENCY |
21 |
|
The Packed Decimal Currency data type is identical to the Packed Decimal data type, except the data is converted to a SQL Decimal instead of a SQL Double. This may provide greater precision. |
74 |
VMS 4 Byte Date |
DATE |
6 |
|
VMS Date with truncated Time value. |
75 |
Reverse VMS 4 Byte Date |
DATE |
6 |
|
VMS 4-byte Date with bytes reversed. |
76 |
CODA Year |
SMALLINT |
2 |
|
Word, a year is represented in a number offset from the year 1900. A value of 50 would represent 1950, and a value of 103 would represent the year 2003. |
77 |
Reverse CODA Year |
SMALLINT |
2 |
|
Coda Year with bytes reversed. |
78 |
BMS Date |
DATE |
6 |
|
3-byte Date for BMS. |
79 |
BMS Reverse Date |
DATE |
6 |
|
3-byte Reverse Date for BMS. |