Creating a virtual table

Create a virtual table that is based on a table that contains a TimeSeries subtype.

A virtual table is a relational table with the same schema as the base table, except for the TimeSeries column. The TimeSeries column is replaced with the columns of the TimeSeries subtype. The elements in the TimeSeries column are individual columns in the virtual table. The virtual table contains all the data that is in the base table, including the data that is encapsulated in the TimeSeries subtype.

To create a virtual table:

  1. On the menu of the HCL OpenAdmin Tool (OAT) for Informix®, click SQL ToolBox > TimeSeries.
  2. In the list, expand the database that contains the base table and click the table.
  3. On the Actions menu, click Create Virtual Table.
  4. Complete the fields on the page.

Copyright© 2018 HCL Technologies Limited