TNRD to ZZ

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 |  |