CONNX Data Types - Import Codes - 119-225

119

ADL Math

DOUBLE

8

Site-specific.

120

ADL MMIS Number

CHAR  

23

Site-specific.

121

ADL Date

DATE

6

Site-specific.

122

ADL GL Number

DOUBLE

8

Site-specific.

123  

ADL Type Code

VARCHAR  

5

Site-specific.

124  

ADL Zip Code

LONG  

4

Site-specific.

125

ADL Old Math

VARCHAR

16

Site-specific.

126

Flex Text

CHAR

-1

127

Flex Double

DOUBLE

8

128

Flex Longword

INTEGER

4

129

Flex Date

DATE

6

130

Flex Binary

BINARY

-1

131

String Tinyint

TINYINT

1

132

String Smallint

SMALLINT

2

133

String Integer

INTEGER

4

134

String Quadword

VARCHAR

20

135

String Single

REAL

4

136

String Double

DOUBLE

8

137

RDB Date VMS

TIMESTAMP

16

138

RDB Date ANSI

DATE

6

139

RDB Time

TIME

6

140

RDB Timestamp

TIMESTAMP

16

141

Interval Day

DOUBLE

8

142

Interval Hour

DOUBLE

8

143

Interval Minute

DOUBLE

8

144

Interval Date Day/Second

DOUBLE

8

145

Interval Date Hour

DOUBLE

8

146

Interval Date Hour/Minute

DOUBLE

8

147

Interval Date Hour/Second

DOUBLE

8

148

Interval Date Minute

DOUBLE

8

149

Interval Date Minute/Second

DOUBLE

8

150

Interval Date Month

DOUBLE

8

151

Interval Date Second

DOUBLE

8

152

Interval Date Year

DOUBLE

8

153

Interval Date Year/Month

DOUBLE

8

154

Morse Date

DATE  

6

Site-specific.

155

Allport Julian Date (2 byte)

DATE  

6

Site-specific.

156

VMS X Float

DOUBLE

8

X Float VMS IEEE X Float

157

Reverse VMS Date (6 byte)

DATE  

6

Reversed VMS Date stored in 6 bytes (fractional second precision is truncated).

158

VMS Date (6 byte)

DATE  

6

VMS Date stored in 6 bytes (fractional second precision is truncated).

159

VMS S Float

REAL

4

S Float

VMS IEEE single-precision floating point.

160

VMS T Float

DOUBLE  

8

T Float

VMS IEEE double-precision floating point.

161

 KCS Compressed Integer

INTEGER

4

Site-specific.

162

KCS Phone

CHAR  

10

Site-specific.

163  

KCS Zip Code

CHAR  

9

Site-specific.

164

KCS Time (2 byte)

TIME  

6

Site-specific.

165

KCS Time (3 bytes)

TIME

6

Site-specific.

166

Unsigned Word

INTEGER  

4

Unsigned Word

167

KCS Date (3 bytes)

DATE  

6

Site-specific.

168

Variable Length Int -> intr

CHAR

20

Integer data type. This type is designed to handle irregular integer sizes (3 bytes, 6 bytes, etc.)

169  

Variable Length Int -> Dbl Decimal

CHAR

20

Integer date type with implied decimal precision. This type is designed to handle irregular integer sizes (3 bytes, 6 bytes, etc.)

170

DIBOL Date (5 bytes)

DATE

6

171

Quadword -> Double

DOUBLE

8

172

ZZ(deprecated) DB2 Binary

BINARY

-1

173

ZZ(deprecated DB2 Variable

VARBINARY

-1

174

ZZ(deprecated) DB2 Long

LONG VARBINARY

-1

175

ZZ*deprecated) DB2 CHAR

CHAR

-1

176

ZZ(deprecated) DB2 VARCHAR

VARCHAR

-1

177

ZZ(deprecated) DB2 LONGVARCHAR

LONGVARCHAR

-1

178

Word 2 Bytes

SMALLINT

2

179

DB2 Word Big Endian

SMALLINT

2

180

Longword 4 bytes

INTEGER

4

181

DB2 Longword Big Endian

INTEGER

4

182

DB2 Numeric

NUMERIC

-6

183

DB2 Numeric -> Integer

LONG

4

184

DB2 Packed Decimal

DECIMAL

-7

185

DB2 Packed Decimal -> Integer

INTEGER

4

186

DB2 ISO Date (YYYY-MM-DD)

DATE

6

187

DB2 USA Date (mm/dd/yyyy)

DATE

6

188

DB2 Eur Date (dd.mm.yyyy)

DATE

6

189

DB2 JIS Date (YYYY-MM-DD)

DATE

6

190

DB2 ISO Time (hh.mm.ss)

TIME

6

191

DB2 USA Time (hh:mm xM)

TIME

6

192

DB2 Eur Time (hh.mm.ss)

TIME

6

193

DB2 JIS Time (hh:mm:ss)

TIME

6

194

DB2 Timestamp

TIMESTAMP

16

195

DB2 IEEE 4-byte float

REAL

4

196

DB2 IEEE Big E 4-byte float

REAL

4

197

DB2 IEEE 8-byte float

DOUBLE

8

198

DB2 IEEE Big E 8-byte float

DOUBLE

8

199

DB2 Mainframe 4-byte float

REAL

4

200

DB2 Mainframe 8-byte float

DOUBLE

8

201

Decimal

DECIMAL

-6

202

CLOB

LONG VARCHAR

-1

203

BLOG

LONG VARBINARY

-1

204

Oracle Date

TIMESTAMP

16

205

Oracle Rowid

BINARY

-1

206

Oracle MLSLabel

BINARY

-1

207

Varbinary

VARBINARY

-1

208

OLE DB Date

DATE

6

209

OLE DB Time

TIME

6

210

OLE DB Timestamp

TIMESTAMP

16

211

OLE DB Number

NUMERIC

-6

212

OLE DB WSTR

UNICODE

-1

213

OLE DB Decimal

DECIMAL

-6

214

Unsigned Long

INTEGER

4

215

Unsigned Byte

TINYINT

1

216

OLE DB real

REAL

4

217

OLE DB double

DOUBLE

8

218

Text (Space Padded) No Nulls

CHAR

-1

219

Big Double

DOUBLE

8

220

Big Double Text

CHAR

48

221  

BOSS Date CCYY

DATE  

6

Site-specific, 6-byte, Y2K-compliant date.

222  

BOSS Year CCYY

SMALLINT  

2

Site-specific, 4-byte, Y2K-compliant year.

223

BOSS Julian CCYY

DATE  

6

Site-specific, 5-byte, Y2K-compliant year.

224

Packed Decimal COMP6 -> Double

DOUBLE

8

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.

225

Packed Decimal COMP6 -> Integer

LONG  

4

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.