Originally posted by: Liv2luv

I am trying to map some fields between XML (input) and Cobol (output). All other fields are getting mapped when I am using their value. But, the Date Type is not getting mapped. The Trace file says:

(Level 5: Offset 276, len 21, comp 2 of 2, #1, DI 00000013:) Data at offset 276 (
'20091119</ns:req...') is INVALID data of TYPE X
'002A' (Value reqDate Element XSD).

In the XSD, the element type is Date. In the Cobol type tree Following are the settings in Extender properties:

Item subClass : Text
Interpret as : Character
Size (content)
|_ Max
|_Characters : 8

Please help. Let me know if I am missing something important for you to understand the issue.

Thanks.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Hi,

Please use DATETOTEXT function in your mapping.

Thanks,
Deepthi
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: repanzer

Anytime you go from one "type" definitino to another, you have to use a function to do so; TEXTTODATE, DATETOTEXT, NUMBERTOTEXT, TEXTTONUMBER, etc. I would read through the function guide to know what functions are avaible.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: Liv2luv

Thanks Deepthi and repanzer for the reply.

I have figured out that the XSD is expecting a date in yyyy-mm-dd format which was corrected in my input file.

Now I have another issue. How can I get the yyyy-mm-dd translated to CCYYMMDD in cobol copybook?

I tried making use of FROMDATETIME function etc but does not work. My output shows all zero's instead of any numbers. Attached is my project file in ZIP format, you may want to have a look and suggest me a way out.

Thanks.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender