IC64818: QUERY IN PROCEDURE USING HASH JOIN AND FIRST 1 RETURNS NO ROWS

APAR status

• Closed as program error.

Error description

• A procedure using a query with FIRST 1 and hash join returns no
  rows every second result.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users with PDQ set or having hash join method used  with *
  * First N query.                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When PDQ is set or hash join method is used with First N in  *
  * SPL, IDS will return null result at every 2nd iteration.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC6 and above.                          *
  ****************************************************************
  

Problem conclusion

• Problem is first fixed in IDS 11.50.xC6.
  

Temporary fix

Comments

• For download information, go to:
  http://www-933.ibm.com/support/fixcentral/
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP