ODBC SQL SERVER datetime imported to Designer came in as 93

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
moose2079
Premium Member
Premium Member
Posts: 48
Joined: Tue Mar 07, 2006 4:52 pm
Location: Australia

ODBC SQL SERVER datetime imported to Designer came in as 93

Post by moose2079 »

Hi there,I am connecting to SQL Server tables thru ODBC stages

when I import the DDL's I noted that data types 'date time' come in as data type '93' - which is not a valid data type

When I link the connector stages to a join stage - and I attempt to view the input columns - the page is grey with no column names - and usually - DataStage Designer fails - I assume because of the invalid data type 93

Got around problem by changing data type 93 to data type Timestamp

Is this a known problem with ODBC? or importing SQL Server tables?
YUM
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

How exactly are you importing the metadata?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”