Home
Extending Informix®Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix® includes many built-in extensions that are fully integrated in the database server. Informix® also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix®.
Informix® extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
TimeSeries Data User's GuideThe Informix® TimeSeries Data User's Guide contains information to assist you in using the TimeSeries extension with HCL Informix®.
Create and manage a time series through SQLBefore you can load time series data into the database, you must configure database objects specific to your time series. You can manage data storage and remove data as necessary. You can run SQL statements to create and manage time series.
Load data into a time seriesYou can use several methods to load data into the time series. Some methods require you to create the time series instance before you load data.
Loading data from a file into a virtual tableData that you insert into a virtual table is written to the underlying base table. Therefore, you can use the virtual table to load your data that is in a relational format in a file into a TimeSeries column. Often it is easier to format your raw data to load a virtual table than to load a TimeSeries column directly, especially if you must perform incremental loading.

Loading data from a file into a virtual table

Data that you insert into a virtual table is written to the underlying base table. Therefore, you can use the virtual table to load your data that is in a relational format in a file into a TimeSeries column. Often it is easier to format your raw data to load a virtual table than to load a TimeSeries column directly, especially if you must perform incremental loading.

About this task

You can load data from a virtual table that was created by the TSCreateVirtualTab procedure. You cannot load data from a virtual table was created by the TSCreateExpressionVirtualTab procedure.

Procedure

To load relational data through a virtual table:

Create a virtual table that is based on a time series table.
Put your input data in a single file.
Format the data according to the standard HCL Informix® load file format.
Use an Informix load utilities: dbload or the load command in DB-Access, to load the file into the virtual table.

What to do next

See the Informix Administrator's Guide for information about Informix load file formats and load utilities.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.