Data conventions on write operations to Oracle

Oracle columns are named identically as InfoSphere DataStage fields, with these restrictions:

• Oracle column names are limited to 30 characters. If an InfoSphere DataStage field name is longer, you can do one of the following:
  • Choose the -truncate option to configure the operator to truncate InfoSphere DataStage field names to 30 characters.
  • Use the modify operator to modify the InfoSphere DataStage field name. See Modify operator for information.
• An InfoSphere DataStage data set written to Oracle might not contain fields of certain types. If it does, an error occurs and the corresponding step terminates. However InfoSphere DataStage offers operators that modify certain data types to ones Oracle accepts:

  Incompatible Type	Operator Used to Change It
  Strings, fixed or variable length, longer than 2000 bytes	modify See Modify operator.
  Subrecord	promotesubrec See The promotesubrec operator.
  Tagged aggregate	tagbatch See The tagbatch operator.