Editing Column properties

In the Selected list, you can change these properties for each column.

Column Description
Column Alias Specify the column alias by changing the name in Column field. Columns with defined alias are indicated by blue text color. The original column name is shown in the tooltip.
Data Type Select a new data type from Data Type drop-down box to load the column as a different data type (data casting). Only a limited set of allowed combinations is available for data type casting. Columns with a data casting set are indicated by a blue text color. The source and original data type is shown in the tooltip.
  • Integer → String
  • Integer → Decimal (Oracle DB driver, Number data type only)
  • Decimal → String
  • Decimal → Integer (Oracle DB driver, Number data type only)
  • Boolean → Integer, String
  • Date → DateTime (Oracle DB driver, Date data type only)
Properties Select column properties from the drop-down box. Available options are Identifier, Variation, Timestamp and Delete indicator. When Delete indicator is selected, the Delete value must be specified.

See "Data catalog" in the Infor ION Desk User Guide.