Creating an external type table

About this task

This topic explains the steps to create an external type table.

Procedure

  1. Enter mandatory fields such as Table Name and Table Owner.
  2. Select one of External Fixed, External delimited, External Informix table type from Table Type dropdown.
  3. Click on Add Columns for adding columns to the table.
  4. To cancel Create Table operation, click on Cancel button.
  5. Next button will be enabled once user adds columns to the table.
  6. By clicking on Add Column button, a pop up will appear to add column details.
  7. Enter all the mandatory field values(*).
  8. User can add multiple columns using the same pop up.
  9. To go back to the main screen, click on Close button or Cross icon.
  10. Once columns are added, user can view, edit , delete any of the columns.
  11. Once column details are finalized click on Next button to go to External Table Options.
  12. Provide information for external table options & add mandatory data file by clicking on +Add button.
  13. Following pop up is used to add data files to an external table.
  14. Once data files are added, user can view, edit , delete any of the data files.
  15. Once External table options are finalized click on View Query & Create button to view SQL query for creating the table.
  16. User can either go Back or Cancel the operation using respective buttons.
  17. After clicking on View Query & Create button from the external table option, user will be able to view create table query as shown in the screen below.
  18. Click Create button to create the table.
  19. If table is created successfully information status message will be shown and user will be taken back to Schema Manager page.
  20. If table creation fails, error status message will be displayed and all the create table queries will be rolled back.
  21. To go back to modify any properties, click Back button and to cancel the operation of create table click on Cancel button.