PM09852: Validation error from Open statement with SQLRecordVariable

APAR status

• Closed as program error.

Error description

• Environment: Windows
  
  Product name: IBM? Rational? Business Developer
  
  Program Version    :  7.1.0.4
  Description:
  An error message is output within the code editor when performin
  g validation on an Open statement with implicit SQL ie
  Position cursor in Open statement -? Right click -? SQL Statemen
  t -? Validate.
  
  This option checks to see whether the implicit SQL code is well
  formed and produces the error in EGL SQL problems view :
  IWN.EDT.1015.e 0/0 No SQL record variable specified for the EGL
  OPEN statement.
  
  According to the documented syntax it isn?t necessary to write a
  n SQL record variable ie
  SQLRecordVariable
  The name of an SQL record variable. If you do not specify an SQL
   record variable, you must provide embedded SQL code (with the #
  sql directive). etc so the following should work fine but produc
  es this validation error eg
  function tester()
            try open employee;
  end
  
  To also add the auto generated select via code editor -? SQL Sta
  tement-? Add, without the 'for' ie
  open employee will always produce the above error and generation
   fails.
  Change to open employee for employee and the generation succeeds
  .
  
  Developers then have to manipulate written SQL before they can v
  alidate the written SQL statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The code was erroneously requiring that an SQL record be
  specified on the OPEN statement, before allowing the
  statement to be validated
  

Problem conclusion

• I have updated the code to allow the validation to be
  performed
  

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

• R710 PSN

     UP