APAR status
Closed as program error.
Error description
When editing SQLRPGLE source with embedded SQL using the Remote Systems LPEX Editor in Rational Developer for i (RDI) 9.6.0.7 the editor may incorrectly interpret the source. The problem occurs when the source has an embedded SQL statement with the word CASE inside a quoted string within the SQL statement. The code scan may then not correctly recognize the end of the SQL statement. This can cause incorrect token coloring in the editor, error annotations in the editor, and an incorrect Outline view. For example: exec sql select IBMREQD as "Case Count" from sysibm.sysdummy1;
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ILE RPG developers using RDi to edit SQLRPGLE source. * **************************************************************** * PROBLEM DESCRIPTION: * * Embedded SQL with the word CASE inside a literal constant * * value is incorrectly interpreted as being a CASE clause. * **************************************************************** * RECOMMENDATION: * **************************************************************** The word CASE appearing in a character constant string (eg. â my case countâ ) in the embedded SQL statement is incorrectly interpreted as a SQL CASE clause; causing errors in the further interpretation of the statement.
Problem conclusion
This problem is fixed in the RDi 9.6.0.11 update. Product web page: https://www.ibm.com/us-en/marketplace/rational-developer-for-i Fix List and download link: http://www.ibm.com/support/docview.wss?uid=swg27038481
Temporary fix
Comments
APAR Information
APAR number
SE73104
Reported component name
RDI RPG AND COB
Reported component ID
5724Y99RC
Reported release
960
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-02-28
Closed date
2021-09-21
Last modified date
2021-09-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
SQL
Fix information
Fixed component name
RDI RPG AND COB
Fixed component ID
5724Y99RC
Applicable component levels
[{"Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSAE4W","label":"Rational Developer for i"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"960"}]
Document Information
Modified date:
22 September 2021