Page 1 of 1
Only Time & Date is not geting extracted from JDE
Posted: Tue Jun 19, 2007 12:23 am
by monalisa21
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.
Posted: Tue Jun 19, 2007 1:27 am
by ray.wurlod
JD Edwards has an idiosyncratic way to store dates. Extract them as VarChar and convert them within your job. Search the forum for examples.
Posted: Tue Jun 19, 2007 3:24 am
by monalisa21
ray.wurlod wrote:JD Edwards has an idiosyncratic way to store dates. Extract them as VarChar and convert them within your job. Search the forum for examples. ...
It is extracted as varchar.
Point is that same job with different source file is working fine.
Posted: Tue Jun 19, 2007 4:54 am
by ray.wurlod
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.
Posted: Tue Jun 19, 2007 4:59 am
by monalisa21
ray.wurlod wrote: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. ...
No same data extracted correctly in DS6.0 ver for same job.
Posted: Tue Jun 19, 2007 5:43 am
by ray.wurlod
Post some lines from this file. Also post what the structure (metadata) is.
And please delete the duplicate posts you have in the server forum.