APAR status
Closed as program error.
Error description
Environment: - Windows XP - Rational Bussiness Developer Extension 7102 Reproducible Y/N: Y Description of problem: when using the EGL Data Access Application wizard to import tabl e definitions from a Microsoft SQL Server 2005 RDBMS and Oracle. S ome of the columns in the tables selected contained spaces in the column names. When looking at the generated EGL source for the SQLRecords, it is noted that the field names generated in the record also contained spaces, m aking them invalid field names. The DataItems created for the columns also contained spaces; again invalid EGL. Step to reproduce: a. created a table in database, with a column 'column 1' and 'co lumn 2' b. in RBD ?new project ? EGL Data Access Application ? c. followed the wizard, selected the table, selected the 2 check boxes that are been in my attachment screenshot. d. after wizard is been completed, I did have errors because wiz ard has created fields with spaces Workaround: I modified ?DataDefinitions.egl? by removing the spaces to the fields. example: dataitem column1 INT end dataitem column2 VAR end and also modified in EGL sources by removing the spaces and the error is gone.
Local fix
Problem summary
When the Data Access Application wizard was used to create EGL code from a database table, and the name of a column in that table contained spaces, the EGL code it created was invalid. The spaces of the column's name were not being removed.
Problem conclusion
The wizard will now remove the spaces.
Temporary fix
Comments
APAR Information
APAR number
PK79999
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-02-04
Closed date
2009-03-20
Last modified date
2009-03-20
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
R700 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.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
20 March 2009