IA and ODBC SQL Server TIMESTAMP data type

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

IA and ODBC SQL Server TIMESTAMP data type

Post by qt_ky »

I am running IA on AIX with ODBC pointed at SQL Server.

Some columns have TIMESTAMP data type, and IA reports such columns as data type "BINARY" with length "8" and status as "Cannot Analyze" and "Not Analyzed." Why is this? Is there a way to get IA to process these columns? When you View Sample Data from IA, they display OK.

SQL Server DATETIME columns on the other hand import and display in IA just fine and column analysis runs well on those types.

The ODBC driver I am using is .../branded_odbc/lib/VMsqls00.so
Description=DataDirect SQL Server Native Wire Protocol
Choose a job you love, and you will never have to work a day in your life. - Confucius
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

I am getting an idea from google that Microsoft TIMESTAMP data types are not timestamps at all but rather are just some sort of "rowversion" counter. That might explain why all the binary columns in each table are named "rowversion." Really, Microsoft? Really?
Choose a job you love, and you will never have to work a day in your life. - Confucius
truenorth
Participant
Posts: 139
Joined: Mon Jan 18, 2010 4:59 pm
Location: San Antonio

Post by truenorth »

Strange indeed. Dumb more like.
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
Post Reply