Hi,
I have 'X' field in my job it is coming in as a varchar(16) we are converting it as
timestamp in the transformer .We don't have any conversion problem.
some reason we couldn't load the data into the main table.I Know the problem is with this field only. When I try to load with the current timestamp for this 'X' field it's loading.
I found that there is somedata in this field of Hours portion has >23 value and in the Seconds >60 so I tried to run the job to handle this with the fallowing function
If X [9,2]>24 or X[11,2]>60 Then '00' Else Trim(StringToDate(X[1,8],"%yyyy%mm%dd") : ' ' :
StringToTime(X[9,4] : "00" ,"%hh%nn%ss"))
But this is not working too.
Do you have any other thaughts.
Thanks.
timestamp problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What does the source "timestamp" look like? VarChar(16) is quite an unusual data type for a timestamp.
Verify that you're getting the correct source data and results by creating a small test job that sends its output to a text file, and investigate that file.
Verify that you're getting the correct source data and results by creating a small test job that sends its output to a text file, and investigate that file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA