DSXchange

Hi,

Having a problem I am sure I have seen before, but going over my past projects, I have not found the solution I used before.

I am updating from AS400 to the same AS400 with a hash file staging point after a transformer.

The objective is to put today's date in the target field (Decimal 15,6) in the format YYYYMMDD.

However, for todays date, I would expect for example 20080415.000000...and I SEE 20080415 in my staging point file. However, in AS400, we are getting 4258146.000000

I seem to recall this was something about needing to convert the data format before loading to character or something like that...but I cannot find an example of what I did before.

Any ideas?

Thanks

Wade

Please post how this was Resolved. Obviously you found what it was that you did. But what was it?

Thanks, Ray...confession time.

My staging point, for some reason had the YYYYMMDD field defined as datatype "Date" instead of "decimal". once I set this correctly to "decimal", the problem was resolved.