|
Import Code |
CONNX Data Type |
SQL Data Type |
SQL Length |
VMS Equivalent Data Types |
Description |
|
226 |
Text (Left Space Padded) |
CHAR |
-1 |
|
|
|
227 |
Text Left Space Pad -> Int |
INTEGER |
4 |
|
|
|
228 |
Text Left Space Pad -> Dbl |
DOUBLE |
8 |
TextMaxcim Yes/No |
Alphanumeric and symbols. (1-30000 chars); same as Text but with left space padding. |
|
229 |
Unsigned Pk Date (DDMMYY) |
DATE |
6 |
|
Unsigned Packed Decimal Date in the specific format. |
|
230 |
Unsigned Pk Date (DDMMYYYY) |
DATE |
6 |
|
Unsigned Packed Decimal Date in the specific format. |
|
231 |
Unsigned Pk Date (YYMMDD) |
DATE |
6 |
|
Unsigned Packed Decimal Date in the specific format. |
|
232 |
Unsigned Pk Date (YYYYMMDD) |
DATE |
6 |
|
Unsigned Packed Decimal Date in the specific format. |
|
233 |
Unsigned Pk Date (MMDDYY) |
DATE |
6 |
|
Unsigned Packed Decimal Date in the specific format. |
|
234 |
Unsigned Pk Date (MMDDYYYY) |
DATE |
6 |
|
Unsigned Packed Decimal Date in the specific format. |
|
235 |
Unsigned Pk Date 2000 (DDMMYY) |
DATE |
6 |
|
Unsigned Packed Decimal Date in the specific format. |
|
236 |
Unsigned Pk Date 2000 (YYMMDD) |
DATE |
6 |
|
Unsigned Packed Decimal Date in the specific format. |
|
237 |
Unsigned Pk Date 2000 (MMDDYY) |
DATE |
6 |
|
Unsigned Packed Decimal Date in the specific format. |
|
238 |
Decimal (Formatted with DP) |
DECIMAL |
-1 |
|
|
|
239 |
Cognos PHDate 2000 |
DATE |
6 |
|
Cognos Powerhouse Date (2 bytes) converts to an ODBC Date. |
|
240 |
BOSS Julian YYYYJJJ |
DATE |
6 |
|
Site-specific, 5-byte, Y2K-compliant Julian date. |
|
241 |
EDS Julian Date YYDDD |
DATE |
6 |
|
Site-specific. |
|
242 |
EDS Date YYMMDD |
DATE |
6 |
|
Site-specific. |
|
243 |
Compressed String |
VARCHAR |
-1 |
|
All spaces removed from the text field. |
|
244 |
Reverse Text Date YYYYMMDD |
DATE |
6 |
|
Subtracts 10000000 from the date, stored physically as a character field, yielding strings that, if sorted, result in dates in descending order. |
|
245 |
Reverse Long Date YYYYMMDD |
DATE |
6 |
|
Subtracts 10000000 from the date, stored physically as a Long, yielding strings that, if sorted, result in dates in descending order. |
|
246 |
Text Null Terminated (I) |
VARCHAR |
-1 |
|
|
|
247 |
POISE Record Number |
INTEGER |
4 |
|
A special data type used only in the record field of any POISE key file. |
|
248 |
POISE Validate Code |
VARCHAR |
-8 |
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. |
|
249 |
Pk Centry Date (CYYMMDD) |
DATE |
6 |
|
|
|
250 |
Unsigned Quadword |
BIGINT |
8 |
|
|
|
251 |
CISAM Packed Decimal |
DECIMAL |
-9 |
|
|
|
252 |
Access Currency |
CURRENCY |
21 |
|
|
|
253 |
Text (Nullable) -> Integer |
INTEGER |
4 |
|
|
|
254 |
Text (Nullable) -> Double |
DOUBLE |
8 |
|
|
|
255 |
Text DB2 (Right Space Padded) |
CHAR |
-1 |
|
|
|
256 |
Text DB2 (Null Terminated) |
VARCHAR |
-1 |
|
|
|
257 |
POISE Text Date 2000 (MMDDYY) |
DATE |
6 |
|
POISE Text Date in the specified format. Handles years between 1941 and 2040. |
|
258 |
POISE Text Date (MMDDYYYY) |
DATE |
6 |
|
POISE Text Date in the specified format. |
|
259 |
POISE Double (Right Padded) |
DOUBLE |
8 |
|
ASCII double left space padded with explicit decimal point and sign. Used to convert the data type in POISE RMS key field(s). |
|
260 |
POISE Julian Date |
DATE |
6 |
|
2 byte, Julian format (1=01/01/1970) |
|
261 |
POISE Time |
TIME |
6 |
|
2-byte field contains minutes after midnight. |
|
262 |
Word (big endian) |
SQL_SMALLINT |
2 |
|
|
|
263 |
Longword |
SQL_INTEGER |
4 |
|
|
|
264 |
Single Prec float (Mainframe) |
REAL |
4 |
|
|
|
265 |
Double Prec float (Mainframe) |
DOUBLE |
8 |
|
|