APAR status
Closed as program error.
Error description
Rational Developer for System z - RDz - v8.0.3.3 Valid SQL statement is incorrectly flagged in error. The error 'Unable to resolve reference' is issued when the following statement has sorteer in lowercase: DECLARE CURSOR-LOCATIONS CURSOR FOR SELECT LOCATION ,PORT ,DBALIAS ,CASE WHEN LOCATION = :LOCATION OR LOCATION = :DBALIAS OR LOCATION = :PORT THEN 1 WHEN LOCATION = :DBALIAS THEN 2 ELSE 3 END AS sorteer FROM SYSIBM.LOCATIONS WHERE TPN = :TPN ORDER BY sorteer ASC END-EXEC *************************************************************** Local fix: Use uppercase for variables such as SORTEER instead of sorteer
Local fix
Problem summary
"Unresolved reference to [column-name]" annotation message appears for a result column created by an AS clause in a SELECT statement, when the result column is specified in lower- or mixed-case.
Problem conclusion
Result columns were being added to the internal symbol table in the case they were first mentioned, so the reference resolving, which depends on uppercase symbol names, could not find the result columns. The fix is to make sure symbols are added to the internal symbol table in uppercase. The problem listed in this APAR has been resolved with IBM Rational Developer for System z V8.0.3.4 Fix Pack which is available from the Recommended Fixes support download page: http://www-1.ibm.com/support/docview.wss?rs=2294&uid=swg27006335
Temporary fix
Comments
APAR Information
APAR number
PM74644
Reported component name
RATL DEV FOR SY
Reported component ID
5724T0700
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-10-09
Closed date
2012-12-13
Last modified date
2012-12-13
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
RATL DEV FOR SY
Fixed component ID
5724T0700
Applicable component levels
R803 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSJK49","label":"IBM Developer for z Systems"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
27 October 2020