SQL Server SMALLDATETIME data type error
Moderators: chulett, rschirm, roy
SQL Server SMALLDATETIME data type error
Hi,
One of the column data type is defined as SMALLDATETIME in SQL Server when I imported it into the Datastage it changed to CHAR(16).
When I am trying to view data through DRS Stage, it's throwing an error saying "metadata mismatch, Datastage datatype and database datatype differ".
I tried writing a userdefined SQL in the stage and used all the functions like (Convert, cast, substring) but it's still throwing a warning.
I even used the ODBC stage but didn't helped.
Could any one please let me know what might causing the issue.
One of the column data type is defined as SMALLDATETIME in SQL Server when I imported it into the Datastage it changed to CHAR(16).
When I am trying to view data through DRS Stage, it's throwing an error saying "metadata mismatch, Datastage datatype and database datatype differ".
I tried writing a userdefined SQL in the stage and used all the functions like (Convert, cast, substring) but it's still throwing a warning.
I even used the ODBC stage but didn't helped.
Could any one please let me know what might causing the issue.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
I missed the server forum. But after the search I came to know that in server if we change the datatype to Timestamp it work's fine, but it didn't worked for me in Parallel. I don't know if that makes any difference but just mentioning it.
In another post it was mentioned, ODBC cannot recognize SMALLDATETIME. I think this might be the issue.
but my question would be why is that while importing the matadata through ODBC it didn't throw a warning?
I tried importing it from orchdbutil but I guess we are not set up for that.
The work around we did was to change the datatype from SMALLDATETIME to DATETIME in the SQL Server table.
I am just curious to know if anyone was able to read the data in parallel when the Data type was mentioned as SMALLDATETIME in SQL server and how you did it.
Sreeni, when I imported the metadata it is already defined as 'sql.smalldatetime'
In another post it was mentioned, ODBC cannot recognize SMALLDATETIME. I think this might be the issue.
but my question would be why is that while importing the matadata through ODBC it didn't throw a warning?
I tried importing it from orchdbutil but I guess we are not set up for that.
The work around we did was to change the datatype from SMALLDATETIME to DATETIME in the SQL Server table.
I am just curious to know if anyone was able to read the data in parallel when the Data type was mentioned as SMALLDATETIME in SQL server and how you did it.
Sreeni, when I imported the metadata it is already defined as 'sql.smalldatetime'
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am