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 number
JR38549
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
850
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-12-23
Closed date
2012-12-17
Last modified date
2012-12-17
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
17 December 2012