A fix is available
APAR status
Closed as program error.
Error description
When using the output from dmpmqcfg as input into runmqsc to define a subscription that contains a selector, a syntax error occurs. The output from dmpmqcfg contains single quotes instead of double quotes. Example: output from dmpmqcfg: DEFINE SUB('YOUR_SUB') + TOPICSTR('A_TOPIC_STRING') + TOPICOBJ('TOPIC1') + DEST('Q1') + SELECTOR('(name='Tom') or (name='Bob' and city='Paris')') This output will result in a syntax error when used as input into runmqsc. The single quotes contained in the parenthesis in the SELECTOR statement should be sets of two single quotes. It should be noted that this problem exists for any string attribute that accepts single quotes in the body of the attribute.
Local fix
Manually edit the output to add the missing single quotes, for example: DEFINE SUB('YOUR_SUB') + TOPICSTR('A_TOPIC_STRING') + TOPICOBJ('TOPIC1') + DEST('Q1') + SELECTOR('(name=''Tom'') or (name=''Bob'' and city=''Paris'')')
Problem summary
**************************************************************** USERS AFFECTED: Users who use embedded single quotes in object string attributes and then use dmpmqcfg to back-up and restore those objects will be affected by this problem. Platforms affected: MultiPlatform **************************************************************** PROBLEM DESCRIPTION: MQSC commands require that string attributes containing embedded single quotes be formatted in a certain way: http://www-01.ibm.com/support/knowledgecenter/SSFKSJ_7.5.0/com.i bm.mq.adm.doc/q020630_.htm "...If the string itself contains a quotation mark, the quotation mark is represented by two single quotation marks. Lowercase characters not contained within quotation marks are folded to uppercase..." The dmpmqcfg command did not respect this formatting rule and so the output could not be used in runmqsc to define any object containing an embedded single quote in one of its string attributes.
Problem conclusion
The dmpmqcfg code was modified so that it doubles any single quotes that are embedded in string attributes. --------------------------------------------------------------- The fix is targeted for delivery in the following PTFs: Version Maintenance Level v7.5 7.5.0.5 v8.0 8.0.0.1 The latest available maintenance can be obtained from 'WebSphere MQ Recommended Fixes' http://www-1.ibm.com/support/docview.wss?rs=171&uid=swg27006037 If the maintenance level is not yet available information on its planned availability can be found in 'WebSphere MQ Planned Maintenance Release Dates' http://www-1.ibm.com/support/docview.wss?rs=171&uid=swg27006309 ---------------------------------------------------------------
Temporary fix
Comments
APAR Information
APAR number
IT02480
Reported component name
WMQ BASE MULTIP
Reported component ID
5724H7241
Reported release
750
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-06-12
Closed date
2014-07-17
Last modified date
2014-07-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WMQ BASE MULTIP
Fixed component ID
5724H7241
Applicable component levels
R750 PSY
UP
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFKSJ","label":"WebSphere MQ"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5"}]
Document Information
Modified date:
25 September 2021