In DS8.5 version ; I am using SQL Enterprise Stage, where I defined a column as TimeStamp(29) and exntended property set to MicroSeconds. I am able to read the data from the table.
Recently upgraded to DS 8.7Version; I exported the job and tried to view the data but its throwing error as below;
No default type conversion from type "ustring[max=27]" to type "timestamp[microseconds]"
Are there any setting to do;
I know to use the convert() or read as Nvarchar option, but in 8.5 it was converted automatically, but in 8.7 it didn't , why So ?
Any help , appreciated ....
TimeStamp Conversion Error
Moderators: chulett, rschirm, roy
Re: TimeStamp Conversion Error
Could any one help on this ? As I have around 650jobs where I need to use conversion functions to handle timestamp.
Issue Resoved;
There is no issue with version of datastage; Here we need to define the DSN's properly. In MS SQL Server 2008, we need to uncheck option for "Perform Translation for Character Data"; This will handle the timestamp with micro-seconds;
We raised a PMR on this, still IBM is working from last 1 week. I hope they will see this post
Thanks,
Ravi
There is no issue with version of datastage; Here we need to define the DSN's properly. In MS SQL Server 2008, we need to uncheck option for "Perform Translation for Character Data"; This will handle the timestamp with micro-seconds;
We raised a PMR on this, still IBM is working from last 1 week. I hope they will see this post
![Laughing :lol:](./images/smilies/icon_lol.gif)
Thanks,
Ravi