How are you, friends?
I have a ETL task to finish. The source is sequential file, in which a column is time type like:"10:59:40:543AM" or "8:59:40:543PM" .
So any friend can tell me a simple solution to finish it? Many thanks.
Best wishes to you!
How to read time datatype from sequential stage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Read it as VarChar and convert it to Time downstream of the Sequential File stage, as discussed in this thread.
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.