PH30446: IDZ ZUNIT DB2 RECORDING - WRONG RESULT OF A SELECT * RETURNING NCOLUMNS WHEN JUST ONE PARENT STRUCTURE IS SPECIFIED AS HOST VAR

APAR status

• Closed as program error.

Error description

• When the result of select * should return n columns,
  application can specify one host variable of a parent structure
  or n host variables.  For example:
  01 DCL-CUSTOMER.
             10 DCL-CUSTOMER-NUM       PIC S9(10) USAGE COMP-3.
             10 DCL-FIRST-NAME         PIC X(10).
             ...
  or
  77 DCL-CUSTOMER-NUM       PIC S9(10) USAGE COMP-3.
  77 DCL-FIRST-NAME         PIC X(10).
  ...
  
  zUnit does not correctly handle the case when just one parent
  structure is specified as host variable.
  

Local fix

Problem summary

• The gourp item id expanded to its nested items to be filled with
   data in EXEC SQL.  The IDz ZUnit client didn't expand it in
  analysis of the target program source and importing recorded
  data.
  

Problem conclusion

• The IDz ZUnit client was fixed to expand the group items of EXEC
   SQLs to the nested items in processing target program sources.
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  DEV FOR Z/OS

• Fixed component ID

  5724T0700

Applicable component levels