| Author |
Message
|
| mbuserbs |
 Posted: Mon May 17, 2010 6:45 am Post subject: Character Parsing in Message Broker v7 |
 |
|
Newbie
Joined: 17 May 2010
Posts: 2
|
Hi,
When I use the below code in v7 of MB the execution fails and .dmp files are getting generated. This works just fine in v6.
DECLARE S CHARACTER;
SET S = CAST(CURRENT_TIMESTAMP AS CHARACTER FORMAT 'zzz');
Has anyone encoutered this problem?
Any suggestions are greatly appreciated.
Thanks |
|
| Back to top |
|
 |
| kimbert |
| Posted: Mon May 17, 2010 7:12 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| If you are sure that this line of code is causing an abend then you should raise a PMR. |
|
| Back to top |
|
|
| AndreasMartens |
| Posted: Tue May 18, 2010 12:55 am Post subject: A little bit more information |
|
|
Acolyte
Joined: 30 Jan 2006
Posts: 65
Location: Hursley, UK
|
I'd agree with Tim, raise a PMR.
Some more info will help when you raise it (I can't reproduce your abend, so we might need some environment changes):
what does "mqsiservice -t" report?
Service trace of the execution will also help to see exactly where it went wrong.
cheers,
Andreas |
|
| Back to top |
|
|
| mbuserbs |
| Posted: Tue May 18, 2010 6:50 am Post subject: |
|
|
Newbie
Joined: 17 May 2010
Posts: 2
|
| Thank you!! We have raised a PMR |
|
| Back to top |
|
|
| AndreasMartens |
| Posted: Tue May 18, 2010 7:23 am Post subject: Fix is available |
|
|
Acolyte
Joined: 30 Jan 2006
Posts: 65
Location: Hursley, UK
|
You should have the fix shortly, turns out we fixed this in January and I forgot  |
|
| Back to top |
|
|
| hal |
| Posted: Fri Jun 18, 2010 12:06 pm Post subject: |
|
|
Acolyte
Joined: 07 Dec 2005
Posts: 67
Location: New York City, New York
|
Is this related to http://www-01.ibm.com/support/docview.wss?uid=swg21425097
| Quote: |
| WebSphere Message Broker V6.1.0.6 (Fix Pack 06) has been withdrawn because of a regression with the ESQL CAST from CHARACTER to DATE or TIMESTAMP function (APAR IC67336) and a packaging issue (APAR IC67283)... |
Any idea when the first WebSphere Message Broker V7 fix package will be released? |
|
| Back to top |
|
|
| mqmatt |
| Posted: Mon Jun 21, 2010 4:15 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
| hal wrote: |
| Any idea when the first WebSphere Message Broker V7 fix package will be released? |
In the past, fix packs have been released every six months.
(And sorry for a somewhat vague answer there... IBM doesn't generally announce fixpack availability until they're actually released.) |
|
| Back to top |
|
|
| hal |
| Posted: Mon Jun 21, 2010 9:24 am Post subject: |
|
|
Acolyte
Joined: 07 Dec 2005
Posts: 67
Location: New York City, New York
|
|
| Back to top |
|
|
| hal |
| Posted: Tue Jun 22, 2010 2:16 pm Post subject: |
|
|
Acolyte
Joined: 07 Dec 2005
Posts: 67
Location: New York City, New York
|
| Until WebSphere Message Broker 7.0.0.1 becomes available, 7.0.0.0 users who perform ESQL character date or timestamp casts must ask IBM to provide them with test fix APAR IC67336. On UNIX systems the fix consists of four libraries: libCommonServices.so, libImRdl.so, libNativePersonality.so and libPersonality.so. |
|
| Back to top |
|
|
|
|
