Import Codes 226-265

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