Loading data with the IBM Informix TimeSeries Plug-in for Data Studio

Use the IBM Informix TimeSeries Plug-in for Data Studio to load data from a file into a time series.

19 June 2012

You can easily load data from an input file into an Informix® table with a TimeSeries column by using IBM® Informix TimeSeries Plug-in for Data Studio. You can also use the plug-in with IBM Optim™ Developer Studio.

You must have the following prerequisites before you load data:

  • IBM Data Studio or IBM Optim Developer Studio with the Informix TimeSeries Plug-in for Data Studio installed
  • An existing table with a TimeSeries column
  • Primary key values in your table and a time series defined for each row
  • A file of time-based data that you want to load into the database
  • Connectivity information for the Informix database server that contains the time series table

The TimeSeries plug-in includes a cheat sheet that provides detailed instructions for loading data.

The TimeSeries plug-in loads data files with the following characteristics:

  • All Informix data types are allowed.
  • The data can be formatted as a singly-delimited, doubly-delimited, fixed-width, or LSE formatted data stream: for example: one or more files, databases, or URLs.
  • The data must be ASCII characters.
  • The pipe symbol (|) is interpreted as a delimiter.
  • Field delimiters can be any ASCII character or regular expression representable in Java™ technology.
  • The maximum size of the input file is set by your Java implementation.

The maximum number of load jobs you can run simultaneously is limited by the capabilities of your computer.

Download

DescriptionNameSize
ts_datastudiots_datastudio.zip10MB

Resources

Learn

Get products and technologies

Discuss

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=791175
SummaryTitle=Loading data with the IBM Informix TimeSeries Plug-in for Data Studio
publish-date=06192012