How do I add inactive, service and privilege flags into the Data Export task

  • 7011102
  • 23-Apr-2011
  • 19-Oct-2012

Resolution

After configuring all the extended attributes

This can be accomplished by running the following iiq command from a command prompt.

$sphome/WEB-INF/bin>iiq exportschema

ThIs will create the new data export scripts for the table creation under this directory $sphome/ WEB-INF/database/dataExport

Export schema written to $sphome/WEB-INF/database/dataExport/create_data_export_tables.mysql
Export schema written to $sphome /WEB-INF/database/dataExport/create_data_export_tables.oracle
Export schema written to $sphome /WEB-INF/database/dataExport/create_data_export_tables.sqlserver
Export schema written to $sphome/WEB-INF/database/dataExport/create_data_export_tables.db2

Use these scripts to create the new tables for you particular database