PH68742: NEW FUNCTION SUPPORT FOR LOAD UTILITY

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New function support for LOAD utility.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 13 for z/OS users of the LOAD        *
  *                 utility with a WHEN clause.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The LOAD utility WHEN clause is         *
  *                      enhanced to support more complex        *
  *                      field selection criteria than the       *
  *                      field-selection-criterion currently     *
  *                      allows through the new SELECTION        *
  *                      CONDITION option.                       *
  ****************************************************************
  The LOAD utility with the WHEN keyword specified is limited to
  a single equality comparison for the field selection
  criterion. DBAs are not able to specify selection based on
  multiple fields or positions within the input record.
  This enhancement addresses this need by extending the existing
  WHEN field selection criteria of the LOAD utility to support
  multiple clauses via ANDs and ORs, as well as allowing the <>
  (not equal to) comparison operator as an additional alternative
  to the existing = (equal to) operator.
  

Problem conclusion

Temporary fix

Comments

• PH68742 enhances the LOAD INTO-TABLE-spec WHEN field
  selection criterion to allow the '<>' comparison operator.
  The modified field selection criterion follows the same
  syntax, usage guidelines, and restrictions as the current
  field-selection-criterion. For example,
  
  WHEN (DEPTNO <> 'D12')
  
  PH68742 adds a new option to the LOAD INTO-TABLE-spec WHEN
  clause called the selection condition. The selection
  condition allows multiple field selection criterion to be
  combined with the 'AND', and 'OR' operators, all within the
  selection condition. For example,
  
  WHEN ((DEPTNO = 'D12' OR STORE = X'C1F5') AND (ID = '700'))
  
  SELECTION CONDITION
  Specifies a condition that is true or false about a given
  record. When the condition is true, the record qualifies for
  LOAD. When the condition is false, the record does not
  qualify. Qualifying records will be loaded into the table
  that is specified after INTO TABLE.
  
  The result of a selection condition is derived by application
  of the specified logical operators ('AND' and 'OR') to the
  result of each specified field selection criterion clause.
  If the logical operators ('AND'/'OR') are not specified, then
  the selection condition result will be equivalent to the
  single WHEN field selection criterion comparison. For
  example, WHEN (C1 = 'CA').
  
  Selection conditions within parentheses are evaluated first.
  If the order of evaluation is not specified by parentheses,
  then 'AND' is applied before 'OR'.
  
  This APAR will now issue message DSNU1564I to indicate that
  the new INTO-TABLE-spec WHEN features are only supported for
  UTS objects.
  
  DSNU1564I csect-name - LOAD UTILITY WITH COMPLEX WHEN
  SPECIFICATION IS NOT SUPPORTED FOR type object-type
  object-qualifier.object-name
  
  The utility will terminate with RC8 without loading any
  records.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UO06316

Modules/Macros

• DSNFUDIR DSNFUDRE DSNUCAIN DSNUGDDF DSNUGPPF DSNUGPRS DSNUGPRW
  DSNUGUCA DSNUGUTC DSNUMSGE DSNURCRF DSNURPNI DSNURPPI DSNURPWN
  DSNURUFL DSNURURT DSNURWBF DSNURWBG DSNURWHN DSNURWI  DSNURWUF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO06316

     UP25/12/27 P F512  

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.