IBM Support

SF99654 740 Db2 Web Query for i V2.3.0 - level 8

Preventive Service Planning


Abstract

SF99654: SF99654 740 Db2 Web Query for i V2.3.0

Content

Preventive Service Planning -PSP

SF99654 740 Db2 Web Query for i V2.3.0
Release --
R740

SF99654:  740 Db2 Web Query for i V2.3.0
PTF Group Level:  8
Last Updated:  10/26/22
How to Display:  WRKPTFGRP SF99654
Description:  IBM Db2 Web Query for i Group PTF V7R4.
This group delivers the WQX-v230-HF8-Oct.2022 (hotfix 8) level of
fixes for Db2 Web Query for i.
Be sure to end Web Query with the ENDWEBQRY command before applying
this group PTF.
A security enhancement to Web Query validation lists in this group
level requires that existing validation lists specified on the Run
Web Query Fex (RUNWQFEX) command be recreated for release 2.3.0. To
recreate a validation list, use the Create Web Query Password
(CRTWQPWD) command. Please see the New Features document at
https://www.ibm.com/support/pages/node/1282156 for enhancements and
other changes in behavior.
User profiles that run a Web Query command must specify a valid CCSID
and LOCALE.  For example, if QPGMR issues the STRWEBQRY command in
the QSTRUP program, then the QPGMR profile must specify a LOCALE that
is valid for its CCSID.  If the profile specifies LOCALE( *SYSVAL),
then the system value QLOCALE cannot be *NONE. For more information,
see
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_74/rzahz/rzahznls.htm.
 
Users of the Web Query Developer Workbench feature will need to
refresh the client on their PC. Download the five files which have
been refreshed for this group level in
/qibm/proddata/qwebqry/DeveloperWorkbench in the IFS to the PC, and
then run the .exe file.
When upgrading or installing Web Query Hotfix 8 Developer Workbench,
a registry edit is needed to access the Scheduling and SQL editing
functions which previously available on Web Query Developer
Workbench:
**Please note: You may need elevated permissions to access the
Registry Editor.
1. From the start menu, search and open the 'Registry Editor'
2. From the Registry Editor, navigate to the following path,
HKEY_CURRENT_USER\SOFTWARE\Information
Builders\DevWorkbench\90\FOCSHELL\WFSCOM
3. Look for, "EmbeddedWebToolsAreNotPermitted" key
4. Right-click, "EmbeddedWebToolsAreNotPermitted" and select Modify
5. Change "Value data" from 1 to 0. Click OK
6. Start Developer Workbench
When the registry key is "on" (tools accessible), a message will
display any time one of those tools are opened:
The Web Query Hub offers web-based alternative tools to those
previously available in Developer Workbench. Would you like to
proceed to the Developer Workbench embedded version?
Selecting Yes would continue to open the Web Query Developer
Workbench tool.
Selecting No would close the dialog and do nothing.
The message will display on the first initialization of an embedded
tool within the Web Query Developer Workbench session. It will not
display for any tools after the first one. However, closing Web Query
Developer Workbench entirely and reopening it would reset this, where
the message would display on the first initialization of an embedded
tool again.
Note: this message will always display when accessing an embedded
tool.
Planned Update Schedule:  Every 3 months
Related PTF Group(s):  None
PTF ordering information:
http://www.ibm.com/support/fixcentral/ibmi
Links to group member PTF special instructions:
http://www.ibm.com/support/docview.wss?uid=nas4SF99654_SI
-------------------------------------------------
PTF         DATE        APAR       LICENSED CUMULATIVE
NUMBER      ADDED                  PROGRAM  PACKAGE
*************************************************
SI81266     10/26/22    SE78572    5733WQX  1000
SI81278     10/26/22    SE78579    5733WQX  1000
SI81229     10/26/22    SE75151    5733WQX  1000
SI78645     03/30/22    SE77152    5733WQX  1000
SI78202     12/21/21    SE76829    5733WQX  1000
SI75906     09/29/21    SE75327    5733WQX  1000
*************************************************




SF99654.xml - SF99654.xml


SF99654.pdf - SF99654.pdf (3KB)


IBM i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0","Product":{"code":"SS9QQS","label":"IBM i 7.4 Preventative Service Planning"},"Component":"","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
26 October 2022

UID

nas4SF99654