Data Conversion

The following data type conversions are allowed within the online facility:
carcudb2
The following data type conversions are allowed within the online facility:
  • Small Integer to Small Integer, Integer, Decimal, and Float.
  • Integer to Small Integer, Integer, Decimal, and Float.
  • Decimal to Small Integer, Integer, Decimal, and Float.
  • Float to Small Integer, Integer, Decimal, and Float.
  • CHAR to CHAR, Varchar, and Long Varchar.
  • Varchar to CHAR, Varchar, and Long Varchar.
  • Graphic to Graphic, Vargraphic, and Long Vargraphic.
  • Vargraphic to Graphic, Vargraphic, and Long Vargraphic.
  • Data External to Date.
  • Time External to Time.
  • Timestamp External to Date, Time, and Timestamp.
  • ROWID to ROWID.
The Date External, Time External, and Timestamp External types listed previously are assumed to be CHAR columns in date or time format. Also, for an online character conversion, the source column character length cannot be larger than the target column character length.
The following data type conversions are allowed within the Batch Copy facility:
  • Small Integer, to Small Integer, Integer, Decimal, Float, CHAR, Varchar, and Long Varchar.
  • Integer to Small Integer, Integer, Decimal, Float, CHAR, Varchar, Long Varchar, Long Vargraphic, and Date.
  • Decimal to Small Integer, Integer, Decimal, Float, CHAR, Varchar, Long Varchar, Date, Time, and Timestamp.
  • Float to Small Integer, Integer, Decimal, Float, CHAR, Varchar, and Long Varchar.
  • CHAR to Small Integer, Integer, Decimal, Float, CHAR, Varchar, Long Varchar, Date, Time, and Timestamp.
  • Varchar to Small Integer, Integer, Decimal, Float, CHAR, Varchar, and Long Varchar.
  • Long Varchar to Small Integer, Integer, Decimal, Float, CHAR, Varchar, and Long Varchar.
  • Graphic to Graphic, Vargraphic, and Long Vargraphic.
  • Vargraphic to Graphic, Vargraphic, and Long Vargraphic.
  • Long Vargraphic to Graphic, Vargraphic, and Long Vargraphic.
  • Date External to Decimal, Float, CHAR, Varchar, Long Varchar, Date, and Timestamp.
  • Time External to Decimal, Float, CHAR, Varchar, Long Varchar, Time, and Timestamp.
  • Timestamp External to CHAR, Varchar, and Long Varchar, Date, Time, and Timestamp.
  • ROWID to ROWID.