Originally posted by: SystemAdmin

I have an interesting problem with Oracle 8i dates using Mercator 6.7.1.
I am inserting dates in the format ccyy-mm-dd hh24:mm:ss and on our test system everything works ok. However on our production system all is not well. Dates of 2054 are inserted as 1954. This looks like century inferencing but I don't know what is causing it. There is nothing set in the DataStageTX map, the SQL does not use the RR format mask as far as I know (it's ok on test) so is this something in the setup of our production Oracle system which is overriding 4 character years?
Any help would be appreciated.
Jan
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Jan,

Can you get the production folks to agree to a modification to the map in production to capture the output? The easiest way to do that is probably to Set Backup-->ON-->Always in the Target Rule.

If you see the goofy dates there, then the problem is in TX. I'm going to guess that you're reading in date items with no century and that the floating century is set on in the map on the production system. If you're running in the Command Server, look for something like -D1950 in the command line. In the IFD, look for Map Settings-->Century | Sliding

Are you reading Run() settings from a config file? Maybe -D<CCYY> is set in there as some kind of system default.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

We have checked the output and the year is 4 characters. On the test system we have used a number of different centuries 1700 thru to 2300 and the dates are created correctly. Centusy is not sliding for map compilation.
The map has run under command and event server on test and event server on production.
Jan
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender