There are many fields which are getting extracted from JDE.
But all fields except two date & time fields are exteacted as 00-00-0000 & 00:00:00.
All other fields are getting exatrcted correctly throgh that same job.
Only Time & Date is not geting extracted from JDE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Thu Nov 30, 2006 3:14 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 12
- Joined: Thu Nov 30, 2006 3:14 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If they are extracte as VarChar and coming out like that, then that's how they are in that particular source file. NO conversion takes place for VarChar. Your problem is with your data.
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.
-
- Participant
- Posts: 12
- Joined: Thu Nov 30, 2006 3:14 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: