A fix is available
APAR status
Closed as program error.
Error description
Environment: windows 7 Product name: IBM? Rational? Business Developer Program Version : 8.5.1 Description. The Validate SQL function does not indicate any appropriate errors if the database password is not specified within the JDBC connection properties. A dialog box is presented to enter the applicable password but thereafter the result always specifies the Validate operation as successful regardless of if any errors are actually present. Example steps to reproduce the scenario. a) Implementing a validate operation on a simple SQL statement referring to the Employee sample table with the following columns where an error related to the MYTIME2 column is included: #sql{ select EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY, BONUS, COMM, MYTIME2 from EMPLOYEE }; After adding the application data source connection and saving the associated credentials implementing the validate will work as expected showing an appropriate error in the SQL Errors view. b) Uncheck the save password option on the datasource connection properties to illicit the enter credentials dialog box when implementing the validate option. c) The validate will then incorrectly still indicate this as successful, with no errors recorded, even though the column MYTIME2 is invalid.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * **************************************************************** * RECOMMENDATION: * **************************************************************** The Validate SQL function does not work correctly when the database password is not specified within the JDBC connection properties. A dialog box is presented to enter the applicable password but thereafter the result always specifies the Validate operation as successful regardless of if any errors are actually present.
Problem conclusion
The problem is fixed.
Temporary fix
Comments
APAR Information
APAR number
PM96528
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-09-06
Closed date
2014-09-25
Last modified date
2014-09-25
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
R850 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":"8.5","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
25 September 2014