PI70796: GENERATED JAVA INCORRECT FOR SQL SERVER

Rational Business Developer Fix Pack 2 (9.1.1.2) for 9.1.1
Rational Business Developer Fix Pack 2 (9.5.1.1) for 9.5

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 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