|
CONNX Data Type |
Import Code |
SQL Data Type |
Length |
VMS Equivalent Data Types |
Description |
|---|---|---|---|---|---|
|
TNRD Julian Date |
357 |
Date |
2 |
|
Customer-specific Julian date offset from 1/1/1975 |
|
TNRD Rev Julian Date |
358 |
Date |
2 |
|
Customer-specific reverse Julian date offset from 1/1/1975 |
|
TNRD Identification Number |
359 |
Varchar |
-1 |
|
Customer-specific suffix delimited ID Number |
|
TNRD Surname |
360 |
Varchar |
-1 |
|
Customer-specific suffix delimited Surname |
|
TNRD First Name and Initial |
361 |
Varchar |
-1 |
|
Customer-specific suffix delimited First name and initial |
|
TNRD Care of |
362 |
Varchar |
-1 |
|
Customer-specific suffix delimited Care of |
|
TNRD Street Address Number |
363 |
Varchar |
-1 |
|
Customer-specific suffix delimited Street Address Number |
|
TNRD Street Address Name |
364 |
Varchar |
-1 |
|
Customer-specific suffix delimited Street Address Name |
|
TNRD St Address City/Province |
365 |
Varchar |
-1 |
|
Customer-specific suffix delimited Street Address City and Province |
|
TNRD St Address Postal Code |
366 |
Varchar |
-1 |
|
Customer-specific suffix delimited Street Address Postal Code |
|
TNRD Home Phone |
367 |
Varchar |
-1 |
|
Customer-specific suffix delimited Home Phone |
|
TNRD Work Phone |
368 |
Varchar |
-1 |
|
Customer-specific suffix delimited Work Phone |
|
TNRD Alt Address Num & Street |
369 |
Varchar |
-1 |
|
Customer-specific suffix delimited Alternate Street Address Number and Name |
|
TNRD Alt Address City & Prov |
370 |
Varchar |
-1 |
|
Customer-specific suffix delimited Alternate Street Address City and Province |
|
TNRD Ald Address Postal Code |
371 |
Varchar |
-1 |
|
Customer-specific suffix delimited Alternate Street Address Postal Code |
|
TNRD School |
372 |
Varchar |
-1 |
|
Customer-specific suffix delimited School |
|
TNRD Parent or Guardian |
373 |
Varchar |
-1 |
|
Customer-specific suffix delimited Parent/Guardian |
|
TNRD Previous Barcode |
374 |
Varchar |
-1 |
|
Customer-specific suffix delimited Previous Barcode |
|
TNRD Next Barcode |
375 |
Varchar |
-1 |
|
Customer-specific suffix delimited Next Barcode |
|
TNRD Xref See |
376 |
LONG |
-1 |
|
Customer-specific prefix delimited See |
|
TNRD Xref See Also |
377 |
LONG |
-1 |
|
Customer-specific prefix delimited See Also |
|
TNRD Xref See From |
378 |
LONG |
-1 |
|
Customer-specific prefix delimited See From |
|
TNRD Xref See Also From |
379 |
LONG |
-1 |
|
Customer-specific prefix delimited See Also From |
|
TNRD Notes |
380 |
Varchar |
-1 |
|
Customer-specific prefix delimited Notes |
|
Unicode Char (UTF-8) |
446 |
Varchar |
-1 |
|
|
|
Unicode L4 VarChar (UTF-8) |
448 |
Varchar |
-1 |
|
|
|
Unicode LA VarChar (UTF-8) |
448 |
Varchar |
-1 |
|
|
|
Unicode VarChar (UTF-8) |
447 |
Varchar |
-1 |
|
|
|
Unsigned Byte |
215 |
TINYINT |
1 |
|
|
|
Unsigned Byte Double |
301 |
DOUBLE |
1 |
|
Single unsigned byte value converts to a SQL Double |
|
Unsigned Long |
214 |
INTEGER |
4 |
|
|
|
Unsigned Pk(F) Dt (DDMMYY) |
340 |
DATE |
4 |
|
Packed date DDMMYY to SQL Date |
|
Unsigned Pk(F) Dt (DDMMYYYY) |
341 |
DATE |
5 |
|
Packed date DDMMYYYY to SQL Date |
|
Unsigned Pk(F) Dt (MMDDYY) |
344 |
DATE |
4 |
|
Packed date MMDDYY to SQL Date |
|
Unsigned Pk(F) Dt (MMDDYYYY) |
345 |
DATE |
5 |
|
Packed date MMDDYYYY to SQL Date |
|
Unsigned Pk(F) Dt (YYMMDD) |
342 |
DATE |
4 |
|
Packed date YYMMDD to SQL Date |
|
Unsigned Pk(F) Dt (YYYYMMDD) |
343 |
DATE |
5 |
|
Packed date YYYYMMDD to SQL Date |
|
Unsigned Pk(F) Dt 2000(DDMMYY) |
346 |
DATE |
4 |
|
Packed date DDMMYY date window to SQL Date |
|
Unsigned Pk(F) Dt 2000(MMDDYY) |
348 |
DATE |
4 |
|
Packed date MMDDYY date window to SQL Date |
|
Unsigned Pk(F) Dt 2000(YYMMDD) |
347 |
DATE |
4 |
|
Packed date YYMMDD date window to SQL Date |
|
Unsigned Pk Date (DDMMYY) |
229 |
DATE |
3 |
|
Unsigned Packed Decimal Date in the specified format. |
|
Unsigned Pk Date (DDMMYYYY) |
230 |
DATE |
3 |
|
Unsigned Packed Decimal Date in the specified format. |
|
Unsigned Pk Date (YYMMDD) |
231 |
DATE |
3 |
|
Unsigned Packed Decimal Date in the specified format. |
|
Unsigned Pk Date (YYYYMMDD) |
232 |
DATE |
4 |
|
Unsigned Packed Decimal Date in the specified format. |
|
Unsigned Pk Date (MMDDYY) |
233 |
DATE |
3 |
|
Unsigned Packed Decimal Date in the specified format. |
|
Unsigned Pk Date (MMDDYYYY) |
234 |
DATE |
4 |
|
Unsigned Packed Decimal Date in the specified format. |
|
Unsigned Pk Date 2000 (DDMMYY) |
235 |
DATE |
3 |
|
Unsigned Packed Decimal Date in the specified format. |
|
Unsigned Pk Date 2000 (MMDDYY) |
237 |
DATE |
3 |
|
Unsigned Packed Decimal Date in the specified format. |
|
Unsigned Pk Date 2000 (YYMMDD) |
236 |
DATE |
3 |
|
Unsigned Packed Decimal Date in the specified format. |
|
Unsigned Quadword |
250 |
BIGINT |
8 |
|
|
|
Unsigned Word |
166 |
INTEGER |
2 |
|
Unsigned Word |
|
Unsigned Word 2 bytes (BE) |
291 |
SMALLINT |
2 |
|
|
|
Unsigned Word (BE) -> Double |
293 |
DOUBLE |
2 |
|
|
|
Varbinary |
207 |
VARBINARY |
-1 |
|
|
|
Variable Length Int -> Dbl |
169 |
CHAR |
-1 |
|
Integer data type with implied decimal precision. This type is designed to handle irregular integer sizes (3 bytes, 6 bytes, etc). |
|
VarLen Int -> Double |
290 |
DOUBLE |
-1 |
|
|
|
Variable Length Int -> Int (Deprecated) |
168 |
CHAR |
-1 |
|
Integer data type. This type is designed to handle irregular integer sizes (3 bytes, 6 bytes, etc). |
|
VarLen Integer -> Decimal |
323 |
DECIMAL |
-1 |
|
Binary variable length integer to SQL Decimal |
|
Vector Timestamp |
355 |
TIMESTAMP |
14 |
|
Unsigned short array of year, month, day, hour, minute, second, and 1000ths of a second |
|
VISTA Date (Julian 12/31/1919) |
386 |
DATE |
2 |
|
Julian Date offset from 12/31/1919. |
|
Vixen Date |
438 |
Date |
6 |
|
|
|
VMS 4 Byte Date |
74 |
DATE |
4 |
|
VMS Date with time value truncated. |
|
VMS C Date |
96 |
TIMESTAMP |
4 |
|
Date, stores number of seconds since 1/1/1970. |
|
VMS C Reverse Date |
97 |
TIMESTAMP |
4 |
|
VMS C Date with bytes reversed. |
|
VMS Date |
27 (1002 for backward compatibility.) |
DATE |
8 |
Maxcim Date |
VMS Binary Date/Time (8 Bytes) converts to an ODBC Date. |
|
VMS Date (6 byte) |
158 |
DATE |
6 |
|
|
|
VMS Date/Time |
29 |
TIMESTAMP |
8 |
|
VMS Binary Date/Time (8 Bytes) converts to an ODBC Timestamp. |
|
VMS Double |
6 |
DOUBLE |
8 |
|
|
|
VMS Double -> Currency |
405 |
CURRENCY |
8 |
|
Scale is 0 to 4. Precision = 19. |
|
VMS G Float |
114 (1018 for backward compatibility.) |
DOUBLE |
8 |
G Float |
G Float - 64-bit precision |
|
VMS H Float |
115 (1019 for backward compatibility.) |
DOUBLE |
16 |
H Float |
H Float-128-bit precision |
|
VMS Single |
5 (1018 for backward compatibility) |
REAL |
4 |
Maxcim Real |
Single precision floating point (4 bytes) |
|
VMS Time |
28 |
TIME |
8 |
|
VMS Binary Date/Time (8 Bytes) converts to an ODBC Time. |
|
VMS Date (6 byte) |
158 |
DATE |
6 |
|
VMS Date stored in 6 bytes (fractional second precision is truncated). |
|
VMS S Float |
159 (1019 for backward compatibility.) |
REAL |
4 |
S Float |
VMS IEEE Single-precision floating point |
|
VMS T Float |
160 |
DOUBLE |
8 |
T Float |
VMS IEEE Double-precision floating point |
|
VMS X Float |
156 |
DOUBLE |
16 |
X Float |
VMS IEEE X Float |
|
Winery Long Date |
93 |
DATE |
2 |
|
Special date for customer. |
|
Winery Plus Long Date |
94 |
DATE |
2 |
|
Special date for customer. |
|
Winery Plus Word Date |
92 |
DATE |
2 |
|
Special date for customer. |
|
Winery Word Date |
91 |
DATE |
2 |
|
Special date for customer. |
|
Word (BE) |
262 |
SMALLINT |
2 |
|
|
|
Word (BE) -> Double |
265 |
SQL_DOUBLE |
2 |
|
|
|
Word -> Currency |
70 (1031 for backward compatibility.) |
CURRENCY |
2 |
DEC ODBC 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. |
|
Word -> Double (2) |
98 |
DOUBLE |
2 |
|
Word converted to double with implied decimal point. |
|
Word -> Float |
12 |
REAL |
2 |
|
|
|
Word |
11 (1027 for backward compatibility.) |
SMALLINT |
2 |
VMS Word IntegerPIC S9(X1) COMPwhere X1 is between 1 and 4. |
Word Integer (2 bytes) |
|
Word Numeric -> Decimal |
310 |
DECIMAL |
2 |
|
Two-byte signed value converts to a SQL Decimal |
|
Zero Filled Text |
4 (1039 for backward compatibility.) |
CHAR |
-1 |
Maxcim Zero-filled String |
A zero-filled string is NOT filled if it contains an alpha character, otherwise, it is a zero-filled numeric string. (1-30000 chars) |
|
Zoned Numeric -> Decimal |
313 |
DECIMAL |
-1 |
|
String of digits with sign overpunched in lowest (right) digit converts to SQL Decimal |
|
ZONED NUMERIC -> Double |
20 (1015 with fraction > 0 for backward compatibility.) |
DOUBLE |
-1 |
VMS Dibol |
Converts to a double precision floating point. |
|
ZONED NUMERIC -> Integer |
21 (1015 with fraction = 0 for backward compatibility.) |
LONG |
-1 |
VMS Dibol |
Converts to a long. |
|
ZZ[deprecated] Adabas Natural Date Unpacked |
409 |
DATE |
6 |
|
|
|
ZZ[deprecated] Adabas Natural Time Unpacked |
410 |
TIME |
7 |
|
|
|
ZZ[deprecated] Adabas Natural Timestamp |
419 |
TIMESTAMP |
7 |
|
|
|
ZZ[deprecated] VarLen Int |
328 |
DECIMAL |
-1 |
|
|