DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2787
Location: USA
Points: 21022

Post Posted: Mon Sep 18, 2017 1:07 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: 11.5.0.2 + SP1
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



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2787
Location: USA
Points: 21022

Post Posted: Mon Sep 18, 2017 1:13 pm Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
truenorth
Participant



Joined: 18 Jan 2010
Posts: 118
Location: Chicago
Points: 786

Post Posted: Mon Sep 18, 2017 1:36 pm Reply with quote    Back to top    

Strange indeed. Dumb more like.

_________________
Todd
Sr Consultant, Data Governance
Chicago
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours