Feedback
Did this article resolve your question/issue?

   

Article

Connect for JDBC DB2 driver AlternateID connection option should set the value for CURRENT SCHEMA instead of CURRENT SQLID for DB2 z/OS

Information

 
TitleConnect for JDBC DB2 driver AlternateID connection option should set the value for CURRENT SCHEMA instead of CURRENT SQLID for DB2 z/OS
URL NameConnect-for-JDBC-DB2-driver-AlternateID-connection-option-should-set-the-value-for-CURRENT-SCHEMA-instead-of-CURRENT-SQLID-for-DB2-z-OS
Article Number000183504
EnvironmentProduct: Connect for JDBC DB2 driver
Version: 5.1
OS: All supported platforms
Database: DB2 z/OS
Application: Java
Question/Problem Description

Users would like to connect to DB2 z/OS using ID1 and run SQLs against a set of tables with schema name of ID2.
However since DataDirect JDBC driver currently doesn't translate AlternateID to SET CURRENT SCHEMA statement instead it translates to SET CURRENT SQLID, this requires additional RACF security authorization which some users are reluctant to grant. 

 

Steps to Reproduce
Clarifying Information

PER JDBC documentation : AlternateID specifies the name of the schema to be used to qualify unqualified database objects in dynamically prepared SQL statements.For DB2 for z/OS, this property sets the value in the DB2 CURRENT SQLID special register.

Review the User's Guide for Progress DataDirect Connect Series for JDBC:

http://media.datadirect.com/download/docs/jdbc/alljdbc/#page/userguide/rfi1359985951612.html

 

Error Message
Defect NumberDefect 30654 (DB2 on iSeries and DB2 for Linux/UNIX/Windows). Defect 63280 (DB2 on z/OS)
Enhancement Number
Cause
Resolution

Defect 30654 is fixed in hot fix 5.1.4.000162 (F000261.U000115) for DB2 on iSeries and DB2 for Linux/UNIX/Windows.
Defect 63280 is fixed in hot fix 5.1.4.000183 for DB2 on z/OS. No fix is available currently.
For download and install instructions see article  Connect for JDBC hot fix download and install instructions

 

Workaround
Notes

For DB2 z/OS, the AlternateID connection property has been modified to set the name of the schema in the DB2 CURRENT SCHEMA special register instead of the DB2 CURRENT SQLID special register. AlternateID now sets the name of the schema in the CURRENT SCHEMA special register for DB2 for i, DB2 for Linux/UNIX/Windows, and DB2 for z/OS.

 

Last Modified Date11/20/2020 7:16 AM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.