ODBC SQL SERVER datetime imported to Designer came in as 93
Posted: Mon Feb 24, 2014 9:27 pm
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?
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?