|
Import Code |
CONNX Data Type |
SQL Data Type |
SQL Length |
VMS Equivalent Data Types |
Description |
|
266 |
Word (BE) -> Double |
DOUBLE |
8 |
|
|
|
267 |
Longword Decimal Big Endian |
DOUBLE |
8 |
|
|
|
268 |
Binary (Text) Reversed |
CHAR |
-2 |
|
|
|
269 |
Comment Prefix |
VARCHAR |
-8 |
|
|
|
270 |
Float IEEE 4-byte |
REAL |
4 |
|
|
|
271 |
Float IEEE 4-byte (BE) |
REAL |
4 |
|
|
|
272 |
Double IEEE 8-byte |
DOUBLE |
8 |
|
|
|
273 |
Double IEEE 8-byte (BE) |
DOUBLE |
8 |
|
|
|
274 |
CISAM Packed Decimal 1 |
DOUBLE |
8 |
|
|
|
275 |
CISAM Packed Decimal 2 |
VARCHAR |
128 |
|
|
|
276 |
PROIV Date |
DATE |
6 |
|
|
|
277 |
Astrazeneca Interval |
VARCHAR |
18 |
|
|
|
278 |
CISAM Zoned Numeric -> Double |
DOUBLE |
8 |
|
|
|
279 |
CISAM Zoned Numeric -> Integer |
LONG |
4 |
|
|
|
280 |
CISAM DIBOL Date (5 bytes) |
DATE |
6 |
|
|
|
281 |
Time (Text HHMM) |
TIME |
6 |
|
|
|
282 |
Time (Text HHMMSS) |
TIME |
6 |
|
|
|
283 |
Pinnacle Date |
DATE |
6 |
|
|
|
284 |
Quadword (BE) -> Char |
VARCHAR |
20 |
|
|
|
285 |
Quadword (BE) -> Char (DP) |
VARCHAR |
20 |
|
|
|
286 |
VarLen Int (BE) -> Char |
CHAR |
20 |
|
|
|
287 |
VarLen Int (BE) -> Char DP |
CHAR |
20 |
|
|
|
288 |
Quadword (BE) -> Double |
DOUBLE |
8 |
|
|
|
289 |
VarLen Int (BE) -> Double |
DOUBLE |
8 |
|
|
|
290 |
VarLen Int -> Double |
DOUBLE |
8 |
|
|
|
291 |
Unsigned Word 2 bytes (BE) |
SMALLINT |
2 |
|
|
|
292 |
Unsigned Long 4 bytes (BE) |
INTEGER |
4 |
|
|
|
293 |
Unsigned Word Decimal (BE) |
DOUBLE |
8 |
|
|
|
294 |
Unsigned Long (BE) -> Double |
DOUBLE |
8 |
|
|
|
295 |
Unsigned Quad (BE) -> Char |
VARCHAR |
20 |
|
|
|
296 |
Unsigned Quad (BE) -> Char(DP) |
VARCHAR |
20 |
|
|
|
297 |
Unsigned VarLen Int(BE)->Char |
CHAR |
20 |
|
|
|
298 |
Unsigned VarLen Int(BE)->Char(DP) |
CHAR |
20 |
|
|
|
299 |
Unsigned Quadword Double (BE) |
DOUBLE |
8 |
|
|
|
300 |
Unsigned VarLen Int (BE) -> Dbl |
DOUBLE |
8 |
|
|
|
301 |
Unsigned Byte Double |
DOUBLE |
8 |
|
Single unsigned byte value converts to a SQL Double |
|
302 |
PostgreSQL Timestamp |
TIMESTAMP |
16 |
|
|
|
303 |
PostgreSQL Date |
DATE |
6 |
|
|
|
304 |
PostgreSQL Time |
TIME |
8 |
|
|
|
305 |
CA Window |
VARCHAR |
155 |
|
|
|
306 |
CA Bit Flag |
INTEGER |
4 |
|
Customer-specific (1 byte of individual bit flags) |
|
307 |
4C Date |
DATE |
6 |
|
Date in the form of days since 12/31/1799 converts to SQL Date |
|
308 |
Gestepargne Date |
DATE |
6 |
|
|
|
309 |
Byte Numeric -> Decimal |
DECIMAL |
5 |
|
Single signed byte value converts to a SQL Decimal |
|
310 |
Word Numeric -> Decimal |
DECIMAL |
7 |
|
Two-byte signed value converts to a SQL Decimal |
|
311 |
Longword -> Decimal |
DECIMAL |
12 |
|
Three-byte signed value converts to a SQL Decimal |
|
312 |
Quadword -> Decimal |
DECIMAL |
21 |
|
Four-byte signed value converts to a SQL Decimal |
|
313 |
Zoned Numeric-> Decimal |
DECIMAL |
-6 |
|
String of digits with sign overpunched in lowest (right) digit converts to SQL Decimal |
|
314 |
Packed Decimal -> Decimal |
DECIMAL |
-7 |
|
Packed decimal converts to SQL Decimal |
|
315 |
Signed Overpunch -> Decimal |
DECIMAL |
-6 |
|
Overpunched decimal converts to SQL Decimal |
|
316 |
PACKED (A) Decimal -> Decimal |
DECIMAL |
-7 |
|
Packed decimal to SQL Decimal, value of 'A' denotes negative |
|
317 |
PACKED (E) Decimal -> Decimal |
DECIMAL |
-7 |
|
Packed decimal to SQL Decimal, value of 'E' denotes negative |
|
318 |
PACKED (F) Decimal -> Decimal |
DECIMAL |
-7 |
|
Packed decimal to SQL Decimal, value of 'F' denotes negative |
|
319 |
Left Separate -> Decimal |
DECIMAL |
-10 |
|
Character to SQL Decimal with leading sign |
|
320 |
Right Separate -> Decimal |
DECIMAL |
-10 |
|
Character to SQL Decimal with trailing sign |
|
321 |
National Compressed -> Decimal |
DECIMAL |
-11 |
|
Customer-specific numeric to SQL Decimal |
|
322 |
Flex Numeric |
DECIMAL |
-1 |
|
|
|
323 |
VarLen Integer -> Decimal |
DECIMAL |
-11 |
|
Binary variable length integer to SQL Decimal |
|
324 |
POISE Txt (Right Pad) -> Decimal |
DECIMAL |
-1 |
|
Customer-specific character to SQL Decimal |
|
325 |
PACKED Decimal COMP6 -> Decimal |
DECIMAL |
-13 |
|
Unsigned packed decimal to SQL Decimal |
|
326 |
CISAM Zoned Numeric |
DECIMAL |
-6 |
|
|
|
327 |
Quadword (BE) -> Decimal |
DECIMAL |
21 |
|
|
|
328 |
VarLen Int -> Decimal |
DECIMAL |
-11 |
|
Integer (2, 4, 8 bytes) to SQL Decimal (string) (DEPRECATED) |
|
329 |
Unsigned Quadword(BE) -> Dec |
DECIMAL |
21 |
|
|
|
330 |
VarLen Int (BE) -> Decimal |
DECIMAL |
-11 |
|
|
|
331 |
Unsigned VarLen Int(BE)->Dec |
DECIMAL |
-12 |
|
|
|
332 |
Text -> Decimal |
DECIMAL |
-6 |
|
Character to SQL Decimal |
|
333 |
Unsigned Byte -> Decimal |
DECIMAL |
5 |
|
Unsigned byte number to SQL Decimal |
|
334 |
Unsigned Word (BE) -> Decimal |
DECIMAL |
7 |
|
|
|
335 |
Unsigned Long (BE) -> Decimal |
DECIMAL |
12 |
|
|
|
336 |
Word (BE) -> Decimal |
DECIMAL |
7 |
|
|
|
337 |
Longword (BE) -> Decimal |
DECIMAL |
12 |
|
|
|
338 |
RDB Date VMS (String) |
TIMESTAMP |
16 |
|
|
|
339 |
Mark BIB Number |
LONG |
4 |
|
|
|
340 |
Unsigned PK(F) Dt (DDMMYY) |
DATE |
6 |
|
Packed date DDMMYY to SQL Date |
|
341 |
Unsigned PK(F) Dt (DDMMYYYY) |
DATE |
6 |
|
Packed date DDMMYY to SQL Date |
|
342 |
Unsigned PK(F) Dt (YYMMDD) |
DATE |
6 |
|
Packed date YYMMDD to SQL Date |
|
343 |
Unsigned PK(F) Dt (YYYYMMDD) |
DATE |
6 |
|
Packed date YYYYMMDD to SQL Date |
|
344 |
Unsigned PK(F) Dt (MMDDYY) |
DATE |
6 |
|
Packed date MMDDYY to SQL Date |
|
345 |
Unsigned PK(F) Dt (MMDDYYYY) |
DATE |
6 |
|
Packed date MMDDYYYY to SQL Date |
|
346 |
Unsigned PK(F) Dt 2000(DDMMYY) |
DATE |
6 |
|
Packed date DDMMYY date window to SQL Date |
|
347 |
Unsigned PK(F) Dt 2000(YYMMDD) |
DATE |
6 |
|
Packed date YYMMDD date window to SQL Date |
|
348 |
Unsigned PK(F) Dt 2000(MMDDYY) |
DATE |
6 |
|
Packed date MMDDYY date window to SQL Date |
|
349 |
CISAM Zoned Decimal |
DECIMAL |
-6 |
|
|
|
350 |
Word Big Endian Date (2 bytes) |
DATE |
6 |
|
|
|
351 |
Word Big Endian Time (4 bytes) |
TIME |
6 |
|
|
|
352 |
Word Big Endian Timestamp |
TIMESTAMP |
16 |
|
|
|
353 |
Timestamp12 (YYYYMMDDHHMM) |
TIMESTAMP |
16 |
|
Character Timestamp with year, month, day, hour, and minute |
|
354 |
Timestamp14 (YYYYMMDDHHMMSS) |
TIMESTAMP |
16 |
|
Character Timestamp with year, month, day, hour, minutes, and second |
|
355 |
Vector Timestamp |
TIMESTAMP |
16 |
|
Unsigned short of year, month, day, hour, minute, second, and 1000ths of a second |
|
356 |
Allport Julian Date String |
DATE |
6 |
|
Character string Julian (jumeric) date offset from 1/1/1970 |