APAR status
Closed as documentation error.
Error description
Omnibus Admin Guide http://www-01.ibm.com/support/knowledgecenter/SSSHTQ_8.1.0/com.i bm.netcool_OMNIbus.doc_8.1.0/omnibus/wip/admin/reference/omn_adm _sql_new oldimplicitvars.html States: "In a post-reinsert trigger, only the NEW variable is available, and this represents the data from the INSERT statement. For example, if Tally is not specified in the INSERT statement, new.Tally will have a default value of 0 (zero)." In APAR IZ52617, the code was changed for post reinsert triggers so that new row variables include columns specified in an insert statement AND rows modified in a pre-insert statement. So the pre-insert will increase the tally. This means the Tally will be visible in post re-insert.
Local fix
NA, DOC APAR
Problem summary
**************************************************************** * USERS AFFECTED: * * Netcool/OMNIbus administrators * **************************************************************** * PROBLEM DESCRIPTION: * * The documentation at * * http://www-01.ibm.com/support/knowledgecenter/SSSHTQ_8.1.0/c * * om.ibm.netcool_OMNIbus.doc_8.1.0/omnibus/wip/admin/reference * * /omn_adm_sql_new oldimplicitvars.html incorrectly states, * * "In a post-reinsert trigger, only the NEW variable is * * available, and this represents the data from the INSERT * * statement. For example, if Tally is not specified in the * * INSERT statement, new.Tally will have a default value of 0 * * (zero)." * **************************************************************** * RECOMMENDATION: * * In APAR IZ52617, the code was changed for post reinsert * * triggers so that new row variables include columns specified * * in * * an insert statement AND rows modified in a pre-insert * * statement. So the pre-insert will increase the tally. This * * means the Tally will be visible in post re-insert. * ****************************************************************
Problem conclusion
The documentation will be updated to correct this inaccuracy in September.
Temporary fix
Comments
APAR Information
APAR number
IV63369
Reported component name
NETCOOL/OMNIBUS
Reported component ID
5724O4800
Reported release
740
Status
CLOSED DOC
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-08-08
Closed date
2014-08-29
Last modified date
2014-08-29
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":"740","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
23 July 2021