A fix is available
APAR status
Closed as new function.
Error description
DB2 11 for z/OS new function.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 11 for z/OS users of JSON_VAL * * built-in function * **************************************************************** * PROBLEM DESCRIPTION: This APAR lifts a restriction on the * * JSON_VAL built-in function. * **************************************************************** * RECOMMENDATION: * **************************************************************** The initial support of JSON_VAL built-in function, which was introduced by APAR PI10521, required that the argument for the first parameter had to be a BLOB column of a base table that resided in a partitioned by growth table space. With the support introduced by this APAR, the first parameter can now be specified as an expression that returns a BLOB value. It also removes any requirement that the value come from a partitioned by growth table space. An exception to this is that when JSON_VAL is referenced in an expression for an expression-based index, the input value must come from a partitioned by growth table space. Full description on JSON_VAL and how to work with JSON documents by using SQL can be found at following URL: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com. ibm.db2z11.doc.json/src/tpc/db2z_jsonfunctions.dita
Problem conclusion
Temporary fix
Comments
JSON_VAL built-in function has been extended to support any expression that returns a BLOB value for argument of json-value parameter.
APAR Information
APAR number
PI39003
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function
Submitted date
2015-04-13
Closed date
2015-07-02
Last modified date
2015-08-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI29090
Modules/Macros
DSNXOBFA DSNXOBFF DSNXOOS1 DSNXOV1
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI29090
UP15/07/22 P F507
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 August 2015