Format for column metadata in .osh schema files

When you specify column metadata in a .osh schema file, you can use a predefined set of data types and options in the column definitions.

The following table shows the data types and attributes that you can specify for column metadata in a .osh schema file. Any OSH data types and attributes that are not in the table are not supported for the File connector. You can specify the nullability attribute for all of the OSH data types, for example, SALES_DATE: not nullable date. By default, columns are not nullable.
Table 1. Data types and attributes for column metadata
OSH data type InfoSphere DataStage data type Other attributes
  • int8
  • uint8
 TinyInt  
  • int16
  • uint16
 SmallInt  
  • int32
  • uint32
 Integer  
  • int64
  • uint64
 BigInt  
sfloat Float  
dfloat Double  
string
  • Char
  • VarChar
No attribute
Unbounded length
[length]
Fixed length
max=[length]
Variable length
ustring
  • Nchar
  • NVarChar
No attribute
Unbounded length
[length]
Fixed length
max=[length]
Variable length
decimal Decimal
  • [precision]
  • [precision,scale]
date Date  
time Time [microseconds]
timestamp TimeStamp [microseconds]
raw
  • Binary
  • VarBinary
No attribute
Unbounded length
[length]
Fixed length
max=[length]
Variable length