Information icon IBM InfoSphere Information Server, Version 8.5
space Feedback

Timestamp Type

About this task

Timestamp types cannot be handled automatically by importing the SQL Server metadata. They always need to be set up manually.

Parent topic: Handling SQL Server Data Types

For the column that you want to contain a Timestamp data type:

Procedure

  1. Set the SQL Type to Integer.
  2. Set the length to 10.
  3. Set the data element to SQL.ROWVERNUM.

Results

Data will be read in as an integer.

For pseudo-timestamp data:

About this task

(where the data is timestamp but the column in the database is defined as binary):

Procedure

  1. Set the SQL Type to Integer.
  2. Set the length to 10.
  3. Set the data element to SQL.BINARY8.

Results

Data will be read in as an integer, and written to a database as a binary.

PDFThis topic is also in the IBM InfoSphere DataStage and QualityStage Connectivity Guide for ODBC.

Update timestamp Last updated: 2011-3-2