Drop-In ID: OPDM-11.03.00.08-017
Product: IBM® InfoSphere® Optim™ Designer
Release: 11.3.0.8
Problem ID: IP24361
Date: October 7, 2021
Description: This iFix includes corrections for the following problem:
In Optim Designer, when clicking the "Check Syntax" button in the Actions specification, if a SQL syntax error is reported as follows:
"The SQL
syntax is either invalid or product specific"
Designer
will still allow you to save the invalid SQL statement.
After applying this iFix, when you click on the Check Syntax button, if Designer detects a syntax error, it will not permit you to save the dialog until valid SQL syntax is specified.
NOTE: If you don't click on the Check Syntax button, Designer will continue to permit any SQL to be saved, even if it is invalid.
Prerequisites: IBM® InfoSphere® Optim™ Designer 11.3.0.8.20191101_0906 with OPDM-11.03.00.08-003, and IBM® Installation Manager 1.8.2 or later.
Co-requisites: None.
Supersedes: OPDM-11.03.00.08-004, OPDM-11.03.00.08-005, OPDM-11.03.00.08-006, OPDM-11.03.00.08-007, OPDM-11.03.00.08-009, OPDM-11.03.00.08-010, OPDM-11.03.00.08-012, OPDM-11.03.00.08-013, OPDM-11.03.00.08-014, OPDM-11.03.00.08-015 and OPDM-11.03.00.08-016. These iFixes must be uninstalled before this iFix can be applied..
Special
Notes:
This iFix together with OPDM-11.03.00.08-003, contain all of the
plugins provided with OPDM-11.03.00.08-001, OPDM-11.03.00.08-002,
OPDM-11.03.00.08-004, OPDM-11.03.00.08-005, OPDM-11.03.00.08-006,
OPDM-11.03.00.08-007, OPDM-11.03.00.08-009, OPDM-11.03.00.08-010,
OPDM-11.03.00.08-012, , OPDM-11.03.00.08-013, OPDM-11.03.00.08-014,
OPDM-11.03.00.08-015 and OPDM-11.03.00.08-016. Do not install any of
these iFix once this iFix is installed..
IBM Installation
Manager 1.8.2 or later is required to install this iFix.
iFix
OPDM-11.03.00.08-017 fix creates the file
eclipse.OPDM-11.03.00.08-017.ini
in
the designer directory. Before starting Optim Designer, you must
replace the contents of the eclipse.ini
file
with the contents of the eclipse.OPDM-11.03.00.08-017.ini
file.
OS Platforms: Windows
Corrective Actions:
If more than one iFix is found by Installation Manager, then all of them will be selected by default. Review each iFix and unselect any that you do not wish to install.
Ensure that all Optim components are not running before applying this iFix.
Continue through the Installation Manager Update wizard to apply this iFix.
How to uninstall this fix:
Ensure that all Optim components are not running before uninstalling any iFix.
Start IBM Installation Manager
Select the Uninstall option from the main Installation Manager window or menu.
Select the iFix you wish to uninstall.
Continue through the Installation Manager Uninstall wizard to remove this iFix.
This iFix will automatically be uninstalled if you upgrade to a new version.
If you have any questions about or problems with these procedures, contact IBM Optim Support.