Fixes are available
APAR status
Closed as program error.
Error description
In RBD 9.1.0, the generated code is incorrect. What is done: 1. User has following sqlrecord definition: record ACE0010 type SQLRecord{tableNames =[["dbo.CADACESS", "T1"] .... 2. The program contains UPDATE and/or DELETE for this record. What is expected: Generated code should be correct . What is observed: The generated code in invalid foe SQL server (Valid for DB2) For example: UPDATE dbo.SYSDUMMY1 T1 SET IBMREQD = 'A' For SQLserver - Incorrect syntax near 'T1'.
Local fix
Fixe the incorrect code manually after generation.
Problem summary
**************************************************************** * USERS AFFECTED: * * EGL Java users who use Microsoft SQL server * **************************************************************** * PROBLEM DESCRIPTION: * * The generation for SQL update/delete is incorrect for * * Microsoft SQL Server * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The problem is fixed.
Temporary fix
Comments
APAR Information
APAR number
PI70796
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-10-17
Closed date
2019-01-18
Last modified date
2019-01-18
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 BUS DEV
Fixed component ID
5724S5000
Applicable component levels
R911 PSY
UP
R950 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
19 October 2021