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 number
PM10166
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-03-17
Closed date
2010-04-14
Last modified date
2010-04-14
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
14 April 2010