IBM Support

Datastage Designer may crash when editing complex SQL query on the connector stage editor.

Product Documentation


Abstract

On the connector stage editor after editing the SQL statement when the OK button is clicked to save the job the designer might become unresponsive and any further action would crash the designer.

Content

This behaviour is seen in all database connectors . To prevent the designer from crashing an environment variable CC_GUI_NOTVALIDATE_SQL should be created at job level or at project level and the value should be set to TRUE.

If this environment variable is added at project level in the administrator client then no need to add it in each of the job that exhibits the problem.

Setting this environment variable would work on -

a. 9.1.2 + patch JR54826

b. 11.3 + patch JR57935

c. 11.5 + patch JR56733

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.1.2.0;11.5;11.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27050028