|
CONNX Data Type |
Import Code |
SQL Data Type |
Length |
VMS Equivalent Data Types |
Description |
|
Marc BIB Decimal |
381 |
DECIMAL |
-1 |
|
Customer-specific base 240 number conversion |
|
Marc BIB Number |
339 |
LONG |
-1 |
|
|
|
Marc BIB Tag |
382 |
LONG |
-1 |
|
Customer-specific base 240 number conversion |
|
MAXCIM Key Date |
68 |
DATE |
4 |
|
Maxcim special key date format. |
|
MG Word Date |
408 |
DATE |
2 |
|
|
|
Morse Date |
154 |
DATE |
4 |
|
Custom Data Type for Morse Data |
|
Naftha Text |
439 |
Char |
-1 |
|
|
|
National Compressed -> Decimal |
321 |
DECIMAL |
-1 |
|
Customer-specific numeric to SQL Decimal |
|
National Compressed Double |
118 |
DOUBLE |
-1 |
|
Compressed double data type. |
|
Noah Date |
80 |
DATE |
4 |
|
Site-specific. |
|
Noah Inverse Date |
81 |
DATE |
4 |
|
Site-specific. |
|
Noah Time |
82 |
TIME |
4 |
|
Site-specific. |
|
Numeric Data (YYMMDD) |
385 |
DATE |
3 |
|
Three-byte data field were
date is taken from the decimal digits of the values. Thus a numeric
value of 750824 is interpreted as August 24 1975. Note that the
year field uses a century window where values < 25 are assigned
century 2000, everything else 1900. The new function is far more
customer specific: TPADateOfBirth (date, centuryCode) centuryCode - integer value indicating century of birth, 8 = 1800, 9 = 1900, 0 == 2000, no other valid values. |
|
Opus Date |
424 |
DATE |
6 |
|
|
|
Opus Date Packed |
425 |
DATE |
3 |
|
|
|
Pack Date (DDMMYY) |
53 |
DATE |
4 |
|
Packed Decimal in the specified format. Handles years between 1900 and 1999. |
|
Pack Date (DDMMYYYY) |
54 |
DATE |
5 |
|
Packed Decimal in the specified format. |
|
Pack Date (MMDDYY) |
57 |
DATE |
4 |
|
Packed Decimal in the specified format. Handles years between 1900 and 1999. |
|
Pack Date (MMDDYYYY) |
58 |
DATE |
5 |
|
Packed Decimal in the specified format. |
|
Pack Date (YYMMDD) |
55 |
DATE |
4 |
|
Packed Decimal Date in the specified format. Handles years between 1900 and 1999. |
|
Pack Date (YYYYMMDD) |
56 |
DATE |
5 |
|
Packed Decimal in the specified format. |
|
Pack Date 2000 (DDMMYY) |
65 |
DATE |
4 |
|
Packed Decimal Date in the specified format. Handles years between 1941 and 2040. |
|
Pack Date 2000 (MMDDYY) |
67 |
DATE |
4 |
|
Packed Decimal Date in the specified format. Handles years between 1941 and 2040. |
|
Pack Date 2000 (YYMMDD) |
66 |
DATE |
4 |
|
Packed Decimal Date in the specified format. Handles years between 1941 and 2040. |
|
Packed (A) Decimal -> Decimal |
316 |
DECIMAL |
-1 |
|
Packed decimal to SQL Decimal, value of 'A' denotes negative |
|
PACKED (A) Decimal -> Double |
100 |
DOUBLE |
-1 |
|
Packed Decimal of type (A) |
|
PACKED (A) Decimal -> Int |
101 |
LONG |
-1 |
|
Packed Decimal of type (A) |
|
Packed (E) Decimal -> Decimal |
317 |
DECIMAL |
-1 |
|
Packed decimal to SQL Decimal, value of 'E' denotes negative |
|
PACKED (E) Decimal -> Double |
102 |
DOUBLE |
-1 |
|
Packed Decimal of type (E) |
|
PACKED (E) Decimal -> Int |
103 |
LONG |
-1 |
|
Packed Decimal of type (E) |
|
Packed (F) Decimal -> Decimal |
318 |
DECIMAL |
-1 |
|
Packed decimal to SQL Decimal, value of 'E' denotes negative |
|
PACKED (F) Decimal -> Double |
104 |
DOUBLE |
-1 |
|
Packed Decimal of type (F) |
|
PACKED (F) Decimal -> Int |
105 |
LONG |
-1 |
|
Packed Decimal of type (F) |
|
Packed Decimal -> Decimal |
314 |
DECIMAL |
-1 |
|
Packed decimal converts to SQL Decimal |
|
Packed Decimal COMP6 -> Double |
224 |
DOUBLE |
-1 |
VMS Packed Decimal PIC S9(X1)V9(X2) COMP-3 |
Packed Decimal (1-255 bytes) converts to a double precision floating point; same as Packed Decimal (Double) but unsigned. |
|
Packed Decimal COMP6 -> Decimal |
325 |
DECIMAL |
-1 |
|
Unsigned packed decimal to SQL Decimal |
|
Packed Decimal COMP6 -> Integer |
225 |
LONG |
-1 |
VMS Packed Decimal PIC S9(X1)V9(X2) COMP-3 |
Packed Decimal (1-255 bytes) converts to a long; same as Packed Decimal (Integer) but unsigned. |
|
Packed Decimal -> Currency |
73 (1047 for backward compatibility.) |
CURRENCY |
-1 |
|
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. |
|
Packed Decimal -> Double |
22 (1014 with fraction > 0 for backward compatibility.) |
DOUBLE |
-1 |
VMS Packed Decimal PIC S9(X1)V9(X2) COMP-3 |
Packed Decimal (1-255 bytes) converts to a double precision floating point. |
|
Packed Decimal -> Integer |
23 (1014 with fraction = 0 for backward compatibility.) |
LONG |
-1 |
VMS Packed Decimal PIC S9(X1)V9(X2) COMP-3 |
Packed Decimal (1-255 bytes) converts to a long. |
|
Pinnacle Date |
283 |
DATE |
6 |
|
|
|
PioTech Date |
443 |
SQL_DATE |
6 |
|
|
|
PioTech Numeric |
442 |
SQL_BIGINT |
4 |
|
|
|
Pk Centry Date (CYYMMDD) |
249 |
DATE |
4 |
|
|
|
POISE Double |
95 |
DOUBLE |
-1 |
|
ASCII double left space padded with explicit decimal point and sign. |
|
POISE Double (Right Padded) |
259 |
DOUBLE |
-1 |
|
ASCII
double right space padded with explicit decimal point and sign. |
|
POISE Julian Date |
260 |
DATE |
2 |
|
2 byte, Julian format (1 = 01/01/1970) |
|
POISE Record Number |
247 |
INTEGER |
4 |
None |
A special data type used only in the record field of any POISE key file. |
|
POISE Text Date (MMDDYYYY) |
258 |
DATE |
8 |
|
POISE Text date in the specified format. |
|
POISE Text Date 2000 (MMDDYY) |
257 |
DATE |
6 |
|
POISE Text date in the specified format. Handles years between 1941 and 2040. |
|
POISE Time |
261 |
TIME |
2 |
|
2 byte field contains minutes after midnight. |
|
POISE Txt (Right Pad) -> Decimal |
324 |
DECIMAL |
-1 |
|
Customer-specific character to SQL Decimal |
|
POISE Validate Code |
248 |
VARCHAR |
-1 |
None |
A short code descriptor is populated in the CDD comment field. When the field is displayed using CONNX, the code descriptor prefixes the data value. |
|
PostgreSQL Numeric -> Decimal |
406 |
DECIMAL |
-1 |
|
|
|
PROMIS Timesetamp |
418 |
TIMESTAMP |
4 |
|
|
|
Quadword -> Char |
15 |
CHAR |
8 |
|
|
|
Quadword -> Char (DP) |
16 |
CHAR |
8 |
|
|
|
Quadword -> Currency |
72 (1033 for backward compatibility.) |
CURRENCY |
8
|
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.
|
|
Quadword -> Decimal |
312 |
DECIMAL |
8 |
|
Four-byte signed value converts to a SQL Decimal |
|
Quadword -> Double |
171 |
DOUBLE |
8 |
VMS Quadword Integer with implied decimal PIC S9(X1)V9(X2) COMP where X1+X2 is between 10 and 20. |
Quadword Integer with an implied decimal place (8 bytes) converts to a SQL Double. |
|
Quadword -> Char |
15 (1029 for backward compatibility.) |
VARCHAR |
8 |
VMS Quadword Integer PIC S9(X1)V9(X2) COMP where X1+X2 is between 10 and 20. |
Quadword Integer (8 bytes) converts to a SQL String. |
|
Quadword (BE) -> Char |
284 |
VARCHAR |
8 |
|
|
|
Rev Encapsulated Date (MMDDcy) |
389 |
SQL_DATE |
6 |
|
Byte 0 -> binary number representing the most significant two digits of a four digit year. Byte 1 -> binary number representing the least significant two digits of a four digit year. Thus, if given the first two bytes values of 20, 03, the year for this date are 2003. Bytes 2 & 3 are the numeric characters representing the month of the year. Bytes 4 & 5 are the numeric characters representing the day of the month. Thus a value of 0x010131313131 is a date of November (month 11) 11 (day 11) in the year 101. |
|
Reverse CODA Year |
77 |
SMALLINT |
2 |
|
Coda Year with bytes reversed. |
|
Reverse Long Date YYYYMMDD |
245 |
DATE |
4 |
|
Subtracts 100000000 from the date, stored physically as a Long, yielding numbers that, if sorted, result in dates in descending order. |
|
Reverse Text Date YYYYMMDD |
244 |
DATE |
8 |
|
Subtracts 100000000 from the date, stored physically as a Long, yielding numbers that, if sorted, result in dates in descending order. |
|
Reverse VMS 4 Byte Date |
75 |
DATE |
4 |
|
VMS 4-byte date with bytes reversed. |
|
Reverse VMS Date |
30 |
DATE |
8 |
Maxcim Date |
VMS Binary Date/Time (8 Bytes) converts to an ODBC Date. All bytes are stored in reverse order. |
|
Reverse VMS Date/Time |
32 |
TIMESTAMP |
8 |
|
VMS Binary Date/Time (8 bytes) converts to an ODBC Timestamp. All bytes are stored in reverse order. |
|
Reverse VMS Time |
31 |
TIME |
8 |
|
VMS Binary Date/Time (8 bytes) converts to an ODBC Time. All bytes are stored in reverse order. |
|
Reverse VMS Date (6 byte) |
157 |
DATE |
6 |
|
Reversed VMS Date stored in 6 bytes (fractional second precision is truncated). |
|
Right Separate -> Decimal |
320 |
DECIMAL |
-1 |
|
Character to SQL Decimal with trailing sign |
|
Right Separate -> Double |
112 |
DOUBLE |
-1 |
Right Separate |
Right Separate Double |
|
Right Separate -> Integer |
113 |
LONG |
-1 |
Right Separate |
Right Separate Integer |
|
Signed Overpunch -> Decimal |
315 |
DECIMAL |
-1 |
|
Overpunched decimal converts to SQL Decimal |
|
Signed Overpunch -> Double |
24 (1011 with fraction > 0 for backward compatibility.) |
DOUBLE |
-1 |
VMS Numeric String left overpunched sign |
Signed Overpunch (1-255 digits) converts to a double precision floating point. |
|
Signed Overpunch -> Integer |
25 (1011 with fraction = 0 for backward compatibility.) |
LONG |
-1 |
VMS Numeric String left overpunched sign |
Signed Overpunch (1-255 digits) converts to a long |
|
Text -> Decimal |
332 |
DECIMAL |
-1 |
|
Character to SQL Decimal |
|
Text -> Double |
18 |
DOUBLE |
-1 |
|
|
|
Text -> Integer |
17 |
INTEGER |
-1 |
|
|
|
Text (Expandable) |
3 |
VARCHAR |
-1 |
|
Alphanumeric and symbols. (1-30000 chars). |
|
Text (Formatted) -> Double |
19 |
DOUBLE |
-1 |
|
|
|
Text (Null Terminated) |
2 |
VARCHAR |
-1 |
|
|
|
Text (Nullable) -> Double |
254 |
DOUBLE |
-1 |
|
|
|
Text (Nullable) -> Integer |
253 |
INTEGER |
-1 |
|
|
|
Text (Left Space Padded) |
228 |
CHAR |
1-30000 |
Text Maxcim Yes/No |
Alphanumeric and symbols. (1-30000 chars); same as Text but with left space padding. |
|
Text (Right Space Padded) |
1 (1000 for backward compatibility.) |
CHAR |
1-30000 |
Text Maxcim Yes/No |
Alphanumeric and symbols. (1-30000 chars); same as Text but with right space padding. |
|
Text Currency |
69 (1046 for backward compatibility.) |
CURRENCY |
1-20 |
|
Numeric money value stored as ASCII text with implied decimal point. |
|
Text Date (DD) |
399 |
DATE |
2 |
|
For DD, if DD = 30, the SQL date would be January 30, 2003. The year returned is the current year. The month is always January. |
|
Text Date (DDMMYY) |
41 (1042 for backward compatibility.) |
DATE |
6 |
|
Text Date in the specified format. Handles years between 1900 and 1999. |
|
Text Date (DDMMYYYY) |
42 (1043 for backward compatibility.) |
DATE |
8 |
|
Text Date in the specified format. |
|
Text Date (MM) |
398 |
DATE |
2 |
|
For MM, if MM was 11, the SQL date would be November 1, 2003. The year returned is the current year. The day of the month is always one. |
|
Text Date (MMDDYY) |
45 (1050 for backward compatibility.) |
DATE |
6 |
|
Text Date in the specified format. Handles years between 1900 and 1999. |
|
Text Date (MMDDYYYY) |
46 (1051 for backward compatibility.) |
DATE |
8 |
|
Text Date in the specified format. |
|
Text Date (MMYYYY) |
394 |
DATE |
6 |
|
For MMYYYY, if MMYYYY was 032002, the SQL date would be March 1, 2003. The day of the month is always one (1). |
|
Text Date (YYMMDD) |
43(1044 for backward compatibility.) |
DATE |
6 |
|
DATE 6 Text Date in the specified format. Handles years between 1900 and 1999. |
|
Text Date (YYYY) |
396 |
DATE |
4 |
|
For YYYY, if YYYY was 2004, the SQL date would be January 1, 2004. The day of the month is always one (1). The month is always January. |
|
Text Date (YYYYMM) |
392 |
DATE |
6 |
|
For YYYYMM, if YYYYMM was 200203, the SQL date would be March 1, 2003. The day of the month is always one (1). |
|
Text Date (YYYYMMDD) |
44 (1055 for backward compatibility.) |
DATE |
8 |
|
Text Date in the specified format. |
|
Text Date 2000 (DDMMYY) |
59 |
DATE |
6 |
|
Text Date in the specified format. Handles years between 1941 and 2040. |
|
Text Date 2000 (MMDDYY) |
60 |
DATE |
6 |
|
Text Date in the specified format. Handles years between 1941 and 2040. |
|
Text Date 2000 (MMYY) |
395 |
DATE |
4 |
|
For MMYY, if MMYY was 0403, the SQL date would be April 1, 2003. The day of the month is always one (1).
For MMYY, if MMYY was 0423, the SQL date would be April 1, 1923. The day of the month is always one (1).
The break year = 20 (For years below 20.., add 2000; years above 20, add 1900. Tthe break year is configurable.) |
|
Text Date 2000 (YY) |
397 |
DATE |
2 |
|
For YY, if YY was 4, the SQL date would be January 1, 2004. The day of the months is always one. The month is always January.
For YY, if YY was 34, the SQL date would be January 1, 1934. The day of the months is always one. The months is always January.
The break year = 20 (For years below 20.., add 2000; years above 20, add 1900. Tthe break year is configurable.) |
|
Text Date 2000 (YYMM) |
393 |
DATE |
4 |
|
For YYMM, if YYMM was 0304, the SQL date would be April 1, 2003. The day of the month is always one (1). For YYMM, if YYMM was 2304, the SQL date would be April 1, 1923. The day of the month is always one (1).
The break year = 20 (For years below 20.., add 2000; years above 20, add 1900. Tthe break year is configurable.) |
|
Text Date 2000 (YYMMDD) |
61 |
DATE |
6 |
|
Text Date in the specified format. Handles years between 1941 and 2040. |
|
Text Left Space Pad -> Dbl |
228 |
DOUBLE |
-1 |
|
|
|
Text (Formatted) -> Double |
19 |
DOUBLE |
-1 |
|
|
|
Text Left Space Pad -> FmtDbl |
298 |
DOUBLE |
-1 |
|
|
|
Text Left Space Pad -> Int |
227 |
INTEGER |
-1 |
|
|
|
Text (Space Padded) No Nulls |
218 |
CHAR |
-1 |
|
|
|
Time (Text HHMM) |
281 |
TIME |
4 |
|
|
|
Time (Text HHMMSS) |
282 |
TIME |
6 |
|
|
|
Timestamp12 (YYYYMMDDHHMM) |
353 |
TIMESTAMP |
12 |
|
Character Timestamp with year, month, day, hour, and minute |
|
Timestamp14 (YYYYMMDDHHMMSS) |
354 |
TIMESTAMP |
14 |
|
Character Timestamp with year, month, day, hour, minute, and second |