IBM i Global

APAR SE80590 shows how to remove Management Central - which is obsolete and unsupported. The PTF for 7.5 for this APAR is SI84787 This breaks CHKPRDOPT with the message at the bottom. I have opened case TS014906410 Message ID . . . . ...

Satid, Use of Global Variables won't prevent the values from being accessed in Visual Explain. While the Plan Cache statement text may have the parameter marker (?), the Final Select icon in Visual Explain with display the value of the global variable. ...

Dear David Did you pass the URL text string directly in HTTP_POST? If so, please try assigning the URL string to a variable first and use the variable in HTTP_POST instead as Plan Cache will NOT keep the actual value of any variables (parameters) ...