JR38549: PROBLEM WITH IS 8.5 DB2 CONNECTOR SQL BUILDER

APAR status

• Closed as fixed if next.

Error description

• Problem with DB2 Connector SQL Builder where if you ADD the
  following in the WHERE clause:
  
  Input: (CURRENT DATE - 1 YEAR)
  
  When you click ADD this gets converted to:
  
  (CURRENT DATE -- 1)
  

Local fix

• MANUALLY EDIT THE SQL WHERE CLAUSE
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  SQL Builder users
  ****************************************************************
  PROBLEM DESCRIPTION:
  (CURRENT DATE - 1 YEAR) is not processed correctly
  ****************************************************************
  RECOMMENDATION:
  This has been resolved by JR41188
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• This issue is resolved at Release 9.1.
  Fixed as part of JR41188
  Added support to SQLBuilder to enable date arithmetic
  comparisons (with words   including YEAR, YEARS, MONTH, MONTHS,
  DAY, DAYS) in DB2 where clause be handled correctly.
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R850 PSN

     UP

• R870 PSN

     UP