APAR status
Closed as documentation error.
Error description
The example provided on this link; http://www-01.ibm.com/support/knowledgecenter/SSSHTQ_7.3.1/com.i bm.netcool_OMNIbus.doc_7.3.1/omnibus/wip/admin/reference/omn_adm _sql_creatingexternalprocs.html?lang=en is incorrect, using the cited example; create or replace procedure send_email (in node character(255), in severity integer, in subject character(255), in email character(255), in summary character(255), in hostname character(255)) executable '$NCHOME/omnibus/utils/nco_mail' host 'localhost' user 0 group 0 arguments '\'' + node + '\'', severity, '\'' + subject + '\'', '\'' + email + '\'', '\'' + summary + '\''; Causes the data output to be truncated.
Local fix
Fix is to modify the expression as follows; ====== . '\"\''+summary+'\'\"' . That is single-quote backslash double-quote backslash single-quote single-quote +summary+ single-quote backslash single-quote backslash double-quote single-quote
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of Tivoli Netcool/OMNIbus. * **************************************************************** * PROBLEM DESCRIPTION: * * The example send_mail procedure in the following topic * * contains syntax that causes the output to be truncated: * * http://www.ibm.com/support/knowledgecenter/SSSHTQ_7.3.1/com. * * ibm.netcool_OMNIbus.doc_7.3.1/omnibus/wip/admin/reference/om * * n_adm_sql_creatingexternalprocs.html * * * * The '\'' + summary + '\'' portion of the example should read * * '\"\''+summary+'\'\"'. * **************************************************************** * RECOMMENDATION: * * The updated documentation is planned for publication in Q3 * * 2014. * ****************************************************************
Problem conclusion
The documentation has been updated to correct the syntax.
Temporary fix
Comments
APAR Information
APAR number
IV61897
Reported component name
NETCOOL/OMNIBUS
Reported component ID
5724O4800
Reported release
731
Status
CLOSED DOC
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-06-25
Closed date
2014-07-11
Last modified date
2014-07-11
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHTQ","label":"Tivoli Netcool\/OMNIbus"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"731","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
11 July 2014