Need: Load timestamp including microseconds.
Source : text file
Target: SQL server table.
Target Data type : timestamp
Data element : Enabled to timestamp in the ODBC Connecter stage.
Sample Data: 2015-04-16 00:00:57.495
I am using Datastage Server job to load the data using ODBC Connector stage, but it is loading the values as 0 after seconds value. For example the value looks like 2015-04-16 00:00:57.000
If i use the Old ODBC Stage with the same settings, the value is loading as it is (2015-04-16 00:00:57.495)!
Please let me know whether i am missing to tick something in the stage level to load the data including microseconds?
Any help?
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Server jobs don't have a timestamp data type. Try reading it as a Char or VarChar data type. You may need a CAST in your SQL, but try it without that first.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
SURA wrote:I have enabled it and mentioned it in my post.
Actually no, no you didn't, at least not clearly. You did mention the word 'microseconds' one time and say something about 'enabled to timestamp' but that doesn't exactly clear it all up for us.
I would have asked the same question.
-craig
"You can never have too many knives" -- Logan Nine Fingers
You are facing the same issue in a Server job? Assuming your problem is with a parallel job, please start a new post and detail for us exactly what the issue is that you are having.
-craig
"You can never have too many knives" -- Logan Nine Fingers