| Author |
Message
|
| kalyanMD |
 Posted: Tue Jul 10, 2007 9:09 am Post subject: WDI Envelope date |
 |
|
Novice
Joined: 03 Feb 2005
Posts: 14
Location: London UK
|
Currently WDI Setup at our end transforms XML message to EDIFACT 05A ORDRSP and INVOIC messages. Header UNB segment is populated with 6 digit date [yymmdd].
Client requirement is year field should be of 4 digits
So in following segment instead of 070710 i have to send 20070710
UNB+UNOA:4+<Send TP>:ZZ+<Rec TP>:ZZ+070710:1726+000000001
But EDIFACT standards allows only 6 digit date in UNB. I have changed envelope date part of UNB to length 8 from 6 and tried message but it is not working.
Struck on this. Early help will be useful. |
|
| Back to top |
|
 |
| Tonedef |
| Posted: Tue Jul 10, 2007 1:38 pm Post subject: |
|
|
Apprentice
Joined: 05 Feb 2007
Posts: 44
|
Hi Kalyan,
have you recomplied the map ?
What error do you get ?
It is possible the std isn't a true EDIFact D05, it maybe the the D03 std. |
|
| Back to top |
|
|
| kalyanMD |
| Posted: Tue Jul 10, 2007 11:53 pm Post subject: |
|
|
Novice
Joined: 03 Feb 2005
Posts: 14
Location: London UK
|
| Tonedef wrote: |
Hi Kalyan,
have you recomplied the map ?
What error do you get ?
It is possible the std isn't a true EDIFact D05, it maybe the the D03 std. |
I have recompiled the map but documentation says that this tweaking will only affect send and receive maps and not data transformation maps. Other option is to replace data element.
I am exploring that now... |
|
| Back to top |
|
|
| Tonedef |
| Posted: Wed Jul 11, 2007 1:38 pm Post subject: |
|
|
Apprentice
Joined: 05 Feb 2007
Posts: 44
|
Kalyan,
if you have changed the value in the date to min6/ max8
envelope std -> E -> Segment -> UNB -> S004 -> Element 0017,
both send/rec and transformation maps get their values from there.
are you mapping the value from the data or are you relying on the defaults ? |
|
| Back to top |
|
|
| kalyanMD |
| Posted: Wed Jul 11, 2007 11:37 pm Post subject: |
|
|
Novice
Joined: 03 Feb 2005
Posts: 14
Location: London UK
|
I found one APAR on IBM web site where they have corrected the WDI code to use the extended length of date field. What is said in the APAR is this fix is part of CSD24. I applied CSD24 and extended length of date field to 8 so that CCYYMMDD date appers in the UNB segment. But it is still not appearing.
Step by step changes that I did
1. Applied CSD24
2. Done required configuration for CSD24
1) Bind the new WDI executables to the database
a) Change to the bind directory under the installation directory.
b) Issue the following command:
db2 -tf bindgrnt.fil
3. Changed length of the envelope element 0017 to 8.
4. Put an XML message that got translated to EDI message.
But date in UNB is still YYMMDD and not CCYYMMDD.
Somewhere it is mentioned that this change will be considered by DI only if send/receive map is used. We are using data transformation map and I think it is not applicable to data transformation maps.
Apar URL is http://www-1.ibm.com/support/docview.wss?rs=799&context=SSFKTZ&q1=EDIFACT&q2=EDIFACT+UNB&q3=EDIFACT+UNB+date+format&uid=swg1IC50219&loc=en_US&cs=utf-8&lang=en
Env is WDI 3.2.2.24, WDI Client 3.2.20, Win 2000 and DB2 and MQ |
|
| Back to top |
|
|
| kalyanMD |
| Posted: Wed Jul 11, 2007 11:45 pm Post subject: |
|
|
Novice
Joined: 03 Feb 2005
Posts: 14
Location: London UK
|
| Tonedef wrote: |
Kalyan,
if you have changed the value in the date to min6/ max8
envelope std -> E -> Segment -> UNB -> S004 -> Element 0017,
both send/rec and transformation maps get their values from there.
are you mapping the value from the data or are you relying on the defaults ? |
Thanks Tonedef for the reply.
I have done exactly same changes but transformation map are atill not working for me.
By the what do you mean by "are you mapping the value from the data or are you relying on the defaults"
I am not very much clear with this statement. |
|
| Back to top |
|
|
| kalyanMD |
| Posted: Thu Jul 19, 2007 7:16 am Post subject: |
|
|
Novice
Joined: 03 Feb 2005
Posts: 14
Location: London UK
|
Everything worked perfectly fine after creating an envelope.
Just had to create an EDIFACT envelope and upgrade the WDI to latest CSD level |
|
| Back to top |
|
|
|
|
