Only Time & Date is not geting extracted from JDE

monalisa21 · Post by **monalisa21** » Tue Jun 19, 2007 12:23 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 19, 2007 1:27 am

JD Edwards has an idiosyncratic way to store dates. Extract them as VarChar and convert them within your job. Search the forum for examples.

monalisa21 · Post by **monalisa21** » Tue Jun 19, 2007 3:24 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 19, 2007 4:54 am

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.

monalisa21 · Post by **monalisa21** » Tue Jun 19, 2007 4:59 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 19, 2007 5:43 am

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.