| Author |
Message
|
| WBI_user |
 Posted: Wed Dec 09, 2009 10:05 am Post subject: Getting CCSID of the broker Qmgr |
 |
|
Partisan
Joined: 07 Aug 2001
Posts: 386
|
I like to obtain the CCSID and encoding of the broker Qmgr using ESQL.
I used MQCCSI_Q_MGR and MQENC_NATIVE, I got the correct encoding value. But MQCCI_Q_MGR returns zero.
Can anyone help? I am running WMB 61 on AIX and Windows. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Dec 09, 2009 6:22 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Read up. 0 means the qmgr should use its own value.
Working as designed.
If you really need to know the value and don't know it, you can always put a message to a queue and get it right back and read the values from the MQMD... Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| AkankshA |
| Posted: Wed Dec 09, 2009 8:58 pm Post subject: Re: Getting CCSID of the broker Qmgr |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
| WBI_user wrote: |
I like to obtain the CCSID and encoding of the broker Qmgr using ESQL.
I used MQCCSI_Q_MGR and MQENC_NATIVE, I got the correct encoding value. But MQCCI_Q_MGR returns zero.
Can anyone help? I am running WMB 61 on AIX and Windows. |
May i ask why such a requirement of dynamically acquiring CCSID and Encoding of Broker QM.....
i mean CCSID and encoding values of QM are quite static and i hardly see them change over the lifetime of QMGR....
_________________
Cheers |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Dec 10, 2009 12:16 am Post subject: Re: Getting CCSID of the broker Qmgr |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| AkankshA wrote: |
i mean CCSID and encoding values of QM are quite static and i hardly see them change over the lifetime of QMGR.... |
Ha-Ha.
I think you really meant to say
| Quote: |
| i mean CCSID and encoding values of QM are quite static and i hardly see them change over the lifetime of a properly configured(to handle all the business messages) QMGR |
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| AkankshA |
| Posted: Thu Dec 10, 2009 1:33 am Post subject: Re: Getting CCSID of the broker Qmgr |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
| smdavies99 wrote: |
| Quote: |
| i mean CCSID and encoding values of QM are quite static and i hardly see them change over the lifetime of a properly configured(to handle all the business messages) QMGR |
|
hahhaha... management and client at my site take that as an obvious implicit requirement/specification
_________________
Cheers |
|
| Back to top |
|
|
| WBI_user |
| Posted: Thu Dec 10, 2009 5:32 am Post subject: |
|
|
Partisan
Joined: 07 Aug 2001
Posts: 386
|
| We are developing flows that can be run on any broker platform. So we need to know the CCSID of the QMGR. An alternative will be to get the platform information, then we can code the flow with CCSID value good enough for us (for example all our AIX QMGRs are CCSID 850, Windows are 437, ZOS is 37). I read about CCSID =0 being the QMgr's CCSID under the ASBITSTREAM function. But The Create/Parse function is failing if I specify CCSID= 0. |
|
| Back to top |
|
|
| WBI_user |
| Posted: Thu Dec 10, 2009 5:55 am Post subject: |
|
|
Partisan
Joined: 07 Aug 2001
Posts: 386
|
| Just found out that I can query on broker properties 'Family' to get the platform. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Dec 10, 2009 12:26 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Hi, why do you think you need the CCSID at all? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Dec 10, 2009 10:37 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| mqjeff wrote: |
| Hi, why do you think you need the CCSID at all? |
 strongly.
The ccsid of the incoming data is stated in InputRoot.Properties...
As for the outgoing you can set it to whatever is required. You should not set it to 437 or 850 because that is the target platform CCSID. You could be loosing important data that cannot be displayed in this CCSID.
Having a Unicode or UTF-8 CCSID is considered often as a CCSID where almost any character can be portrayed.
Now it is time you make some tough choices...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
