| Author |
Message
|
| cvag |
 Posted: Sun Aug 07, 2011 10:37 am Post subject: Mail Content Special Character Issue |
 |
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
Hi,
Am having an issue with the special characters in the message body while sending an email in the MainFrame environment.
The body content is not readable in the Z/OS.
| Code: |
Body Content:
=========
This content is being generated from the details of exceptionList tree.
BIP2322E Brk61 EG DatabaseException 15:07:28.666595 '{DB2 FOR OS/390}{ODBC DRIVER}{DSN10012} DSNT408I SQLCODE = -803, ERROR: AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE INDEX IN INDEX SPACE XXGZPOD1 CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X'0000000215'. DSNT418I SQLSTATE = 23505 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRINS SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -110 13172739 0 13817814 -490143744 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF92' X'00C90003' X'00000000' X'00D2D7D6' X'E2C90000' X'00000000' SQL DIAGNOSTIC INFORMATION ERRLOC=1:13:2' (CHARACTER) 1
Where representing '->' in my mail, while copying the mail content in this forum looking as the same special character here.
Am writing the code to generate the above content:
SET MsgContent = 'BIP'||cErrorCode||'E '||BrokerName||' '||ExecutionGroupLabel||' '||cErrorType||' '||cErrorTime||' '||cErrorDesc||' LOG ID:'|| cLogEntry;
SET OutputRoot.EmailOutputHeader.To = Environment.Variables.RbcEsbErr.Alert.Recipients_Info||','||Environment.Variables.RbcEsbErr.Alert.Recipients_Issue;
SET OutputRoot.EmailOutputHeader.Subject = 'BIP'||CAST (Environment.Variables.RbcEsbErr.ExceptionHandle.ErrorCode AS CHARACTER) ||'E'||'_'||Environment.Variables.RbcEsbErr.ExceptionHandle.ErrorType;
SET OutputRoot.BLOB.BLOB = CAST(MsgContent AS BLOB CCSID InputRoot.Properties.CodedCharSetId);
Windows
======
This is clear and readable, the mail content appears the same as above Body Content shows.
Z/OS:
====
But when we deploy this code in MainFrame and test, the mail delivers to the recipients with the unreadable format
Tried with CCSID especially giving 500
SET OutputRoot.BLOB.BLOB = CAST(MsgContent AS BLOB CCSID 500);
The only mail content be read is:
BIP2322E XHM1 XHMEG DatabaseException 15:07:28.666595 '{DB2 FOR OS/390}{ODBC DRIVER}{DSN10012}
And the remaining body is filled with special characters especially at these places where we have ' ' at different place.
|
Can anybody please help, how do i can get rid of these special characters and get the original content. 
Thanks in Advance. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Sun Aug 07, 2011 11:23 am Post subject: Re: Mail Content Special Character Issue |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| cvag wrote: |
| The body content is not readable in the Z/OS. |
Then why are you saying that it is in codepage 500 - which is the zOS code page? |
|
| Back to top |
|
|
| cvag |
| Posted: Sun Aug 07, 2011 11:27 am Post subject: |
|
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
Sorry MQJeff,
My mistake..
That is not Z/OS system, MainFrame system. |
|
| Back to top |
|
|
| cvag |
| Posted: Sun Aug 07, 2011 11:37 am Post subject: |
|
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
| Yes CodePage is 500 for MainFrame. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Aug 07, 2011 2:05 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Set the mail content in CCSID 1208 ... always ... and let us know what happens... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| cvag |
| Posted: Sun Aug 07, 2011 2:11 pm Post subject: |
|
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
If the CCSID is 1208, it is working fine in windows.
If the same code deployed in the MainFrame Broker
the same CCSID 1208 is not working in MainFrame. Because the CodePage is 500.
Any other idea pls, have tried with these two option putting CCSID(1208 and 500) |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Aug 07, 2011 7:43 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Very few mail systems are geared for the MF. Most will send messages in CCSID 1208... So I figured it's worth a shot trying to send the mail to the MF in CCSID 1208. However you need to mark that clearly and correctly on the messages....
Have fun
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
