Fixes are available
Rational Developer for System z 9.0.1
Rational Developer for System z Fix Pack 1 (9.0.1.1) for 9.0.1
Rational Developer for System z Fix Pack 2 (9.0.1.2) for 9.0.1
Rational Developer for System z Interim Fix 1 for 9.0.1.2
Rational Developer for System z Interim Fix 3 for 9.0.1.2 - IBM Java Platform Standard Edition 7 SR6 FP1 iFixes (IX90136+IX90137+IV39749)
Rational Developer for System z Fix Pack 3 (9.0.1.3) for 9.0.1
Rational Developer for System z Interim Fix 1 for 9.0.1.3
Rational Developer for System z Fix Pack 4 (9.0.1.4) for 9.0.1
Rational Developer for System z Interim Fix 1 for 9.0.1.4
Rational Developer for System z Interim Fix 2 for 9.0.1.4
Rational Developer for System z Interim Fix 3 for 9.0.1.4
Rational Developer for System z Fix Pack 5 (9.0.1.5) for 9.0.1
Rational Developer for System z Fix Pack 6 (9.0.1.6) for 9.0.1
Rational Developer for System z Interim Fix 1 for 9.0.1.6
Rational Developer for System z Interim Fix 2 for 9.0.1.2
Rational Developer for System z Fix Pack 7 (9.0.1.7) for 9.0.1
APAR status
Closed as program error.
Error description
Headline/Abstract: *************************************************************** Rational Developer for System z (RDz): When running SQL statements, the Default Schema is ignored. APAR Error Description: *************************************************************** Rational Developer for System z - RDz V9.0.0 with Data Studio (DS) 4.1 If you leave the Default schema blank in the Database connection settings, when running SQL inside an Editor, the Default Schema defined in the 'Data Access Development Support' wizard is not taken into account. Re-creation steps: . open the Data perspective, . define a database connection with no default schema . open the z/OS projects perspective . define a z/OS project and sub-project . add some programs to the sub-project . right click on the sub-project and select 'Add Data Access Development Support' . select the connection and fill-in the Default Schema, . remove the user ID in the 'Current Path' Then, . Open a DB2 program inside the z/OS project and highlight a SQL statement . Right click and select 'Run SQL' The SQL result shows an error because it uses your own user id as the schema id, instead of the default schema ID. *************************************************************** Local fix: As a work around: 1) Create/Modify your database connection and set the default schema 2) Remove the 'Data Access Development Support' form your project. 3) Add 'Data Access Development Support' again and select the connection you just created/modified. The default schema should remain unchanged. 4) Run SQL statement again.
Local fix
Problem summary
The default schema that the user specifies in the Add Data Access Support wizard is not used. Instead, only the user's userID is used.
Problem conclusion
The problem listed in this APAR has been resolved with IBM Rational Developer for System z V9.0.1 Refresh Pack which is available from the Recommended Fixes support download page: http://www-1.ibm.com/support/docview.wss?rs=2294&uid=swg27006335
Temporary fix
Comments
APAR Information
APAR number
PM95623
Reported component name
RATL DEV FOR SY
Reported component ID
5724T0700
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-08-22
Closed date
2013-12-10
Last modified date
2013-12-10
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 DEV FOR SY
Fixed component ID
5724T0700
Applicable component levels
R901 PSY
UP
Document Information
Modified date:
08 January 2022