Import Codes 43-79

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.