PM10166: SQLRecord creation of Data Access Application changes keyfield c olumn orders

APAR status

• Closed as program error.

Error description

• Environment: Windows
  Product name: IBM? Rational? Business Developer
  Program Version : 7.5.1.4
  Additional:
  Description.
  The SQLRecord creation mechanism from the Data Access Applicatio
  n wizard mechanism changes column orders when generating records
   from database structures with keyfields and DB2. The SQL record
  s generated cause these key values to appear at the top of the g
  enerated record, in turn causing errors when performing an unqua
  lified SQL statement.
  
  This is reproducible only when generating with Data Access Appli
  cation wizard, creating the SQLRecord from a SQL retrieve with a
   keyfield works fine retaining the original column positions.
  
  Step to reproduce:
  a) Select Data Access Application wizard
  b) Select sample 'employee' table
  c) Add two keyfields within the generation wizard ie LASTNAME, P
  HONENO.
  d) Finish the wizard and the SQLRecord is then defined with thes
  e 2 columns heading the data definitions.
  The associated generated entries eg record EmployeeSearch also p
  roduce the same order and when using the SQL statement wizard to
   add a select the same order applies.
  e) Doing another SQL retrieve on the SQLRecord itself corrects t
  he column order but the other artifacts, EmployeeSearch, Select
  are left with the same incorrect order.
  

Local fix

Problem summary

• The Data Access Application wizard creates SQL records from
  database tables, with the key fields at the beginning of the
  record.  Fields for columns that are not keys are after the
  keys.  One of the queries in the "getList" function uses
  SELECT TABLE.* to get the columns from the table, and this
  query will fail to work properly if the columns returned by
  the database are not in the same order as the columns in the
  SQL record.  The query may fail when it is run, or the
  fields of the SQL record may get the wrong values.
  

Problem conclusion

• The query has been changed to list all of the columns being
  selected.  The order of the fields in the SQL record is no
  longer important.
  

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

• R751 PSN

     UP